I will clean excel and CSV data and remove duplicates
Excel and CSV Cleanup, PDF Conversion and Instagram Captions
About this Gig
Turn a messy Excel or CSV export into a clean file for reporting or import.
I remove fully blank rows and exact duplicates, trim spaces at field edges if requested, and flag records that share an ID but contain different data. Conflicting records stay in your file for you to review.
YOU RECEIVE
- Clean Excel (.xlsx) workbook and CSV
- Clear headers, filters and a frozen header row in Excel
- Before/after row counts and a change summary
- Separate conflict file when needed
Basic: 100 rows in 1 day. Standard: 1,000 rows in 2 days. Premium: 3,000 rows in 3 days. One revision covers the original file and rules.
Send one .xlsx worksheet or UTF-8 CSV with one header row, up to 50 columns and 5 MB. Limits apply before cleanup. IDs and leading zeros are preserved when supplied as text. Formulas, macros, manual research and filling missing facts are outside this service.
Upload your file and identify the ID column to check. Message me on Fiverr if you need help choosing a package.
My Portfolio
FAQ
What file should I send?
Send one .xlsx workbook with one worksheet, or one UTF-8 CSV, with a single header row. Maximum 50 columns and 5 MB. Choose a package by the original data row count. Please send values only, without formulas or macros.
How do you handle duplicate IDs with different values?
I flag them in a review file and keep the records in the cleaned CSV so you can decide which to use.
Can I open the file in Excel?
Yes. Import columns containing IDs or ZIP codes as text to retain leading zeros.

