Spreadsheet Anonymizer

Remove PII from Excel and LibreOffice spreadsheets

📗 XLSX (Microsoft Excel)

📊 ODS (LibreOffice Calc)

LogScrub processes spreadsheet files cell by cell, detecting and anonymizing PII across all sheets. Perfect for sanitizing database exports, customer lists, analytics reports, and financial data.

📸 Screenshot placeholder: Spreadsheet with highlighted PII cells and anonymization preview

Before & After Examples

Customer Database

Before Anonymization

A	B	C	D	E
ID	Name	Email	Phone	Address
1001	Sarah Johnson	sarah.j@email.com	(555) 123-4567	123 Main St, Boston, MA
1002	Michael Chen	m.chen@company.org	(555) 987-6543	456 Oak Ave, Chicago, IL
1003	Emma Williams	ewilliams@corp.net	(555) 246-8135	789 Pine Rd, Seattle, WA

After Anonymization

A	B	C	D	E
ID	Name	Email	Phone	Address
1001	[NAME-1]	[EMAIL-1]	[PHONE-1]	[ADDRESS-1]
1002	[NAME-2]	[EMAIL-2]	[PHONE-2]	[ADDRESS-2]
1003	[NAME-3]	[EMAIL-3]	[PHONE-3]	[ADDRESS-3]

Financial Report

Transaction Data

Before:

Date	Card	Amount
2024-01-15	4111-**-**-1111	$99.99
2024-01-15	5500-**-**-0004	$45.50

After:

Date	Card	Amount
2024-01-15	[CC-1]	$99.99
2024-01-15	[CC-2]	$45.50

What Gets Processed

✓ Scanned

All worksheet tabs
Cell text content
Formulas (as text)
Cell comments
Header/footer content

✓ Preserved

Cell formatting
Number formats
Column widths
Row heights
Sheet structure

Common PII in Spreadsheets

Email addresses
Phone numbers
Mailing addresses
Social Security Numbers
Credit card numbers
Bank account numbers

IP addresses
Employee IDs
Customer IDs
API keys in formulas
Connection strings
Custom identifiers

Features

Multi-Sheet Processing

All worksheets in your workbook are processed. Switch between sheets to review changes.

Consistency Across Sheets

Same values get the same replacement across all sheets. If john@example.com appears in Sheet1 and Sheet3, both become [EMAIL-1].

Cell-Level Precision

PII detection works at the cell level. A cell containing Contact: john@example.com becomes Contact: [EMAIL-1].

Formula Preservation

Formulas referencing cells with PII will reference the anonymized values. Calculated results update automatically.

Use Cases

Database exports — Sanitize customer/employee data dumps
Analytics reports — Remove user identifiers from behavioral data
Financial reports — Redact account numbers and transactions
HR documents — Clean up salary spreadsheets and org charts
Test data — Create realistic but anonymized datasets

Supported Formats

.xlsx — Microsoft Excel 2007 and later
.ods — OpenDocument Spreadsheet (LibreOffice, OpenOffice)

Note: Legacy .xls format is not supported. Please save as .xlsx first.

Output Options

Download XLSX/ODS — Anonymized spreadsheet in original format
Export as CSV — Plain text for further processing
Export mapping — Original→replacement dictionary

Ready to anonymize your spreadsheets?

Drop your XLSX or ODS file into LogScrub to get started.

Launch LogScrub