Spreadsheet Cleaning and Comparison Workbench
Clean XLSX/CSV locally in the browser, compare two tables by unique key, and generate Markdown tables or synthetic test data.
How to use the spreadsheet cleaning and comparison workbench
Spreadsheet files and generated results are processed only in the current browser’s memory and are not uploaded; the page does not persist content by default.
Select a work mode
Choose cleaning, comparison, Markdown tables, or test data generation.
Load or paste data
Read the first worksheet in file mode XLSX/CSV; text mode supports CSV, TSV, and semicolon-separated content.
Review and export
Review the preview, cleaning statistics, or change summary, then download CSV, JSON, or Markdown.
Limitations and Notes
- XLSX mode processes only the first worksheet, does not recalculate formulas, and does not preserve styles, charts, macros, or complex layouts; the exported result is a data-level CSV/JSON.
- Difference comparison requires both tables to have non-empty, non-duplicate unique keys; cells are compared as text after trimming leading and trailing whitespace.
- Test data is entirely fictional and cannot be used for impersonation, real-world contact, or production credentials.
FAQ
Why export XLSX as CSV?
This tool focuses on verifiable data cleaning; CSV does not claim to preserve the original workbook’s styles, formulas, or charts.
Which key should I select for comparison?
Select a column that exists in both tables and is unique in every row, such as an order number, employee ID, or SKU.
Will files be uploaded?
No; reading, comparison, and downloading are all performed locally in the current browser.