DataTray is a free Windows desktop application that opens and processes data files too large or broken for Excel — multi-gigabyte CSVs, unreadable workbooks, and Parquet files — entirely on your machine. It provides five tools in a tray window: Data Explorer (read-only browsing and profiling), Data Converter (CSV, TSV, Excel, Parquet, JSON, JSONL, XML), Dedupe & Merge, Clean & Anonymize, and Compare Files. No file ever leaves your PC; the app is funded by sharing idle bandwidth through a partner, not by subscriptions or ads.
What is DataTray?
DataTray is a free Windows 10/11 utility that opens, inspects, cleans, converts, dedupes, and compares large or problematic data files without uploading them anywhere. It reads files directly from disk, handles formats like CSV, Excel, Parquet, JSON, and XML, and produces reports and exports you can share. Developed by DataTray (no company name stated), it runs entirely locally with no account or API key required.
Key Features
- No upload, ever — All five tools operate locally; no network requests are made, so your data never leaves your machine.
- No row limit — Opens multi-gigabyte CSVs, forty-sheet workbooks, and Parquet directories by streaming from disk rather than loading into memory.
- Data Explorer — Read-only browsing of any-size files with a Columns tab for data profiling (nulls, mixed types, outliers, data quality) and a SQL tab for querying.
- Data Converter — Converts between CSV, TSV, Excel, Parquet, JSON, JSONL, and XML; combines multiple files into one or splits one into many.
- Dedupe & Merge — Deduplicates with exact, normalized, or fuzzy matching; produces a removals report showing every dropped row and the reason.
- Clean & Anonymize — Automatically finds and fixes issues like trailing whitespace, inconsistent date formats, numbers stored as text, and encoding problems; also detects personal data for masking, hashing, or tokenizing.
- Compare Files — Diffs two files, sheets, or Parquet directories, reporting schema drift and cell-level changes with numeric/date tolerances; outputs an .xlsx with a sheet per category.
Who is it for?
- Data analysts who need to open and profile files that exceed Excel's row limit or are corrupted.
- Business users who must clean and dedupe customer lists, then share a clear report of what was removed.
- IT or operations staff who need to convert between formats like Parquet and Excel without writing code.
- Privacy-conscious professionals handling sensitive data (salaries, patient records) who cannot upload files to web converters.
What can you do with DataTray?
- Open a 2GB CSV that Excel refuses to load, browse its rows, and generate a data-quality report.
- Merge twelve CSV files into one Excel workbook, or split a large file into smaller chunks.
- Dedupe a contact list with fuzzy matching to catch "Acme Corp." vs "ACME Corp", and export a removals report.
- Anonymize personal data in a spreadsheet before sharing it, by masking or hashing columns flagged as sensitive.
- Compare two versions of a report to see exactly which rows changed, ignoring float noise and timestamp granularity.
How does DataTray work?
After downloading and installing, you open the tray window and choose one of five tiles. Each tool reads your file directly from disk, shows a preview, and lets you configure options (e.g., match type for dedupe, tolerance for compare). When you run the operation, DataTray produces an artifact — a self-contained HTML report and/or an .xlsx file — that you can save or send. The app is funded by sharing idle bandwidth through a partner called Massive, which is disclosed at install and can be disabled in Settings.
Pricing
DataTray is free for Windows 10 & 11. There is no subscription, row limit, or account required. The app is supported by sharing a slice of idle internet bandwidth through a partner, which you can opt out of in Settings.
