SamplesGet a free quote

Excel data cleaning and deduplication, with a change log.

Send a messy export and get back a clean file you can trust: duplicates merged, dates and phone numbers standardized, junk values blanked, and a change log that shows exactly what was touched. Fixed price from $79, with a free preview before you pay.

Free preview: you see the first rows of your file done correctly before you pay.

Upload your file for a free quote See prices See sample work
Remove duplicatesCRM export cleanupMailing list cleanupInventory sheetsChange log includedFixed price

Typical jobs

CRM exports where the same person appears three times with different spellings. Mailing lists with stray spaces, mixed capitalisation and "N/A" typed into email cells. Inventory sheets where SKUs, units and dates follow no single format. Merged workbooks from several people that need to become one table.

What cleaning includes

The change log

Cleaning only helps if you can trust it. Along with the cleaned sheet you receive a change log listing which rows were merged or removed, which values were altered and why. The original data is never overwritten: the cleaned table comes back as a separate file or sheet, so you can compare and undo anything you disagree with.

Deciding what counts as a duplicate

Two rows with the same email are an easy match. Two rows with the same name and different phone numbers might be two different people. Before we merge anything uncertain, we ask you or apply the rule you give us, and uncertain matches go in a review list instead of being deleted silently.

How it works

Upload the file in the quote form with two lines on what the result should look like. You get a fixed price, a free preview of the first rows cleaned, and the full file after payment. Sheetsmith is an AI-powered service, and every deliverable is checked against your request before it reaches you. Revisions are free until it matches what you asked for.

Worked example

An example of our process, not a client story. The scenario is illustrative and any sample data is fictional.

Example job

Input: a CRM export with 51 filled rows.

What we did:

  • Removed blank spacer rows and merged duplicate contacts, matching on email
  • Standardized names to Proper Case, trimmed stray spaces and lowercased emails
  • Rewrote phone numbers to one format and converted text dates into real dates
  • Logged every fix with a count on a Changes log sheet so nothing changes silently

Output: A cleaned contact list of 40 unique people plus a Changes log tab. In the sample, 11 duplicates were merged, 24 names fixed, 40 phone numbers reformatted and 42 dates converted. Ambiguous dates are flagged rather than guessed.

Turnaround: Delivered same day in the sample; standard is within 24 hours, rush within 3 hours.

Download the cleaned file from this example (all data is fictional)

Data cleaning pricing: fixed, with rush available.

Cleaning and deduplication fall under Clean & Convert: $79 standard (within 24 hours) or $129 rush (within 3 hours), up to 5,000 rows. Bigger files get a custom fixed quote before any work starts.

Best for data cleaning

Clean & Convert

$79 standard
Rush: $129
  • PDF / scanned tables → editable Excel
  • Dedupe, split, merge and standardize up to 5,000 rows
  • Combine several files into one clean table
OrderOrder rush

Quick Fix

$39 standard
Rush: $69
  • One broken formula, lookup or sheet
  • Conditional formatting, sorting, validation
  • Plain-English note on what was wrong
OrderOrder rush

Report & Dashboard

$199 standard
Rush: $299
  • Summary tables, pivots and charts
  • A one-page dashboard that updates when data changes
  • Template you can reuse every week
OrderOrder rush

Automation

$299 from
Rush: $449
  • Google Apps Script or Excel VBA / Power Query
  • Kill a manual weekly task for good
  • Commented code + a short how-to
OrderOrder rush

Bigger than these? You get a custom fixed quote before any work starts. Unlimited revisions until it matches what you asked for.

How it works

Send the file and what you needUpload it in the quote form or email a copy (sensitive columns removed if you like) and two lines on the result you want.
Fixed quote within the hourYou get a price and a delivery time. Free preview: for cleaning and conversion jobs, you see the first rows done right before you pay.
Pay by card through StripeSecure checkout. Work starts the moment you pay.
Checked file deliveredEvery formula and total is verified before it reaches you. Revisions are free until it's right.

Questions

What files can I send?

Excel (.xlsx, .xls), CSV, a Google Sheets link with view access, PDF, and scanned images (photos or scans of tables). If your format isn't listed, email it anyway and you'll get an honest answer in the quote.

How do I send a Google Sheet?

Click Share in your sheet and give view access to chrisgrant2019+sheetsmith@gmail.com, then email the link and what you need. Your original is never edited; the finished work comes back as a new file.

Who does the work?

Sheetsmith is an AI-powered service: AI tools do the heavy lifting, and every deliverable is checked against your request (totals reconciled, formulas tested, edge cases tried) before delivery. That's why it's fast. You still get exactly what you asked for, or it's revised free.

Is my data safe?

Your files are used only for your job and deleted after delivery on request. If the data is sensitive, send a copy with names or account numbers removed. The structure is all that's needed.

What if I'm not happy?

Revisions are free until the deliverable matches what we agreed. If it can't be done, you get a full refund.

Why does rush cost more?

Rush jumps the queue and is delivered within hours instead of a day, with the same quality checks. Fast and right is worth more than slow and right.

Get your free quote

Upload your file and say what you need. You'll have a fixed price within the hour. No account needed, and you pay nothing until you approve the quote.

Open the quote form

Prefer email?

Email for a quote

chrisgrant2019+sheetsmith@gmail.com