I will clean, merge and automate excel and CSV spreadsheets
About this Gig
Save time with professional Excel and CSV data cleaning and automation!
Are you tired of manually merging spreadsheets, removing duplicates or fixing messy data?
I can help streamline your spreadsheet tasks using Python, pandas and openpyxl, saving you time and reducing repetitive manual work.
What I can do for you:
- Merge multiple Excel (.xlsx) and CSV files
- Clean and standardise inconsistent data
- Identify duplicate records
- Detect missing or invalid values
- Organise and format spreadsheets
- Calculate totals and summary statistics
- Generate formatted Excel reports with charts
- Create reusable Python automation scripts (Premium package)
Why work with me?
I hold a degree in computer programming and have developed my own Python-based Excel automation tool, which automatically processes sales data, validates records and generates formatted reports.
I focus on accuracy, clear communication and practical solutions tailored to your requirements.
What you'll receive:
A cleaned, organised Excel workbook, with additional reports or Python source code depending on your selected package.
Please message me before ordering so I can review your requirements and confirm the appropriate package.
Technology:
Excel
•
Python
Expertise:
Data manipulation
My Portfolio
FAQ
What file formats do you support?
I work with Excel (.xlsx) and CSV (.csv) files. Please contact me before ordering if you have another file format.
Can you merge spreadsheets with different column names?
Yes, I can handle straightforward differences in column names and structure. More complex datasets may require a custom quote.
Will my original spreadsheets be modified?
No. I work on copies of your data and provide separate output files. Your original spreadsheets remain unchanged.
Can you create a reusable Python script?
Yes. My Premium package includes a reusable Python script tailored to the agreed spreadsheet structure, along with basic instructions for running it.

