What it does
Upload a messy CSV or spreadsheet. Select the columns you want to keep, rename any headers, clean up dates and amounts, and download a tidy CSV — without opening Excel or writing formulas.
Who this is for
Anyone who regularly receives data in one format and needs it in another:
- Analysts cleaning exports before loading into a database or BI tool
- Operations teams reformatting vendor data for internal systems
- Finance teams normalising reports from multiple sources before consolidation
- Developers who need a quick data-shape tool without spinning up a script
What it handles automatically
- Column selection — Keep only the columns you need; ignore the rest
- Header renaming — Rename any column header without touching the data
- Date standardisation — Detects date columns and converts to ISO 8601 (YYYY-MM-DD) or any other format you specify
- Currency cleaning — Strips symbols and commas from numeric columns
- Whitespace normalisation — Trims leading/trailing spaces and collapses internal whitespace in text fields
- Encoding — Outputs UTF-8 with optional BOM for Excel compatibility
How it works
- Upload your file (CSV, XLSX, or TSV)
- See all detected columns with their inferred types (date, currency, text, etc.)
- Select which columns to include and rename any headers
- Preview the first 5 rows of the cleaned output (free)
- Export the full cleaned file — one-time $5
Use cases
Cleaning a vendor data export for database import
Your vendor sends a CSV with 40 columns. You need 8 of them, renamed to match your schema. Dates are in dd-mmm-yy format; your database wants YYYY-MM-DD. Use the generic cleaner to select, rename, and convert in one pass.
Normalising reports from multiple teams Three teams export the same data with different column names and date formats. Run each through the generic cleaner with consistent output settings to produce files you can stack vertically.
Preparing a custom import Building a schema tool for isn't in the Nanoscope catalog yet? Use the generic cleaner to get your data into a clean, consistent shape, then map it to your target system manually.
FAQ
How is this different from the QBO or Xero tools? The QBO and Xero tools know exactly what those platforms require and enforce those requirements. The generic cleaner has no fixed target — you define the output shape yourself. It's more flexible but less opinionated.
Can I reorder columns? Yes. The output column order follows the order you select them in the mapping step.
Does it handle Excel files? Yes — .xlsx files are supported as input. The output is always CSV.
Does it store my data? No. All processing happens in your browser. Nothing is stored or transmitted.