I will do excel and csv data cleaning, merging and duplicate removal
KHESHIG
Informazioni su questo servizio
Dozens of exports, all slightly different, none of them usable. That is the job I do.
WHAT I FIX
- Files merged into one table, even when headers are written differently
- "Full Name", "FULL NAME" and "full name" collapse into one column
- Duplicate rows removed across every file, not just inside one
- Completely empty rows dropped
- Semicolon separated CSV and non-UTF8 exports read correctly
- Rows filtered by your own rules
- Columns selected, reordered and renamed
WHAT YOU RECEIVE
A formatted Excel file: coloured header, frozen top row, auto filters, fitted column widths. Plus a short note telling you how many rows went in, how many duplicates were removed and how many came out.
YOUR ORIGINALS ARE SAFE
I never modify your source files. You always get a new output file, and your originals come back untouched.
BUILT ON MY OWN TOOL
This is not manual copy-paste. The app in the gallery is my own product and does the work, so the result is repeatable and I can re-run it if you send more files later.
HOW MANY ROWS
Packages are priced by file count, not row count. Large files are fine. Send me the files, or one sample, and I will tell you honestly what fits before you order
Il mio portfolio
FAQ
My headers are all different. Will they still merge?
Yes, that is the main feature. Case, extra spaces and accents are ignored when matching, so Full Name, FULL NAME and full name become a single column. The first spelling seen becomes the output header.
My CSV files are semicolon separated and look broken in Excel.
That is a European CSV export and it is handled automatically. The separator and the text encoding are both detected, so Turkish, German and other accented characters come out correct instead of as symbols.
Will my phone numbers lose their leading zeros?
No. Everything is read as text, so 0532... stays 0532... and product codes like 007 stay 007. This is the single most common thing that breaks when people merge files in Excel by hand.
Can you keep only certain rows?
Yes. Tell me the rules in plain English, for example keep rows where the amount is over 1000 and the city is not empty. Multiple rules combine, and only rows matching all of them stay.
I need this every month. Can I do it myself next time?
Add the tool extra and you receive the Windows .exe I use. Point it at a folder, press one button and it does the same job again. No Python and no Excel installation needed.

