Workflows

Clean a customer list

Trim and normalize fields, convert types, then remove duplicate customers by key columns.

Import CSV or XLSX
Clean table data
Remove duplicate rows
Export CSV, XLSX or JSON

Process locally

Files stay in this browser session. Closing or clearing releases them.

Import recipe

Choose files

CSV, XLSX, one at a time

Drop files here, or

Choose files

Check and adjust

Optional: Format, Encoding, Delimiter and more; Inspect and confirm

Import CSV or XLSXFormatEncodingDelimiterFirst row is headerWorksheetempty selects the only sheet

Column types

Once the input is read, choose a type for each column. Text is the default.

Clean table dataTrim spacesColumns to trimLowercase columnsUppercase columnsTreat empty text as missingMissing valuesFill valueValues that cannot convert

Remove duplicate rowsKey columnsempty compares whole rowsKeepMissing keysCase sensitiveIgnore surrounding spaces

Export CSV, XLSX or JSONFormatUTF-8 BOMFormula injection protectionOutput file name

Run

Every step runs in order in this browser; cancel at any time

I inspected inputs and confirmed order, ranges and conversion settings

Choose files first