Browse categories
English
$
USD
Connect to your AI
I will clean and deduplicate your excel or CSV data
Director
I'm an Australian small business owner who has spent years running a painting company with a team. I've built my own quoting and job-costing spreadsheets, cash-flow and BAS tracking, and the procedure...
About this Gig
I clean Excel and CSV lists. Every change is logged. Exact duplicates are merged only when every cleaned field matches. Doubtful matches are grouped for you to decide, not deleted.
What you get:
A cleaned Excel workbook, plus a Source sheet with your original data
A change log of each edit and the rule used
A Possible duplicates sheet with a decision column
A Summary that checks rows received = clean records + exact duplicates merged
Brief instructions
Basic: one file, up to 100 rows and 20 columns. Standard: up to 3 files, 2,000 rows and 30 columns. Premium: up to 5 files, 5,000 rows and 40 columns. Over-limit files need a custom offer.
The gallery shows Gumleaf Supply Co., a fictional 464-row sample that fits Standard.
I do not use OCR, macros or Power Query, invent missing values, or guarantee every ambiguous entry is correct. Default conventions are Australian (dates, phones, states).
Message me on Fiverr with your file (or a sample), column meanings and locale, before you order.
Tools, including AI assistants, may help with routine cleaning. Every delivery is reviewed. If you want no AI used, tell me before you order so I can confirm whether that can be met.
FAQ
Excel or Google Sheets?
These packages take Excel (.xlsx, .xls) or CSV, and I deliver an Excel workbook. Google Sheets delivery is not included. If your list is in Sheets, export it first, or message me on Fiverr before you order.
Can you clean a PDF, a scan, or a photo of a spreadsheet?
No. These packages do not include OCR. Please send Excel or CSV.
Do you use macros, VBA or Power Query?
No. The delivery workbook is ordinary Excel, with no macros and no Power Query.
What date and phone format do you use?
Australian conventions by default: dates as day/month/year; phones as 04xx xxx xxx or (0X) XXXX XXXX, with +61 converted to a leading 0. Numbers with no area code are flagged, not guessed. If your file uses another country format, tell me before you order.
What do revisions include?
Revisions are corrections and agreed tweaks inside the same files, columns and row cap. A new file, extra columns, or more rows than the package allows is a custom offer, agreed on Fiverr before extra work starts.
Do you use AI?
Tools, including AI assistants, may help with routine cleaning. Every delivery is reviewed. If you want no AI used, tell me before you order so I can confirm whether that can be met.
Will you fill in missing emails, phones or names?
No. Missing or doubtful values are flagged on the Clean data sheet for you to complete.
Do you delete duplicates automatically?
Only exact duplicates (records matching on every cleaned field) are merged. Possible matches, such as the same email or phone, or a similar name in the same postcode, go on a Possible duplicates sheet. You choose Keep both, Merge, Delete or Not sure. I never auto-delete doubtful matches.
How accurate is the cleanup?
I apply consistent rules and log every edit. Values that look wrong, like an invalid email, a phone with no area code or a postcode outside its state range, are flagged, not guessed. I don't invent missing values or guarantee ambiguous entries are correct. You decide how you use the file.
The sample has 464 rows. Which package is that?
Standard. Gumleaf Supply Co. is a fictional 464-row, one-file sample. Basic covers one file up to 100 rows; Standard covers up to 3 files and 2,000 rows; Premium up to 5 files and 5,000 rows. Every package includes the same sheets, duplicate review and the change log.
