I will automate merging and cleaning excel and CSV files
Python Developer for Excel and CSV Automation
About this Gig
Do you merge or clean the same spreadsheet exports every week? I will automate that work with a reusable Python script for your Excel (.xlsx) or CSV files.
I can combine files, remove duplicates, standardize dates and columns, and flag missing or invalid values using your rules.
You will receive the processed Excel or CSV file, Python source code, and a short setup and run guide. I will test the script with your sample data.
Basic covers cleanup for 1 file. Standard covers merging and transforming up to 3 files. Premium covers up to 5 files with custom rules, validation, and an error report.
Before ordering, message me with a sample file, the rules to apply, and an example of your desired output. An anonymized sample is fine.
Technology:
Excel
•
Python
FAQ
What types of files can you process?
I work with CSV and Excel XLSX files. I can clean, organize, merge, convert, and transform data based on your requirements. Please contact me if you have a different file format.
Can you automate repetitive Excel or CSV tasks?
Yes! I can create reusable Python scripts to automate tasks such as cleaning data, removing duplicates, combining files, formatting columns, and generating reports.
What do you need from me to get started?
Please provide your files or sample data, a description of the task, and an example of your desired output. If you have specific rules or requirements, include those as well.
Will I receive the Python source code?
Yes! All three packages include the Python source code, processed files, and basic instructions for running the script.
How many files and rows are included?
Basic includes 1 file with up to 1,000 rows. Standard includes up to 3 files with 5,000 total rows. Premium includes up to 5 files with 20,000 total rows. Contact me for larger projects.
Do I need Python installed on my computer?
The delivered automation scripts generally require Python and any necessary libraries. I'll provide installation and usage instructions. Standalone executable applications are not included unless agreed separately.
Can you connect Excel to websites, databases, or APIs?
This gig focuses on local CSV and Excel file processing. Live API integrations, database connections, web scraping, and cloud automation are not included in the listed packages. Contact me to discuss a separate custom solution.
What happens if I need changes after delivery?
Each package includes a set number of revisions. Revisions cover corrections within the original agreed requirements. New features or major changes may require an additional order.

