I will clean, deduplicate and standardize your excel or CSV data
About this Gig
Got a spreadsheet full of duplicates, mixed date formats and numbers stored as text? Send it as it is (Excel or CSV) and get back clean, consistent data with a log of every change.
What you get:
- Exact duplicate rows removed; near-duplicates (same record, different spacing or case) listed for your decision, never silently deleted
- - Every column standardised: one date format, real numbers with consistent decimals, trimmed text and consistent case
- - Missing or suspicious values flagged with a clear placeholder, never guessed
- - Row counts reconciled: original = kept + removed, stated in the change log
- - Your file back as .xlsx and a matching UTF-8 .csv
Premium adds one formula automation sheet (lookups, SUMIFS summaries, a price/quote or overtime calculator, drop-down validation) with an Instructions sheet. Formulas only: no macros.
Limits: .xlsx or .csv (not .xls); files with pivots, charts, macros or merged cells are returned untouched and discussed first. I work on your file only, no logins needed.
Send a sample first if you're unsure: I'll say yes or no before you order.
FAQ
Do you use macros?
No. Everything is formulas or clean data, so the file opens anywhere without security warnings.
Will you delete rows I need?
Only exact duplicates are removed. Near-duplicates are listed for you to decide, and the change log shows every removed row.
Can you edit my existing formula workbook?
Not in this gig. Please message me first and I'll tell you honestly whether I can help.
Does it work with Google Sheets?
The .xlsx and .csv files open in Google Sheets, but I don't build Apps Script automations.
Is my data safe?
Your file is used only for your order and deleted 14 days after delivery.
What do the 100/200/300 'items cleaned' in the packages mean?
That is a fixed Fiverr field. For this gig the row limits in each package apply: Basic 1 file up to 2,000 rows; Standard and Premium up to 3 files / 10,000 rows. Bigger files: message me first.

