Tools Features Pricing Blog
Log in Start for free
CSV Normalizer

A CSV cleaner that understands messy data

Most CSV files are internally inconsistent — the same value appears in five different ways, dates use three different formats, and column names don't match anything. Asphorem maps, normalises, and standardises all of it.

Your file rows are never uploaded. AI matching uses unique column values only.

What "dirty" data actually looks like

A dirty CSV isn't broken — it's inconsistent. The same information is expressed in a dozen different ways, and every downstream tool rejects it.

Inconsistent picklist values
closed wonClosed WonCLOSED WONclosd won
Closed Won
Mixed date formats
15/01/2024Jan 20242024-01-15T00:00:00Z
2024-01-15
Cross-language values
TechnologietechTechnology
Technology
Mismatched column names
COMPANY_NAMEcompany nameCompanyName
company

How the CSV cleaner works

Upload your file, define what clean looks like, and download the result. Your file rows never leave your machine — only unique picklist values are shared with the AI for matching.

01

Upload and preview your file

Drop any CSV. Asphorem reads the headers and gives you a preview of the raw data — including a breakdown of unique values per column, so you can see the inconsistencies at a glance.

02

Define your target schema

Tell Asphorem what each column should be called and what type it holds — Text, Number, Date, or Picklist. Set the allowed values for picklist columns. Save this schema as a reusable property set.

03

AI matches and standardises values

For each picklist column, the AI maps every unique cell value to the correct canonical value — catching typos, language variants, abbreviations, and capitalisation differences. Dates are unified to ISO format automatically.

04

Review, override, and download

Every mapping is shown before export. Fix anything the AI got wrong with a single click. Your corrections are remembered for future runs of the same file format.

When you need to clean a CSV

Data standardisation isn't just an import problem. Inconsistent values cause issues anywhere data is read, merged, or reported on.

Merging data from multiple sources

You export data from two CRMs, a spreadsheet, and a data provider. Each has different conventions. Before you can merge them, every column and value needs to match a common standard — or you end up with duplicates and gaps.

Delivering clean data to a client

You collected or processed data on behalf of a client, and they need it in a specific format. Clean the file to match their column names and allowed values before you send it — not after they email you with corrections.

Preparing data for analysis or reporting

Dashboards and BI tools break when the same category appears under twenty different spellings. Standardise your picklist columns first so filters, groupings, and aggregations actually reflect reality.

Importing into a CRM or database

Every CRM validates field values on import. If your data doesn't match the expected picklist, the row either fails or imports blank. Clean the file first so the import works without errors or manual cleanup after.

What stays in your browser, what doesn't

Your CSV file is loaded and processed locally — no rows are ever transmitted to our servers or stored anywhere. The only things we store are your account details and the mapping configurations you create.

When you use the AI matching feature, the unique values from the columns you choose to map are sent to the AI for analysis. These are deduplicated picklist values (e.g. the distinct values found in a "Status" column) — not full rows, not names, not IDs, not any other field you haven't explicitly chosen to map.

If your files contain sensitive picklist values you'd prefer not to share, you can always map those columns manually instead.

0 file rows uploaded
AI sees unique values only

Clean your first CSV in under 5 minutes

Free plan included. No credit card required.

Start for free →