I will do data cleaning, merging and formatting for excel or CSV
About this Gig
I will clean and organize your existing Excel or CSV data so it is easier to filter, reuse and import.
Included: remove duplicates using your chosen key, trim extra spaces, standardize agreed text and date formats, correct values using rules you provide, and format a clear table. Standard and Premium also merge files with matching columns.
Basic: 100 total rows in 1 file.
Standard: 200 total rows across up to 2 files.
Premium: 300 total rows across up to 3 files.
Each package covers up to 10 columns. One item means one data row; headers are excluded.
You receive the cleaned XLSX or CSV file and a short change summary. I check row counts, duplicate handling and agreed formats. Missing or ambiguous values are flagged rather than invented. One revision covers the original agreed rules.
Please send a sample before ordering if your files contain formulas, multiple sheets or unusual date formats. PDF conversion, web research, macros and complex spreadsheet models are separate work.
My Portfolio
FAQ
How are duplicates and unclear values handled?
You choose the duplicate key, such as a row ID or agreed combination of columns. I remove only duplicates that match those rules. Missing values, conflicting records and ambiguous dates are flagged for review, not guessed.
Can you preserve formulas and leading-zero codes?
Identifiers such as 00101 stay as text so leading zeros are preserved. Send a sample before ordering a workbook with formulas or multiple sheets. Choose XLSX if you need spreadsheet formatting; CSV stores plain table values and does not preserve workbook formulas or styling.
