
Excel data cleaning: clean and de-duplicate your spreadsheet
Delivery in
1 day
- Views 8
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
Your spreadsheet has grown messy: the same customer appears three times under slightly different names, dates are in four formats, and numbers stored as text will not add up. I clean it into one tidy sheet you can sort, filter and total, and tell you in writing exactly what changed.
I'm Genco. You work with me directly on this job, start to finish, and every change is written down for you.
Matching records that were typed differently is the core of the data work I do on customer lists, CRM exports and old spreadsheets. "J. Smith" and "John Smith" may be one customer or two, and 03/04 is March in one export and April in another, so nothing unclear is merged or guessed: those rows are flagged for you to decide, and every change goes into a change log you can see and undo. In my portfolio: Messy Sales Sheet Cleaned Into a One-Page Dashboard, where the sheet said GBP 19,549 and the shop had actually taken GBP 28,553.
You get, delivered in 1 day: one sheet of up to 5,000 rows with dates in one format, names and text tidied (spacing, capitals, stray characters), numbers stored as text turned into real numbers, duplicates removed and blank rows taken out. Your original stays untouched beside the cleaned copy, both in one .xlsx file with the change log as its own tab, plus one round of changes after you have looked at it. A totals row and a simple chart are included on request.
How it is made: AI assisted, and every change is written into the change log row by row, with the old value beside the new one.
I'm Genco. You work with me directly on this job, start to finish, and every change is written down for you.
Matching records that were typed differently is the core of the data work I do on customer lists, CRM exports and old spreadsheets. "J. Smith" and "John Smith" may be one customer or two, and 03/04 is March in one export and April in another, so nothing unclear is merged or guessed: those rows are flagged for you to decide, and every change goes into a change log you can see and undo. In my portfolio: Messy Sales Sheet Cleaned Into a One-Page Dashboard, where the sheet said GBP 19,549 and the shop had actually taken GBP 28,553.
You get, delivered in 1 day: one sheet of up to 5,000 rows with dates in one format, names and text tidied (spacing, capitals, stray characters), numbers stored as text turned into real numbers, duplicates removed and blank rows taken out. Your original stays untouched beside the cleaned copy, both in one .xlsx file with the change log as its own tab, plus one round of changes after you have looked at it. A totals row and a simple chart are included on request.
How it is made: AI assisted, and every change is written into the change log row by row, with the old value beside the new one.
Get more with Offer Add-ons
-
I can up to 10,000 rows instead of 5,000
Requires no additional time
+$7 -
I can a totals row and a simple chart
Additional 1 working day
+$7
What the Freelancer needs to start the work
The spreadsheet (.xlsx or .csv), which columns matter most to you, and how you tell that two rows are the same customer or item, for example the same email address, or the same name and postcode. Send your file through PeoplePerHour's messages. I work on it in a private, locked-down workspace, use it only for your job, and send the result back here.
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