How to anonymize a CSV file
For exports from CRMs, HR systems, shops and databases
Most personal data leaves a system as a CSV export: a customer list from the CRM, an order history from the shop, a staff list from the HR system. Before that file goes to a developer, an analyst, an agency or an AI tool, replace the personal data in it and keep everything else.
Step by step
-
Open the CSV in the browser tool. Drop the file on the
Scrubsheet home page. Comma, semicolon, tab and pipe
separators are recognised, and the file is read as UTF-8, or as Windows-1252 if it isn't
valid UTF-8. Every value is read as text, so postal codes like
00100and phone numbers keep their leading zeros. - Check the suggested column types. Each column is checked for emails, phone numbers, names, addresses, IBANs, payment cards and national IDs from 18 countries, and gets a suggested method.
- Choose a method per column. Fake for realistic stand-ins, Mask to keep the last digits, Hash for a stable code, Generalize for dates, numbers and postal codes, Shuffle to mix values between rows, Redact or Clear to remove them. Leave columns such as order totals or product codes as they are.
- Download as CSV. The result is a UTF-8 CSV with a byte order mark, so Excel opens accented characters correctly, with the same columns in the same order. You can download it as an Excel file instead.
Things that catch people out
- IDs that link back. A customer number is not a name, but whoever has the CRM can look it up. Hash it, or replace it with a consistent fake, if the recipient must not be able to.
- Free-text columns. Notes, comments and "description" fields often hold names, emails and phone numbers. Anonymize just the personal data found inside the text, or drop the column.
- Several exports that must still join. Turn on consistent output with a project secret: the same email gets the same replacement in every file, so the anonymized exports still join on it.
- The original file. Delete the raw export from your downloads folder when you no longer need it.
Why not an online converter?
Many "anonymize CSV online" sites upload the file to their server, which shares the personal data with one more company before it is anonymized. Scrubsheet runs in your browser: the page's security policy blocks all network connections, so the file never leaves your computer. The browser tool is free, with no row limit.
Try it on your own file. The Scrubsheet browser tool anonymizes Excel and CSV files in your browser, free and without uploading anything. In Excel, use the Scrubsheet add-in.
Anonymize a spreadsheet