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

  1. 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 00100 and phone numbers keep their leading zeros.
  2. 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.
  3. 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.
  4. 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

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

More guides