I will do excel and csv data cleaning, merging and deduplication
About this Gig
Thank you for stopping by - it's lovely to have you here.
Is your spreadsheet full of duplicates, blank rows, mixed-up dates and numbers that refuse to add up? I'll tidy it up carefully, so you can trust your data again.
What I'll do for you:
- Remove duplicates and empty rows, and trim stray spaces
- Fix dates and numbers: day/month mix-ups, currency symbols, decimal commas
- Make codes, names and categories consistent
- Merge files from different systems into one clean table
- Give you a short list of every change, so nothing is hidden
How I work:
- I look at your files first and ask before changing anything that affects the result
- Your originals stay untouched - you receive clean copies
- Your files are deleted once the order is complete
With over 16 years spent automating critical operations in telecommunications, I treat your data with real care.
Need the same clean-up every month? Ask me about a friendly one-click tool for Windows.
Not sure which package suits you best? Please do send me a message - I'd be very happy to help.
Technology:
Excel
•
Python
•
VBA
•
PowerShell
FAQ
Which files can you work with?
Excel (.xlsx, .xls) and CSV files, including exports from online shops, accounting and CRM systems. If yours is something else, please ask.
Will you change my original files?
Never. I work on copies, and you receive new, clean files together with a list of the changes I made.
What happens to my data afterwards?
Your files are deleted once the order is complete. They are never shared or used for anything else.
Do I need to install anything?
Not at all - you receive ordinary Excel files that open as usual.
