All-in-One macOS Tool to Query CSV Files

TextQuery lets you quickly import CSV files as a table, query it using SQL, and create stunning charts from those results.

 
Watch The Demo

Q&A

Is TextQuery free?

TextQuery has a pro version and a free-forever version which has the same features as pro, but a few limitations (see below).

What's are the limitations of free version?

The free version has four limitations

  • The max file that can be imported is 50MB.
  • Only upto 10 tables can be created.
  • The charts created will have a tiny branding
  • No automatic updates.

What kind of License comes with TextQuery Pro?

TextQuery has a perpetual license, which means you can keep using the app without any limits forever. However, with a single license you're entitled to only one year of updates. After which, you can renew to receive additional updates.

Does TextQuery send any data to servers?

Privacy and Data Protection were key principles in building TextQuery. I can assure you that TextQuery tracks no activity inside the app, nor sends any data you analyze. The only communication that happens between app and the server is related to licensing.

What underlying database is TextQuery powered by?

TextQuery uses DuckDB. Every table imported is a DuckDB table. DuckDB was an ideal choice because of its performance, columnar design, and its rich querying language.

How is TextQuery different from X?

X here could be Postgres, SQLite, Excel, Observable, datawrapper, or Chat GPT. Each of those options have their own pros/cons. Where TextQuery wins is making things easier (no schema creation, writing boilerplate code, or CLI commands), have both querying and visualization in one place, and have it as a completely offline experience (fast + no worries about querying sensitive data).

What are the features on TextQuery's roadmap?

Tons of things. I started TextQuery to solve a personal pain-point, so I have an ambitious roadmap to solve it better and better. In no order of importance: support for more files (XLSX, JSON, gz), support for fetching files from URL, support for updating tables with new data, better SQL completion, better handling of invalid CSVs, better support for editing rows.

Is TextQuery an Electron App?

Yes. Apologies, but it's the fastest way I could have shipped the app. Though, I would say that TextQuery is pretty fast and snappy, and Electron apps can generally be if care is taken. I recommend not getting disuaded by the choice of technology and try the app out.

Who is behind TextQuery?

TextQuery has been build and designed by Shubham Jain.