Fixora.
Find a tool
Check & prepare data · Flagship

Clean a CSV for import

Review a CSV, tidy its cells and headers, and remove exact duplicate rows without converting identifiers.

Work stays on this deviceInput is processed in this page, not uploaded or saved. Downloads are yours to keep; refreshing clears the workspace.
Your workspace

Prepare a clean import

One CSV, TSV or TXT file · UTF-8 only · up to 10 MB. Original text is preserved until you choose cleanup changes. Drop here, or use the file picker.

Paste CSV instead (optional)

Optional alternative to a file. Editing this text removes its selected file.

UTF-8 text · up to 10 MB, 50,000 data rows and 200 columns. Values stay as strings; dates and identifiers are never inferred.

Options
Blank or colliding header names are rejected, never silently renamed.
Applied after selected trimming. No records are merged by an ID.
Adds an apostrophe to cells starting with =, +, -, @, tab or carriage return, including negative-looking values. This intentionally changes exported text. With this off, spreadsheet apps may run formulas; quoted CSV alone is not protection.
Ctrl / ⌘ + Enter to run

Result

Your cleaned CSV

Run the task to review a counted result here.

Load the example to try the complete workflow.
Limits and next steps

Header row and rectangular records required. No date guessing, inferred numbers, encoding repair or ID-based record merging. Exact duplicate removal is a chosen destructive transformation of output only; the input stays intact. Download and inspect the result before importing it elsewhere.

Reset this workspace?

This clears your input and result. Keep your draft if you still need it; chosen options remain selected.

Keep the task moving
Explore workflow →
CSV file previewExperimental helperPreview the header and first records of a CSV using quoted-field parsing.Compare two CSV exportsMatch unique identifiers across exports and review added, removed and changed records with per-field differences.CSV column selectorExperimental helperKeep selected CSV columns and arrange them in the order you specify.