Hash & Anonymise Columns in Excel Files Online
Anonymise or pseudonymise columns in Excel files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
How to hash & Anonymise Columns in Excel files
- Drop your file onto the upload area. The first 200 rows are shown with the row and column count.
- Choose a Hash algorithm: MD5 (32-character hex), SHA-256 (64-character hex) or DuckDB hash (a 64-bit integer written as text).
- Choose an Output mode. Replace swaps each selected column for its hash. Append keeps the original and adds a new column such as email_md5 at the end.
- Tick the columns to hash. Nothing is ticked by default.
- Click Hash Columns, check the preview, then download the file in the same format.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A research team wants to share survey scores with an outside analyst without revealing respondent emails, while still showing which answers came from the same person.
Input (Excel)
Excel workbook, first sheet (Sheet1)
| respondent_id | age_band | nps_score | |
|---|---|---|---|
| R-1001 | maria.lopez@example.org | 35-44 | 8 |
| R-1002 | j.okafor@example.net | 25-34 | 6 |
| R-1003 | maria.lopez@example.org | 35-44 | 9 |
| R-1004 | NULL | 45-54 | 7 |
Settings
- Hash algorithm: MD5
- Output mode: Replace original column with hash value
- Columns to hash: email
Result
| respondent_id | age_band | nps_score | |
|---|---|---|---|
| R-1001 | 0774b6f01f630684b8643132792f1c48 | 35-44 | 8 |
| R-1002 | 04010e734bdab7aa07d0f05cd693ef81 | 25-34 | 6 |
| R-1003 | 0774b6f01f630684b8643132792f1c48 | 35-44 | 9 |
| R-1004 | NULL | 45-54 | 7 |
These are the real MD5 values of each address. R-1001 and R-1003 get the same hash because they share an email, so the analyst can still group by person without seeing the address. The missing email stays empty, because MD5 and SHA-256 of NULL are NULL. The column keeps its name and position in Replace mode.
Working with Excel files
Excel has no built-in MD5 or SHA-256 function, so hashing a column usually needs a macro or add-in. This tool does it for the first sheet of the workbook without either. Cells are read as their displayed text, so a salary shown as "$85,000.00" is hashed as that exact string, symbols included. Real date cells are the exception. A date shown as 1/4/26 loads as the date 2026-01-04 and is hashed in that form, which lines up with ISO dates from a database export. Dates typed as text are hashed exactly as typed. Set amounts to plain numbers in Excel before saving if the hashes need to match other systems.
The download is a new .xlsx file on a sheet named Sheet1. Hashes are stored as text cells, and the DuckDB hash option also writes text, so Excel does not round the 64-bit numbers to 15 significant digits. The original workbook formatting, other sheets and formulas are not carried over. Keep the unhashed original somewhere safe if you need to trace a hash back to its value.
Frequently Asked Questions
Can I hash a column without macros in Excel?
Yes. Drop the workbook here, tick the columns, and download the hashed .xlsx. No VBA or add-in is needed.
Why does the DuckDB hash show as text in Excel?
It is written as a string on purpose. A 64-bit number stored as a numeric cell would lose its last digits to Excel's 15-digit precision.
Is hashing the same as anonymisation?
No. It is pseudonymisation. The same input always gives the same hash, and no salt is added. Anyone with a list of likely values, such as known email addresses, can hash them and look for matches. Treat hashed personal data as still personal.
Which algorithm should I choose?
SHA-256 for anything shared outside your team. MD5 is shorter and fine for internal join keys, but it is no longer considered secure. The DuckDB hash option is fast but not a standard algorithm, so other systems cannot reproduce it.
Can I add a salt before hashing?
Not in this tool. Use the SQL Query tool instead, with an expression such as sha256('my-secret-salt' || email). Keep the salt private and use the same one for every file you want to join.
Related Tools
Manage Columns in Excel Files Online
Drop or select specific columns from Excel files directly in your browser. No upload required.
Deduplicate Excel Files Online
Remove duplicate rows from Excel files instantly in your browser. No upload, no server — 100% private.
Count Values in Excel Files Online
Group and count rows by any column in Excel files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.
Hash & Anonymise Columns in CSV Files Online
Anonymise or pseudonymise columns in CSV files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Hash & Anonymise Columns in Parquet Files Online
Anonymise or pseudonymise columns in Parquet files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Hash & Anonymise Columns in JSON Files Online
Anonymise or pseudonymise columns in JSON files by replacing values with MD5, SHA-256, or DuckDB hashes — directly in your browser. Useful for GDPR compliance and sharing data without exposing PII — no upload required.
Excel Viewer Online
View and inspect Excel files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Excel to Parquet Online
Convert Excel files to Parquet format directly in your browser. No upload required — your data never leaves your device.