I will clean merge organize and automate excel and CSV data
About this Gig
Need clean, organized Excel or CSV data? I can clean and merge your files, standardize formatting, and automate repetitive spreadsheet tasks with Python.
Services include:
- Removing duplicate records
- Standardizing dates, column names, and formats
- Handling missing values based on your instructions
- Merging files with compatible structures
- Creating a reusable Python script for one agreed workflow
Packages:
Basic: Clean and format 1 file, up to 1,000 rows.
Standard: Merge and clean up to 5 files, up to 10,000 total rows.
Premium: Process up to 10 files, up to 20,000 total rows, with a reusable Python script and README.
You will receive the processed Excel or CSV files. Source code is included in Premium only. I check the output against your agreed requirements before delivery.
Each package includes 1 revision within the original scope. New tasks require a separate quote. API integration, database connections, and app interfaces are not included.
Please message me before ordering with an anonymized sample, your processing rules, and the desired output so I can confirm the right package.
Technology:
Excel
•
MATLAB
•
Other
FAQ
What file formats do you support?
I work with Excel (.xlsx) and CSV files. Please tell me which sheets to process and any formatting requirements. Files with macros, password protection, or complex formulas need review before ordering.
What do you need to get started?
Please message me before ordering with an anonymized sample, your processing rules, and an example of the desired output. I will review the scope and help you choose the right package.
Is Python source code included?
Python source code and a README are included in the Premium package for one agreed workflow. Basic and Standard include the processed files only. Running the script requires Python and the listed dependencies.
What does the included revision cover?
Each package includes one revision to adjust the delivered work within the original agreed requirements. New files, new processing rules, or additional features require a separate quote.
How are file and row limits counted?
Row limits apply to the total input rows across all agreed files and sheets, excluding headers. Basic covers 1 file and 1,000 rows; Standard covers 5 files and 10,000 rows; Premium covers 10 files and 20,000 rows.
Do you provide API integration or database connections?
These packages focus on Excel and CSV file processing. API integration, database connections, web scraping, and app interfaces are outside the listed scope.

