Browser-local workflow

CSV Data Cleanup Toolkit

Inspect, clean, reshape, and convert CSV files in a dependable browser-local workflow.

Best for
Analysts, operations teams, and developers preparing spreadsheet exports for another system.
Expected outcome
A smaller, consistent, duplicate-free dataset with the columns and delimiter your destination expects.

Run the tools in this order

  1. 1

    Inspect the file

    Preview rows, encodings, headers, and delimiter assumptions before changing anything.

    Open tool
  2. 2

    Keep the needed columns

    Select and reorder fields without copying the dataset into a third-party service.

    Open tool
  3. 3

    Remove duplicate records

    Choose the key columns that identify a repeated row and review the removal count.

    Open tool
  4. 4

    Normalize the delimiter

    Convert comma, semicolon, tab, or pipe separators while preserving quoted fields.

    Open tool
  5. 5

    Convert for an API

    Turn the cleaned table into JSON when the next step is a script or web service.

    Open tool

Checks before you finish

  • Keep the untouched source export until the destination accepts the result.
  • Confirm whether IDs with leading zeroes must remain text.
  • Check quoted commas, embedded line breaks, and non-ASCII characters.
  • Compare the final row count with the source and expected removals.