Browse categories
Explore
Fiverr Pro
English
$
USD
I will clean, deduplicate and standardise your messy spreadsheet
Data extraction and automation: web to Excel, OCR, cleanup
I turn messy data into files you can actually use.
I extract public information from websites, directories and catalogues into clean Excel/CSV files; transcribe scanned PDFs and invoices; clean up sp...
About this Gig
You have a spreadsheet that grew out of control: duplicates, dates in three formats, phone numbers with dashes in some rows, categories spelled six different ways.
I give it back usable:
- duplicates removed with a documented rule (which one survived and why)
- dates, numbers and text standardised to one format
- badly split columns separated, and obvious categories unified
- a report of every change made, with counts
- a summary tab so you can see the data at a glance
Your file comes back cleaned, plus a copy of the original untouched, so nothing is lost on the way.
Type:
Formatting
•
Data cleaning
Tool:
Excel
•
Google Sheets
FAQ
Can you keep the original file untouched?
Yes. You always get the original back exactly as you sent it, plus the cleaned copy and the change log. Nothing is overwritten.
What if I do not have a rule for duplicates?
I propose one (usually keep the most complete and most recent row), tell you exactly what it does, and you approve it before I apply it.
