ZapKit

CSV cleaner

Tidy a messy export before importing it anywhere: stray spaces, blank rows, awkward headers and columns that need splitting or joining.

What is a CSV cleaner?

A CSV cleaner fixes the common problems in comma-separated data so it imports cleanly into a database, CRM, mailing tool or spreadsheet. Exports and hand-edited sheets pick up stray spaces, blank lines, inconsistent headers and combined fields that other systems reject.

Paste or open a file and choose the fixes: trim and collapse spaces, remove empty rows, empty columns and duplicates, and restyle headers. Rename or untick columns to drop them, split one column into several at a separator, or merge several into a new one. The preview updates live and reports how many cells, rows and columns changed.

How to use the CSV cleaner

  1. 1.Paste or open the CSV

    The first row is treated as headers unless you untick it.

  2. 2.Choose the clean-up

    Tick fixes, rename or drop columns, split or merge.

  3. 3.Download

    Check the preview and save the cleaned CSV.

Example: a contact list

Five rows with padded names, a blank row and a repeated contact, with snake_case headers and Remove duplicate rows ticked:

Headers
"Full Name", " Email Address " become full_name, email_address
Cells tidied
4 (" Asha Rao " becomes "Asha Rao")
Rows removed
2: one empty, one duplicate

Three clean contacts with consistent headers, ready to import.

Fixes that importers need

Invisible spaces are the most common reason imports and lookups fail: "Pune " doesn't match "Pune". Trimming and collapsing spaces fixes that across every cell at once. Empty rows and columns left by spreadsheets are removed, and exact duplicate rows can go too.

Header styles matter to databases and code. snake_case suits SQL and Python, camelCase suits JavaScript, and Title Case reads well in reports. Splitting turns "Asha Rao" into first and last names; merging builds one address field from several.

Frequently asked questions

Does it change my original file?

No. You download a new cleaned copy.

In what order are the fixes applied?

Spaces first, then split and merge, then renaming and removal, then empty rows and duplicates.

How does splitting handle extra pieces?

Anything beyond the chosen number of parts stays together in the last new column.

Will numbers lose their formatting?

No. Values are kept exactly as text, so leading zeros like 007 survive.

More Developer tools