The Freelancer's Nightmare
You've just landed a new client. They send you "the file" — a spreadsheet that hasn't been touched by a professional in years. Names in date columns. Totals that don't add up. Merged cells everywhere.
Before you touch a single formula, you need to understand what you're dealing with. This 30-minute audit framework helps you document what's broken, protect yourself professionally, and give the client a clear picture of the work ahead.
Minutes 0–5: First Pass
Open the file and scroll without clicking anything. You're looking for:
- Visual inconsistencies: color coding that stopped mid-sheet, columns that end abruptly, obvious blank rows
- Multiple tabs: how many? What do they reference? Are any hidden?
- File size: a 50MB "simple spreadsheet" has something large hiding in it
Sohovi gives you a full quality report on any spreadsheet in seconds — upload your file and see exactly what needs fixing.
Write down your first impressions. These gut-check observations are often the most important.
Minutes 5–10: Column-by-Column Type Check
Pick your most important sheet and go column by column. For each column, ask:
- What type of data should this be? (text, number, date, boolean)
- Does every cell match that type?
- Are there blanks? If so, are they expected or missing data?
Look for mixed types — a column with 847 numbers and 3 cells that say "N/A" or "TBD" will break any formula that touches it.
Minutes 10–15: Check Key Relationships
Every spreadsheet has at least one relationship between tabs or columns. Find them and verify:
- Do lookup values in Sheet 2 actually exist in Sheet 1?
- Do totals in summary rows match the detail rows below?
- Do date ranges make sense chronologically?
A quick COUNTIF can tell you how many values in one column have no match in another in under a minute.
Minutes 15–20: Identify Duplicates
Duplicates are the silent killer of client data. Sort by the primary identifier (customer ID, email, order number) and scan for consecutive duplicates. Or use a COUNTIF to flag IDs that appear more than once.
Sohovi automatically finds every duplicate in your dataset — including near-matches — and shows you exactly which rows are affected.
Note: are the duplicates truly duplicate records, or are they the same customer with multiple transactions? Context matters.
Minutes 20–25: Document What You Found
Create a second tab called "Audit Notes" and write:
- Total rows and columns
- Estimated % of rows with at least one issue
- Specific examples of each error type (with cell references)
- Your assessment: is this a 2-hour cleanup or a 2-week rebuild?
This documentation protects you. If a client later claims "the data was fine when we sent it," you have timestamped evidence.
Minutes 25–30: Draft Your Findings Email
Before you do any cleaning work, send your client a summary. Be factual, not accusatory. Something like:
"I've done an initial audit of the file. I found approximately 340 rows with missing values in the Email column, 12 duplicate customer IDs, and inconsistent date formats across 3 columns. Before I begin cleaning, I wanted to confirm the scope — do you want me to address all of these, or prioritize a specific issue?"
This email does three things: it shows professionalism, it sets expectations, and it creates an opportunity to expand scope (and your invoice).
The Most Important Rule
Never edit the original file. Always work on a copy. Name it with your name and the date: ClientData_Audit_YourName_2026-05-31.csv. If something goes wrong, you have the original to fall back to.
