Run a Free Scan

How to Anonymize Your Data Before Uploading

If your business data contains sensitive information, it's good practice to anonymize or redact it before uploading to any third-party platform — including 5Z. This guide explains how to do that simply, without any specialist tools.

What Is Anonymization?

Anonymization means removing or replacing information that could identify a specific person, business, or arrangement. The goal is to keep the data useful for analysis while reducing privacy risk.

You don't need to anonymize everything — just the parts that are sensitive.

What to Look For

Common sensitive fields to consider removing or replacing:

Data Type Examples Personal names Customer names, employee names, contact names Contact details Email addresses, phone numbers, postal addresses Identification numbers National insurance, passport, tax file numbers Financial account details Bank account numbers, sort codes Confidential terms Custom pricing arrangements, contract values you'd rather keep private Health or legal information Any medical or legally privileged data

Simple Methods

Method 1 — Delete the Column Entirely (Easiest)

If a column isn't needed for the analysis, just delete it.

For example, if your spreadsheet has a Customer Email column but you only need 5Z to analyse spending patterns, delete the column before uploading. The analysis will still work fine.

In Excel or Google Sheets:

Right-click the column header → Delete column

Method 2 — Replace with a Generic Label

Swap real names or identifiers for a neutral placeholder like Customer A, Customer B, or a number like C001, C002.

This preserves the ability to track patterns across a single customer (useful for analysis) without exposing their identity.

Quick way to do this in Excel:

Create a helper column with a formula like ="Customer "&ROW()-1
Copy → Paste Special → Values to freeze the labels
Delete the original name column

Method 3 — Find & Replace

If you want to remove a specific name or value throughout a file:

Excel / Google Sheets:

Press Ctrl+H (or Cmd+H on Mac)
Find the name or value → Replace with something generic (e.g. [Redacted])
Click Replace All

Method 4 — Export Only What You Need

Rather than exporting a full report with everything in it, export only the specific columns and date range relevant to your analysis. Most accounting and CRM tools let you customize exports.

Less data shared = less to worry about.

Method 5 — Use Aggregate Data Where Possible

If you're analyzing trends (e.g. monthly revenue by category), you often don't need individual transaction records at all. Export a summary report instead of raw transaction-level data.

A Practical Checklist

Before uploading, quickly scan your file and ask:

Are there any full names in this file?
Are there any email addresses or phone numbers?
Are there any account or ID numbers?
Is there any pricing or contract information I'd consider confidential?
Are there any columns that simply aren't needed for the analysis?

If the answer to any of these is yes — delete the column, replace the values, or use one of the methods above.

What 5Z Does Automatically

5Z applies its own anonymization steps where possible before your data is processed. However, this is not a substitute for reviewing your data before upload. You know your data better than we do — a quick scan before uploading is the most reliable safeguard.