Anonymise data in Excel & CSV – before you share it
Before a table with names, email addresses or customer numbers is shared or analysed, personal data should be removed or masked – often this is even mandatory. This guide shows what anonymisation really means and how to prepare a table safely for sharing.
Why anonymising matters
As soon as a table contains details about identifiable people – name, email, phone number, customer number – it is subject to data protection. Passing such data on carelessly, say to a service provider or in a report, risks privacy breaches. Before sharing or analysing, a deliberate anonymisation step therefore pays off.
Anonymise, pseudonymise, aggregate
There are several levels. Anonymising removes personal details so no one can be identified any more – the safest variant. Pseudonymising replaces the name with a code; the link theoretically remains possible via a separate list. Aggregating combines individual data into groups so single people disappear.
Remove personal columns
The most direct route is to delete identifying columns entirely. For a revenue analysis by region you don’t need names or email addresses – you can safely remove those columns. In Clean Studio you delete whole columns in one step and keep only the attributes needed for the analysis.
Unify values and break direct links
Sometimes you want to keep a column but break its personal link. With find & replace across all columns you can replace specific names with neutral codes or unify free-text fields. That preserves the structure of the data without revealing individual people.
- Remove identifying columns (name, email, phone) entirely.
- Replace remaining direct references with codes via find & replace.
- Clean duplicate or empty rows so no residual traces remain.
The decisive advantage: it happens locally
Anonymising has a chicken-and-egg problem: an online service that makes you upload your raw data first in order to “anonymise” it has already seen the sensitive data. Clean Studio works solely in your browser – the unprotected raw data never leaves your device. That is exactly what makes local processing indispensable for this task.
An important note on diligence
Anonymisation is a matter of care, not an automatism. Check whether people can still be recognised through the combination of several columns – e.g. postcode plus year of birth plus occupation. When in doubt, remove one column more. This guide is practical help but does not replace legal advice.
Frequently asked questions
What is the difference between anonymising and pseudonymising? With anonymising, no link is possible any more. With pseudonymising, the name is replaced by a code, and tracing back remains theoretically possible via a separate list.
Is it enough to delete the name column? Not always. People can be identifiable through the combination of several attributes. Check all columns and, when in doubt, remove one more.
Is my data uploaded during anonymisation? No. Clean Studio processes the file solely and locally in the browser – which is crucial precisely for sensitive raw data.
All SmashDash tools at a glance
SmashDash brings five free spreadsheet tools together in one place – each runs entirely in the browser, with no upload and no account:
- Turn Excel and CSV into interactive, filterable charts. – Turn Excel and CSV into interactive, filterable charts.
- Design charts with your own values and export them as SVG or HTML. – Design charts with your own values and export them as SVG or HTML.
- Convert Excel, CSV and JSON into XLSX, CSV, JSON, Markdown or HTML. – Convert Excel, CSV and JSON into XLSX, CSV, JSON, Markdown or HTML.
- Remove duplicates and empty rows, normalise number formats. – Remove duplicates and empty rows, normalise number formats.
- Merge, split and compress PDFs and extract tables. – Merge, split and compress PDFs and extract tables.
All processing happens locally in your browser – your files are never uploaded, fully privacy-friendly.