
Clean and categorise a messy spreadsheet with AI, 5,000 rows
Delivery in
1 day
- Views 18
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
The spreadsheet grew over years. Three people typed into it, half the company names are in capitals, the same customer appears four times, and the category column says things like "misc 2".
I'll clean it with a mix of scripts and AI and hand it back in the same format, within 1 day.
What you get, for up to 5,000 rows:
- Names, emails, phone numbers and addresses formatted one way
- Duplicates found and merged, including near-matches like "Smith Ltd" and "Smith Limited"
- Each row sorted into categories you set (up to 25), with the AI's choices checked on a sample
- Empty or broken values flagged in a separate column
- A summary tab showing what changed, how many duplicates were merged and which rows need a human look
- Your original file left untouched
Typical jobs: CRM exports before a migration, product catalogues, supplier lists, survey answers and mailing lists.
I've built AI tools that read supplier price lists and archives of past quotes, so I'm used to files that don't follow any rules.
Before you order, send a sample of 50 rows and your list of categories, or ask me to suggest one. The AI works only with what's in the file and won't guess missing data. Personal data is used for this job only and deleted afterwards.
I'll clean it with a mix of scripts and AI and hand it back in the same format, within 1 day.
What you get, for up to 5,000 rows:
- Names, emails, phone numbers and addresses formatted one way
- Duplicates found and merged, including near-matches like "Smith Ltd" and "Smith Limited"
- Each row sorted into categories you set (up to 25), with the AI's choices checked on a sample
- Empty or broken values flagged in a separate column
- A summary tab showing what changed, how many duplicates were merged and which rows need a human look
- Your original file left untouched
Typical jobs: CRM exports before a migration, product catalogues, supplier lists, survey answers and mailing lists.
I've built AI tools that read supplier price lists and archives of past quotes, so I'm used to files that don't follow any rules.
Before you order, send a sample of 50 rows and your list of categories, or ask me to suggest one. The AI works only with what's in the file and won't guess missing data. Personal data is used for this job only and deleted afterwards.
Get more with Offer Add-ons
-
I can clean up to 10,000 more rows
Additional 1 working day
+$60 -
I can set up a reusable cleaning script for future exports
Additional 1 working day
+$70
What the Freelancer needs to start the work
The spreadsheet, or a 50-row sample first
Your list of categories, or your OK for me to suggest one
Your rule for duplicates: which record should win
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies