Reshapes your file
Data Converter
The formats data actually arrives in, converted to the one your manager wants. Twelve files into one, or one file into twelve — because converting, combining and splitting are the same job at three different cardinalities.
Windows 10/11 (x64) · Free · No account
Converted files land in DataTray's output folder with a dated, self-describing name. Your source file is never modified and never overwritten.
What you can do
What people use it for — Data Converter
The jobs this one actually gets opened for.
- Turning a Parquet file from a data team into an .xlsx somebody can actually open.
- Converting a 3 GB CSV to Excel format without hitting a web tool's upload cap.
- Merging twelve monthly exports into one table, with a column recording which file each row came from.
- Splitting one enormous file into per-region files in a single pass.
- Getting a fixed-width bank or government extract into something usable.
What it does
Everything Data Converter handles
Everything this tool handles, and how it handles it.
The formats that actually turn up
CSV, TSV, PSV and fixed-width, Excel (xlsx, xls, xlsb), Parquet, JSON, NDJSON and XML — plus HTML tables and SQL inserts on the way out. Most directions between them are supported.
Forty sheets is not an error
A multi-sheet workbook offers a sheet picker and fans out one output per sheet you choose, instead of silently converting the first one and losing the other thirty-nine.
Leading zeros survive
Postcodes, 18-digit IDs and ISO dates come out the other side intact, because the target type is explicit rather than guessed. This is the single commonest complaint about converting a file by opening it in Excel first.
Combine, without matching schemas first
Point at a folder. Columns that disagree are unioned by name rather than failing, with a reconciliation view showing which columns appear in which files and where the nulls will land. Add a source-file column so you can tell afterwards where a row came from.
Split, with the headers intact
By row count, by size, by sheet, or by a column's distinct values — one pass writes a folder per region. Headers repeat in every part, which is the thing hand-rolled splitters get wrong and the reason their output is unusable.
CSV that opens properly in Excel
UTF-8 with a BOM, the Windows list separator where that is not a comma, and CRLF line endings — stated in words on the panel rather than hidden behind an Advanced toggle, and overridable in one click for anyone feeding a script.
How it works
From your file to the result
- 1
Drop in files or a folder
DataTray detects each format and shows you what it found. Mixed formats in one run are fine.
- 2
Pick the shape
Convert each file, combine them into one, or split one into many. Dropping twelve files offers the first two; dropping one offers the first and the third.
- 3
Choose the target and run
Set the output format and its options — Parquet compression, CSV encoding, per-column types — and the batch runs as one job per source and target.
Under the hood
Formats, limits and defaults
One read path and one write path, with only the plumbing between them changing.
- Reads
- CSV, TSV, PSV, fixed-width, XLSX, XLS, XLSB, Parquet, JSON, NDJSON, JSONL, XML
- Writes
- CSV, TSV, PSV, XLSX, Parquet, JSON, NDJSON, XML, HTML table, SQL inserts
- CSV defaults
- UTF-8 with BOM, Windows list separator, CRLF, minimal quoting — all overridable
- Parquet
- zstd by default; snappy, gzip or none
- Batch
- Whole folders, and one job per source × target
Documents belong to BizTray, not here — .docx, .pptx, .odt and PDF are its job. DataTray takes anything with a columnar or delimited shape on at least one side.
The rest of the belt
The other four tools
Questions
Data Converter, answered
Get it free — Data Converter
Data Converter ships in DataTray, free for Windows 10 and 11. No account, and nothing uploads.
Windows 10/11 (x64) · Free · No account