Xargaar ToolsMessy spreadsheet in. Clean file out.
Convert between CSV, Excel and JSON. Remove duplicates, clean up spaces and blank rows, split a big file into parts, or merge several files by column name. Your data stays on your device.
Save the active file in another format. The first row is treated as the header.
Rows count as duplicates when the ticked columns match. The first one is kept.
Each part keeps the header row. You get one ZIP.
Stack all loaded files into one. Columns are matched by header name, so the column order can differ between files. Add at least two files.
How it works
The delimiter and text encoding are detected for you. Excel files can have several sheets, pick the one you need.
Convert, clean, remove duplicates, split or merge. A preview shows the first rows.
Save as CSV, Excel or JSON. Several output files come as one ZIP.
No software row cap. Works offline.
- The free page handles up to 1000 data rows per file. The pack has no row limit.
- One folder you keep. Open index.html in Chrome, Edge, Firefox or Safari. No install, no account.
- Good for customer lists, exports and files you are not allowed to upload.
Questions
Are my files uploaded?
No. Everything runs in this page on your device. No server receives your data.
Will leading zeros and long numbers survive?
CSV and text values are read and written as text, so 00123 stays 00123 and long IDs are not turned into 1.23E+15. Excel input reads stored values, not displayed zero-padding or formulas without cached results. Excel output numbers are only used if you tick the number option, and even then values with leading zeros stay as text.
How are Excel dates handled?
Cells formatted as dates are written as yyyy-mm-dd (with the time if there is one). Formulas are read as their last calculated value.
What does the formula protection do?
Spreadsheet programs run text that starts with = + - or @ as a formula. If a file comes from an untrusted source, tick the option and those cells get a leading apostrophe so they are shown as plain text.
Which files are supported?
CSV, TSV, text files with a delimiter (comma, semicolon, tab or pipe), .xlsx and JSON (an array of objects). Old .xls files are not supported: open them in Excel and save as .xlsx or CSV first.