DataTray - Windows data file utility belt
DataTray is a specialized Windows utility designed for inspecting, converting, cleaning, and comparing large data files that exceed standard spreadsheet limits. Operating locally from the system tray, it processes large CSV, Excel, Parquet, JSON, and XML files directly on the machine without uploading any content to external servers or requiring a user account. The application is built to handle files that typically break traditional spreadsheet programs, offering comprehensive inspection and modification features without compromising data privacy.
- Data Explorer: Opens files of any size to inspect rows, generate column data profiles, evaluate nulls and outliers, and review automatic data dictionaries or execute read-only SQL queries.
- Data Converter: Transforms files across CSV, TSV, Excel, Parquet, JSON, JSONL, and XML formats, allowing multi-file combinations or large-file splits.
- Dedupe & Merge: Removes duplicate records using exact, normalized, or fuzzy matching rules, and outputs a complete removals report detailing every dropped row.
- Clean & Anonymize: Automatically detects formatting errors, fixes whitespace and date discrepancies, and applies mask, hash, or tokenize rules to personal data.
- Compare Files: Evaluates schema drift and cell-by-cell row differences between two files, sheets, or Parquet directories, generating an organized Excel summary workbook.
Data analysts, developers, and operations professionals dealing with heavy datasets benefit from its local processing model and comprehensive reporting outputs. The application is provided as a free tool for Windows 10 and 11, sustained through an optional, transparent idle internet bandwidth-sharing network partnership.
