Clean files you can build reports and imports on
Sounds familiar? Our spreadsheets and product data are full of duplicates, gaps and mismatched formats, so nothing we build on them works properly.
A store import, a dashboard or an integration breaks quickly when the data behind it has duplicate rows, empty fields and sizes typed three different ways. The effort depends on how messy the data is, which a description rarely shows, so the work starts with a short call and a sample of your files. A data specialist then reports what is wrong, settles the cleanup rules with you and applies them to the full dataset. Every change goes in a log. The clean data goes into your store or dashboard, and your team gets the rules so new rows can follow the same format. With one clean file you can compare products and suppliers, then decide what to keep, reprice or drop. You can also tell whether an import or dashboard is ready to go ahead.

What you get
- Data quality report showing duplicates, empty fields, mismatched formats and rows that need your decision
- Cleanup rules you approve, covering how names, units, sizes, categories and prices are written
- Cleaned dataset with duplicates merged and formats made consistent
- Change log listing every merge, correction and removal, with your original files kept unchanged
- Import file mapped to the fields your store or dashboard expects
- Import into the store or dashboard, followed by a spot check of records against the source
- Short guide to the rules, so your team can enter new data the same way
Is this right for you?
- You are moving products into a new store and the supplier spreadsheets don't match each other
- You want a dashboard or an integration, and the spreadsheets behind it are full of duplicates and gaps
- You have the same product listed several times with different names, sizes or prices
- You inherited spreadsheets that several people edited for years without an agreed format
What it changes
Data that follows one set of rules
Names, units, categories and prices are written the same way in every row, according to rules you approved. That makes it possible to compare products side by side when you decide what to keep, reprice or drop.
A record of every change
The change log and your untouched originals show what was merged or corrected, so any decision can be checked or reversed.
Clean data in your store or dashboard
The import is done and spot-checked against the source. If you prefer to load it yourself, you get an import file that matches the fields.
Scope and delivery
How we deliver it, what we need from you, what is not included. Timeline: Agreed after a short call; often 1–3 weeks for one catalog or a set of related spreadsheets
How we deliver it
-
Review a sample
On a short call, and with a sample of your files, the specialist sees how messy the data is and what it has to feed. That sets the scope and the estimate.
-
Report and settle the rules
A data quality report lists the problems found. You approve the cleanup rules and decide the cases that need business knowledge, such as which of two prices is current.
-
Clean the full dataset
The rules are applied to every row, duplicates are merged and each change is logged. Your original files stay exactly as they were.
-
Import and check
The cleaned data is imported into your store or dashboard, or delivered as an import file. A sample of records is then compared with the source.
What we need from you
- The spreadsheets, exports or supplier files to be cleaned
- Access to the store, dashboard or tool the data will go into
- Someone who knows the products or records and can rule on unclear cases
- Any naming or category conventions you already follow
What's not included
A specialist looks at your situation first, so the scope is agreed after a short call.
Not included
- Customer records in a CRM, and moves between CRMs (see CRM migration & cleanup)
- Ongoing data entry or catalog upkeep after the cleanup
- Recovering information that was never collected, such as product weights nobody recorded
- Writing product descriptions or editing photos (see Product photos & descriptions)
Where it fits
What usually follows, what may already be in place, and what is planned alongside, with the reason for each.
This service: Spreadsheet & product data cleanup
3 connected services
After this
What usually follows once this is done.
-
Business dashboards & automated reports
Reports are only as good as the data.
From tracking to one dashboard
-
Analytics & conversion tracking
Data & Reporting
-
Spreadsheet & product data cleanup
Data & Reporting
This service
-
Business dashboards & automated reports
Data & Reporting
Part of these packages
-
Business automation system
Optional add-on: When spreadsheet or product data is too messy to automate around.
-
Practical AI implementation
Optional add-on: When spreadsheets or records the pilot uses need tidying first.
Common questions
Why do you need a sample before giving an estimate?
Two files with the same number of rows can take very different time if one of them needs a person to judge each duplicate. A description rarely reveals which kind you have, so a sample settles it before you receive an estimate.
Will you change or delete our original files?
Your originals are kept as they were. Cleaning happens on a copy, and the change log records every merge, correction and removal.
Can you clean the customer contacts in our CRM?
That work belongs to CRM migration & cleanup, because CRM records are linked to deals, notes and activity history that a spreadsheet cleanup could break. If spreadsheets outside the CRM need cleaning as well, both can be scoped together.
How do we keep the data clean after you finish?
At handover you receive the cleaned files, the change log and the rules guide, which shows your team how to add new rows in the same format. The cleanup is a one-off, so following those rules stays with your team. When the data is meant to feed regular reporting, Business dashboards & automated reports can build on it.