Local DuckDB SQL
Drop a CSV, TSV, or Parquet file, then query it with SQL in the same Mac app. No database server to start.
Local CSV triage · DuckDB SQL · 14-day trial
Too big for a spreadsheet. Too small for a database project.
Open CSV, TSV, and Parquet files locally on your Mac, query them with DuckDB SQL, build pivots, validate dtypes, and export clean data without turning one file into a full database project.
$14.99 lifetime · 14-day trial · local files stay local · direct Mac download
LOCAL FILE · DUCKDB
select region, sum(revenue) as revenue
from orders
where status = 'paid'
group by region
order by revenue desc;
from orders
where status = 'paid'
group by region
order by revenue desc;
RegionRevenuerowsdtype
West$482k184kNUM
North$391k163kNUM
APAC$338k148kWARN
SQLPivotParquetJSONL
Why this exists
Keep the middle workflow on your Mac.
Some raw exports are too large or too structured for a spreadsheet pass, but too small to justify a warehouse import, notebook, or database project. Mac CSV Power Editor is for that gap: inspect the file, run the query, fix the shape, export the result.
It is built for the first 10 minutes of local data work: confirm the file opens, check the schema, ask one SQL question, catch dtype problems, and save a clean result for the next tool in your workflow.
Pivot and export
Build quick summaries, then export results to CSV, TSV, Parquet, or JSONL for the next tool in your workflow.
dtype validation
Spot columns whose values do not match the inferred type before a downstream import or batch job fails.
LLM batch JSONL
Turn CSV rows into Anthropic Message Batches or OpenAI Batch JSONL using your own API key stored in Keychain.
Workflow
01
Open a local CSV, TSV, or Parquet file.
02
Inspect schema, row count, and dtype warnings.
03
Run SQL, search results, edit cells, or build a pivot.
04
Export a clean file for DuckDB, Python, BI tools, or LLM batch APIs.
14-day trial. $14.99 lifetime.
The free tier covers small files and a few SQL runs. A license pays for the moments where a raw export would otherwise send you into import scripts, notebooks, or a web upload tool: large files, Parquet, unlimited SQL, Pivot, and LLM batch validation.
macOS 13+Direct Mac downloadSigned updatesDuckDB engineKeychain for API keysNo subscription
FAQ
Who is this for?
Mac users who need to inspect raw exports before they become a database task: analysts, operators, developers, founders, and consultants working with local CSV, TSV, or Parquet files.
Why not just use a spreadsheet or notebook?
Use a spreadsheet for small, formatted workbooks. Use a notebook for repeatable analysis. Mac CSV Power Editor sits between them: quick local inspection, SQL, pivots, dtype checks, and export when you only need to understand the file in front of you.
Does it upload my files?
No. File loading, SQL queries, pivots, dtype checks, and exports run locally on your Mac. License activation and Sparkle update checks are the network features.
What is included in the free tier?
Files under 10 MB or 100k rows, viewing, 5 SQL runs per session, and small CSV export remain available without a license.
What does the license unlock?
Large files, Parquet read/write, unlimited SQL runs, Pivot UI, and LLM batch CSV validation are paid features.
Is it a subscription?
No. Mac CSV Power Editor is $14.99 lifetime for this major version, with a 14-day trial and no subscription.
Where do support or refund requests go?
Email support@temperstone.net. The refund policy is linked in the footer.