Privacy-first data cleanup

How to clean a CSV without uploading it

Small exports often contain blank rows, duplicate records, inconsistent headers, and extra spaces. You can correct those problems locally without sending the file to a server.

1. Keep the original file

Make a separate working copy before changing anything. This gives you a reliable reference if a column is removed or reformatted by mistake.

2. Choose only mechanical cleanup rules

Trimming spaces, removing completely blank rows, normalizing column names, and deleting exact duplicates are predictable operations. Review near-duplicates manually because two similar rows may represent different people or transactions.

3. Preview before exporting

Check the headers and several rows before download. Confirm that dates, leading zeroes, names, and identifiers still look correct.

4. Split large exports when useful

Smaller files are easier to inspect and import. Keep the same headers in every part and name the files sequentially.