Import, Query, and Visualize Raw Data | TextQuery
TextQuery is a local-first desktop application for importing raw files, querying and editing them with SQL, and creating shareable charts. It targets macOS and Windows users who want database-like workflows without defining schemas or writing import scripts.
Import, Query, and Visualize Raw Data | TextQuery
Author: TextQuery | Published: Unknown | Generated: 2025-05-05 | Domain: textquery.app
Tags: ‘#SQL’ ‘#data-analysis’ ‘#desktop-app’ ‘#data-visualization’ ‘#privacy’
TLDR
TextQuery is an all-in-one macOS and Windows desktop app for locally importing, querying, modifying, exporting, and visualizing raw data through SQL. It supports spreadsheet, delimited-text, JSON, and compressed archive formats without requiring schema definitions, code, or command-line imports. The product emphasizes a perpetual license, local privacy, keyboard-driven workflows, and built-in charting.
Key Takeaways
- No-schema file imports: TextQuery imports
.xlsx,.xls,.csv,.tsv,.json,.jsonld,.zip,.gz,.tgz, and.tarfiles without users defining schemas or writing import commands. - SQL-focused workspace: Its editor includes SQL autocomplete, query history and favorites, formatting, and multiple selections; tabs enable concurrent work across queries and tables.
- Built-in visualization: Users can create line, bar, area, scatter, and pie charts, customize titles, descriptions, and colors, then export charts or copy them to the clipboard.
- Data editing and export: Inline edits can be collected and committed together; filters narrow rows without manually writing queries; results can be exported as CSV, JSON, Excel, or SQL, or materialized as another table.
- Local-first commercial model: TextQuery says it does not record or transmit usage-related data, offers a free version with limitations, and sells a perpetual license with free updates rather than a recurring subscription.
Images & Media
- TextQuery hero interface — Main product interface preview.
- Import data workflow screenshot — Demonstrates importing data files into the application.
- SQL editor screenshot — Shows the SQL editing environment.
- Chart creator screenshot — Illustrates in-app chart creation and customization.
- Inline editor screenshot — Shows direct table-value editing.
- Filters screenshot — Shows row filtering controls.
- Tabs screenshot — Depicts simultaneous work across multiple tables and queries.
- Data export screenshot — Shows available data export options.
Referenced Links
- Download TextQuery — Download the desktop application for macOS and Windows.
- Pricing and free-version limitations — Details the free tier and Pro upgrade.
- Chart Builder — Free browser-based chart-building tool.
- Query Excel Files With SQL — Use-case guide for SQL queries against Excel files.
- Query JSON Files With SQL — Use-case guide for SQL queries against JSON files.
- Privacy Policy — TextQuery’s privacy terms.