I will clean your product CSV and remove duplicate rows
Data Automation and Workflow Reliability Specialist
About this Gig
Messy product CSV or Excel catalog? I clean the fields you name, remove exact duplicate rows, and put every doubtful row in a review list instead of guessing. Your file comes back with the same columns, SKUs untouched, plus a summary showing where every row went.
For small stores and ops teams with supplier lists and product exports.
Included at any size:
- Trim extra spaces in chosen fields
- Standardize labels via your replacement list
- Format prices to your number format
- Check required fields and flag duplicate SKUs
- Remove identical repeated rows (with your OK)
You get 4 files: cleaned.csv, review.xlsx (rows needing your decision, with reasons), removed_duplicates.csv and summary.txt.
Nothing is invented. Conflicting or incomplete rows go to the review file, not deleted or guessed. Leading zeros and IDs stay as they are.
One CSV or single-sheet Excel file, up to 20 MB, 100 columns, cleanup on up to 10 columns. Same checks at every size; pick by row count. One revision included.
Shopify/WooCommerce formatting, multi-sheet workbooks or bigger files? Message me first. No store uploads or import guarantees.
Send a 20-row sample and I'll confirm the fit before you order.
FAQ
What do you need to get started?
Your original CSV and a short explanation of what needs fixing. Name the important columns and show your preferred format if you have one. You do not need to write technical rules.
Will you remove duplicate SKUs?
I can remove identical repeated rows when you approve it. The same SKU with different details may represent a conflict or a valid product relationship, so I flag it for review instead of choosing which record to delete.
Will my SKUs and leading zeros stay intact?
Yes, identifier values are preserved in the CSV. When opening the result in Excel, import SKU and ID columns as Text so Excel does not remove zeros or alter long numbers. I include a short note explaining this.
What happens to missing or questionable information?
Rows needing a decision are kept in the review workbook with an explanation. I do not guess missing details. The cleaned CSV excludes those rows, and the summary accounts for all input rows.
Can you prepare files for Shopify or WooCommerce?
Please message me with a sample and the intended importer first. Product variants, images and update rules can need a separate scope. Standard packages cover catalog cleanup, not store uploads or guaranteed import compatibility.
What file and cleanup limits apply?
Each package covers one CSV up to 20 MB and 100 columns, with cleanup or checks on up to 10 selected columns. Exact label replacements can include up to 50 supplied pairs across two columns. For Excel files, multiple files or more involved changes, message me first.
What does the revision include?
One revision covers adjustments to the agreed cleanup on the original file. New files or additional tasks are quoted separately. If I missed an agreed instruction, I will correct it without an extra charge.
How do you handle my files?
I use your files to complete the order and do not publish them or use them as portfolio samples without permission. Please remove customer details or other information the cleanup does not need.

