247999.XYZ Tools / Clean files / Spreadsheet privacy cleaner
Sign inCreate account

Remove personal data from CSV and JSON files

Remove columns or consistently replace names, emails, phone numbers and customer IDs in CSV or JSON files before sharing sample data. Runs in your browser.

Help with this task

Share data without sharing people

Exports from shops, CRMs and apps are full of names, emails, phone numbers and customer IDs. Before you send sample data to a developer, a colleague or a consultant, remove the columns they don't need and replace the rest with stand-ins.

What each action does

  • Replace consistently: every value becomes a stand-in such as user0007@example.com or Person 0007. The same original always gets the same stand-in, so totals, joins and duplicates still work.
  • Hash (keyed): replaces values with short codes using a fresh random key for each processing run. Repeated values still share a code within that result, so patterns and other columns may reveal who a row describes.
  • Mask: keeps the last few characters, like ••••••1234.
  • Year only: turns a birth date into a year.
  • Remove column and Blank do what they say.

Questions

Is the file uploaded?

No. It's read and cleaned in your browser.

Is the result anonymous?

Not necessarily. Columns you keep, like age, town and job title together, can still identify someone. Keep only what the other person really needs.

Does it work with Excel files?

Save the sheet as CSV in Excel first (File → Save As → CSV UTF-8), then open it here.

File limits and review

The input limit is 16 MiB. Large or complex inputs may take longer on smaller devices. Review the cleaned result before sending it to someone else.