How to back up and version a CSV file before cleaning or editing it
A simple habit that makes every other CSV cleanup guide reversible: never edit the only copy of the file.
Before you work through this by hand: you can check your own CSV free and see which of these problems your file actually has — duplicate rows, near-duplicates, broken quoting, encoding damage. It runs in your browser tab, nothing is uploaded, and there's no signup or email.
Why this is worth its own guide
Almost every guide in this series — deduplication, trimming whitespace, normalizing case, fixing encoding — involves changing data, and every one of them is only safely reversible if you didn't overwrite the original. This is the one habit that makes every other fix low-risk instead of high-risk.
The simplest version: a dated copy
Before opening a file to clean it, copy it with a date in the filename: contacts.csv → contacts_2026-07-28_original.csv. It costs nothing and takes five seconds, and it means every cleanup script or spreadsheet operation can target a working copy while the original stays untouched.
If you're scripting the cleanup
import shutil; shutil.copy('contacts.csv', 'contacts_backup.csv') at the start of a Python cleanup script ensures the backup happens automatically every time, rather than depending on remembering to do it manually before each run.
Versioning multiple cleanup passes
If you're iterating (dedupe, then trim whitespace, then re-check), keep each intermediate output rather than overwriting the same file repeatedly — contacts_v1_deduped.csv, contacts_v2_trimmed.csv, and so on. This makes it possible to tell exactly which step introduced a problem if the final result looks wrong, instead of having to redo the whole pipeline from the original to find out.
This is why our tool never edits in place
It's also the reasoning behind why CSV Repair & Deduper always produces a new exported file rather than modifying the file you opened — the same backup-first principle applied automatically, whether you use a manual process or the tool.
See CSV Repair & Deduper (offline browser tool) — $19 one-time