I will clean merge and process csv or excel files with python


About this gig
Turn CSV exports and Excel files into clean, consistent data with a reusable Python script. Ideal for comparing lists, merging exports and repeating the same processing steps on new files.
I can remove duplicates, standardize values, filter rows, combine files, compare records using an agreed key and generate CSV/XLSX reports.
You receive a standalone Python script, dependency list, setup guide and sample output. I test it against your supplied files and expected results. Run it again whenever you have new files with the same structure.
BASIC: 1 task, 1 file, up to 5,000 rows.
STANDARD: up to 3 steps, 2 files, 10,000 rows per file.
PREMIUM: up to 5 steps, 5 files, 20,000 rows per file, with validation and reports.
Packages cover structured CSV/XLSX files, one worksheet per input and one agreed workflow. Python installation is required.
For buttons or macros inside Excel, see my separate Excel VBA service. APIs, scraping, PDF extraction, desktop interfaces and hosting are outside this Gig.
Message me before ordering with an anonymized input sample and the output you need so we can confirm scope.
Get to know Matteo F.
Excel VBA and Python Automation, Dashboards and Web Apps
- FromItaly
- Member sinceApr 2026
Languages
Italian
Other Software Development Services I Offer
FAQ
What should I send before ordering?
Send an anonymized sample file, the steps you currently perform and an example of the result you want. Include column names and matching rules. Please remove passwords, credentials and confidential personal data. We will agree the scope before you order.
How will I run the script?
You receive Python source code, a dependency list and a step-by-step setup guide. Tell me whether you use Windows or macOS so we can confirm compatibility. You will need Python installed. Remote installation, a desktop interface and hosting are not included.
What is included in a revision?
Revisions refine the delivered script within the agreed workflow and supplied file structure. New features, new input formats or additional workflows require a separate scope and quote. Please provide the relevant sample and expected result when reporting an issue.
Should I choose Python automation or Excel VBA?
Choose this Gig for a standalone script that processes CSV/XLSX files and produces clean files or reports. Choose my Excel VBA Gig when you need a button or macro that runs inside desktop Excel. Send your workflow first if you are unsure.
