ZenQuery

Your Data. Your Language. Instant Answers.

Get instant answers from your data files — CSV, JSON, Excel, Parquet — using plain English.

No coding or SQL required •|• Costs less than a single dollar to get thousands of your questions answered •|• Handle files with tens of millions of rows in seconds •|• Mix and match files of different types in same question •|•️ Full data privacy

Image displaying data analytics related to a specific domain (e.g., ecommerce, human resources, logistics, marketing)

Why ZenQuery?

Unlike traditional tools, ZenQuery combines speed, cost-effectiveness, power, and simplicity in one elegant solution.

🚀

Unlike Excel & Similar Tools

Tired of Excel and other similar tools choking on files with just 100K rows and freezing your computer? ZenQuery is built for speed—effortlessly handling tens of millions of rows without breaking a sweat. Work at scale without the lag.

💰

Unlike ChatGPT & Other AI Chat Tools

Tools like ChatGPT can burn through hundreds of dollars just to answer a few hundred questions on modest-sized files (just around 1 MB). In case your files are over a few dozen MBs? You're out of luck — they simply can't handle it because of their context limits. ZenQuery is built for real-world data, without the cost or limits.

⚙️

Unlike Database Solutions

Forget the hassle of setting up databases, wrestling with table schemas, loading data, and hand-crafting SQL for every little question. ZenQuery removes all that friction — just drop in your files and ask. No setup, no syntax, just answers.

⏱️

Unlike Python & Pandas Workflows

Scripting in Python or Pandas just to filter or summarize a CSV? That’s many tens of minutes lost to boilerplate, debugging, and runtime errors. ZenQuery gives you instant answers — no coding, no Jupyter notebooks, no imports.

🧠

Unlike Manual Data Exploration

Manually scanning rows and columns in Excel or writing repetitive filters in scripts? ZenQuery turns exploration into a conversation. Just ask what you want to know, and get smart, contextual answers in seconds.

🔒

Unlike Cloud-Only Tools

Concerned about data privacy when uploading sensitive files to the cloud? ZenQuery runs locally, keeping your data secure and compliant while still delivering powerful query capabilities.

Sample Questions You Can Start Asking Immediately

📊 E-commerce

  • What are the top 10 best-selling products this month?

  • Which products have high views but low conversions?

  • Show me revenue by product category

📧 Marketing

  • Show me email campaigns with the highest open rates

  • Which channels drove the most traffic last quarter?

  • Compare conversion rates by campaign

💼 Sales

  • List all leads converted by each rep this month

  • Who are our top 20 customers by revenue in 2024?

  • Show me sales trends by region

💼 Human Resources

  • Find the top 5 highest-paid employees and their roles

  • List all employees hired after January 1, 2020

  • Show average salary by performance rating

💼 Logistics

  • Find the average delivery time and average delay per route.

  • Get the total number of orders fulfilled per SKU

  • Find average pick and pack time per warehouse zone

💼 Debugging Data Files

  • Find rows with missing or null values in any column

  • Detect duplicate rows based on key columns

  • Check timestamp column for outliers or gaps

💼 Healthcare

  • Find patients with most hospital visits in past 6 months

  • Average treatment cost per department

  • Detect missing discharge summaries or vital signs

💼 Finance / Banking

  • Find transactions over $10,000 without justification notes

  • Compare loan default rates across customer segments

  • Find accounts with inconsistent balances over time

Extremely Cost-Effective

Ask thousands of questions for under a dollar

(Example for a single CSV with 10 numerical columns)

Model Quality Questions Per Dollar Use For
openai/gpt-4.1-mini Close to Best,

Recommended ⭐

4,500 Daily usage for simple to complex questions
openai/gpt-4o Best 300 Very complex and detailed questions
google/gemini-2.0-flash Very Good 18,000 Extremely heavy usage up to moderately complex questions
deepseek/deepseek-chat-v3 Very Good 6,500 Heavy usage up to moderately complex questions
openai/gpt-4o-mini Good 12,000 Very heavy usage up to low-moderately complex questions

Frequently Asked Questions

What file formats does ZenQuery support?

ZenQuery supports CSV, JSON, Excel/XLSX, Parquet, JSONL, and NDJSON files. You can mix and match different file types in a single session for comprehensive analysis.

How much does it cost to use ZenQuery?

ZenQuery is extremely cost-effective. With our recommended model (gpt-4.1-mini), you can ask around 4,500 questions for just $1. Costs depend on the number of files, not their sizes.

Is my data secure and private?

Yes, absolutely. By default, only the first 3 rows of your data are shared with the LLM for analysis. You can adjust this to zero in settings if needed. Your files never leave your computer.

What's the maximum file size ZenQuery can handle?

ZenQuery can easily handle files with millions of rows and multi-GB sizes. Unlike Excel which slows down with large files, ZenQuery processes massive datasets in under 5 seconds.

Do I need to know SQL or coding to use ZenQuery?

Not at all! ZenQuery is designed for non-technical users. Simply ask questions in plain English like "What are my top 10 customers by revenue?" and get instant answers. If you are a data analyst, use this to quickly get auto-generated sql queries.

Which LLM providers are supported?

ZenQuery works with any OpenAI-compatible service (almost all providers supported). We recommend OpenRouter for beginners, but you can also use OpenAI directly or other compatible providers.

Can I use multiple files in one analysis?

Yes! You can combine multiple files of different formats in a single session. ZenQuery will analyze them together, allowing for comprehensive cross-file insights.

What operating systems are supported?

Currently, ZenQuery is available for MacOS and Windows, with versions optimized for both ARM, M-Series and Intel processors. Linux versions are being developed. Do drop us an email if you're interested :)

Download ZenQuery

14-day free trial. No credit-card required. Then one-time payment of $20 and use forever on one device.

(Linux versions available on request)

Mac (M-Series Chips)

Optimized for M-series chips

Mac (Intel Chips)

For older Mac computers

Windows (Intel Chips)

Most Common Windows PCs

Windows (ARM Chips)

For Surface Pro X & other ARM PCs

Quick Setup Guide

1

Download & Install

Choose your Mac version and install

2

Get API Key

Sign up at OpenRouter or OpenAI

3

Add Your Files

Add files you want to analyze

4

Start Querying

Ask questions in plain English


Detailed Usage Guide | Detailed Video Guide

You can also pay directly from the app