A 400 MB CSV that has to become INSERT statements for a staging database, 900 Excel workbooks that each need a JSON twin, and an XML export from a partner system that nobody can open. Three different jobs, one question: which converter actually does this on your own machine, for all the pairs you need, without a browser tab and an upload?
These are the tools that come up for data file converter and csv to sql converter, what each one is genuinely good at, and how to pick without discovering the gap halfway through the batch.
Disclosure: DataFileConverter is our own product. It gets its own section after the alternatives, and it is in the table so you can compare everything at once.
How to judge a data file converter
The criteria that decide whether a converter survives a real migration, not a demo file:
- How many pairs does it cover? Every tool can do CSV → Excel. The question is whether it also does JSON, XML, SQL, TSV, TXT and the awkward ones — and in both directions, or only the direction the vendor cares about.
- Does the file leave your machine? Online converters upload it to someone else’s server, which is fine for a public dataset and a compliance problem for anything with customer names in it.
- Batch, or one file at a time? A hundred files through a wizard is not batch conversion. Look for folder/recursive input, a saved job you can re-run, and a CLI you can put in cron.
- Does it respect the shape of the data? Nested JSON and XML have to be flattened into columns on purpose (or kept nested on purpose). SQL output needs a table name,
INSERTbatching and the right quoting per database. Excel means sheets, header rows and possibly several tables. Naive converters stringify everything and lose the structure. - What happens at a million rows? Loading the whole file into memory works until it doesn’t. Streaming is what keeps a 400 MB file from becoming a 3 GB process.
- Column mapping. If the input header is
Cust ID, Amount, Dateand the target wantscustomer_id, amount, posted_at, you want to map it once and apply it to every file in the batch — not rename columns in Excel first. - Price model and platforms. One-time licence or a monthly credit subscription for a job you do twice a quarter? Windows only, or Windows/macOS/Linux — and does the CLI exist for the Linux server where the nightly job actually runs?
The comparison
| Tool | Best for | Price | Watch out |
|---|---|---|---|
| Total CSV Converter | CSV out to Excel, PDF, JSON, XML with a lot of output options | $59.90 (Windows) | CSV-centric: it is a CSV converter, so JSON → SQL or Excel → SQL is not the job it solves |
| Total Excel Converter | Excel/ODS out to 20+ formats, including PDF | $49.90 (Windows) | Same vendor, Excel-centric: the source has to be a spreadsheet, XLS/XLSX/ODS → PDF |
| Convertio | a one-off conversion with nothing installed | $11.99–$44.99/month (annual billing from $6.99/month) | Browser-based: the file is uploaded; plans are credit-based with 1–10 GB size caps |
| DataFileConverter | many pairs both ways — CSV/JSON/XML/Excel/SQL/TSV/TXT/RDF — offline, batch, with a CLI | $75 one-time, free trial | Desktop install; it converts data files, not documents or images |
The free scriptable baseline (ssconvert, csvkit, jq, pandas) is in its own section below; our product follows the alternatives.
Total CSV Converter — CoolUtils
A long-standing Windows utility from a vendor that has built one converter per file type. Total CSV Converter reads CSV/TSV and writes Excel, PDF, JSON, XML, SQL, HTML, TXT, DBF, with options for delimiter, encoding and output naming, and it does batch folders.
If your job is “turn 500 CSV files into Excel/JSON for review”, this is a tidy, well-trodden path at $59.90. What it is not: a general converter. The input is CSV, so the moment the task is Excel → JSON or XML → SQL you are looking at a different product from the same shop — which is how you end up buying three licences.
Total Excel Converter — CoolUtils
The spreadsheet-side sibling, $49.90: XLS/XLSX/ODS in, and 20+ formats out, with PDF as the headline. Sheet selection, header/footer and page-setup options matter if the output is a PDF; they matter less if it is data.
Same trade-off, mirrored: the source must be a spreadsheet. It also illustrates the pattern to watch for in this category — one product per direction. Three directions, three licences, three installers.
Convertio — the online option
The honest case for an online converter: nothing to install, it handles formats you have never heard of, and for a single 20 MB file it is genuinely faster than buying anything. Convertio is one of the better ones — the free tier, then Lite $11.99/month, Basic $22.99, Pro $44.99 (annual billing brings those to $6.99 / $13.99 / $25.99 per month), with 1 GB, 3 GB and 10 GB maximum file sizes and monthly conversion credits.
The honest case against: your file is uploaded to their servers, the size cap is exactly where big data files live, credits are consumed per conversion, and a job that runs nightly needs a human, a browser and a session — not a cron entry.
The free baseline: ssconvert, csvkit, jq, pandas
If the pipeline is already code, the free answer is a script:
ssconvert(Gnumeric) converts spreadsheet ↔ CSV/TSV from the command line, free and cross-platform.csvkit(csvjson,csvsql) turns CSV into JSON or straight intoCREATE TABLE+INSERT— this is the closest free equivalent to “CSV to SQL”.jqreshapes JSON, and pandas (read_csv→to_json/to_excel/to_sql) covers the matrix in a dozen lines.
All free, all scriptable, all requiring you to write and maintain the script — and all of them will happily eat 10 GB of RAM on a big read_csv if you forget the chunking.
Also considered: Advanced CSV Converter (Silver Lake Software)
The other name that shows up in this category, CSV-first like Total CSV Converter. We are not listing it in the table because the vendor site did not respond when we checked on 2026-10-27 (connection reset on both HTTPS and HTTP), so neither its price nor its current version could be verified. Treat any figure you find elsewhere as unconfirmed.
DataFileConverter — for many pairs, on your own machine
DataFileConverter (version 6.5.4) is our converter for CSV, TSV, TXT, JSON, JSONL, XML, HTML, Excel (XLS/XLSX), SQL and RDF (TTL / N-Triples / N-Quads), on Windows, macOS and Linux:
- Both directions, and the awkward pairs. 110 ordered X→Y pages exist under /tools/file-to-file/, including Excel → JSON, CSV → XML, XML → SQL and RDF → CSV. The licence is not split per direction.
- 100% offline. The conversion runs locally; nothing is uploaded, which is the reason most of our users are here.
- Batch that behaves like batch. Point it at a folder (optionally recursive), pick the output naming, and it processes the set — one file or millions of rows at a time, streamed rather than loaded whole.
- The shape is preserved. Choose the sheets in a workbook, the table name and
INSERTbatch size for SQL, and the shape of the JSON output — an array of records, JSON Lines, or named arrays — and whether a nested structure is flattened into columns. - Map the columns once. Rename and reorder the input columns to the target schema, then apply that mapping to every file in the batch instead of editing headers first.
- A real CLI. The same jobs run headless with session files, so a nightly conversion on a Linux box is a cron line, not a GUI session.
- Preview before you commit — the first rows, the parsed columns and the target format, before 900 workbooks are processed.
Free trial, then $75 one-time — no subscription, no per-direction licences. See DataFileConverter or the download page. If the job is really “get this into a database”, the sibling products FileToDB and DBToFile go the last mile.
Which one to pick
- The input is always CSV, the output is a document or a spreadsheet: Total CSV Converter — $59.90, mature, does exactly that.
- The input is always Excel, and sometimes the output is a PDF: Total Excel Converter — $49.90.
- One file, unknown format, nothing installed, not sensitive: an online converter such as Convertio — cheapest and fastest for a one-off.
- The pipeline is code anyway:
csvkit+jq+ pandas, free, and you own the script. - Many directions, sensitive files, batch and a scheduler on Linux as well as a desktop on Windows: DataFileConverter — $75 once, and the licence covers the pairs you did not anticipate.
How to convert Excel to JSON in four steps
- Open DataFileConverter and choose the conversion — the wizard lists the source and target formats, so the pair is explicit rather than inferred from the file extension.
- Pick the source workbook; when it has several sheets, choose which ones are converted instead of accepting “the first one”.
- Set the JSON shape — an array of records, JSON Lines, or named arrays — and preview the parsed rows before running.
- Save the job as a session file if it will run again:
csv-to-sql.sdf-style sessions can be re-run from the GUI or from the command line, which is how the same conversion gets scheduled.
Frequently asked questions (FAQ)
Is there a free data file converter?
Yes — for one direction at a time. csvkit (csvjson, csvsql), jq and pandas are free and scriptable; ssconvert converts spreadsheets from the command line; online converters such as Convertio have a free tier with file-size and credit limits. DataFileConverter is paid, with a free trial.
Can I convert CSV to SQL without uploading the file?
Yes, and if the data is customer or financial data, that is the deciding requirement. A desktop converter writes the INSERT statements locally; an online converter uploads the CSV first.
What is the difference between JSON and JSONL output?
JSON is one document — usually an array of records, which has to be parsed whole. JSONL (JSON Lines, NDJSON) puts one record per line, so a 2 GB export can be streamed and appended to rather than loaded. Both are output options for the same conversion.
How many rows can it handle?
The product page’s figure is millions of rows per minute, and conversions stream rather than load the file into memory. The practical limit is disk and time, not RAM — but test on your own file size before committing a nightly job to it.
Does it work on macOS and Linux, or only Windows?
DataFileConverter ships for Windows, macOS and Linux, with the CLI on all three — the Linux build is what a server-side cron job uses. The CoolUtils converters are Windows-only; online converters are platform-free by definition.
Can I schedule the conversion instead of clicking through it?
Save the job as a session file and run it from the command line, then call that from cron or Task Scheduler. That is the difference between a converter and a repeatable pipeline, and it is the first thing to check in any tool that claims batch support.
Final thought
Pick by the pair you need and by who owns the file: one direction on Windows (Total CSV Converter, Total Excel Converter), one file right now in a browser (Convertio), a script you control (csvkit/jq/pandas), or many directions with the data staying on your machine (DataFileConverter). The expensive mistake in this category is not the licence price — it is buying one converter per direction and then discovering that the fourth direction is not covered at all.
Facts checked October 2026. Prices, versions and supported platforms change — verify on each vendor’s page before buying.
Sources: Total CSV Converter ($59.90, checked 2026-10-27) · Total Excel Converter ($49.90, checked 2026-10-27) · Convertio pricing (Lite $11.99/month or $6.99/month billed yearly; Basic $22.99 / $13.99; Pro $44.99 / $25.99; 1/3/10 GB maximum file size — checked 2026-10-27) · Advanced CSV Converter (vendor site unreachable 2026-10-27, price unverified) · Gnumeric ssconvert, csvkit, jq, pandas documentation · DataFileConverter 6.5.4 and product page ($75 one-time).
Data File Converter without the manual work
For batch jobs, large files and scheduling use the Data File Converter converter — an offline desktop app for Windows, Linux and macOS. Free trial.