Skip to content
DataHuman expert

I will build Python scripts to automate Excel reports and merge CSV files.

Automate repetitive Excel reports, merge multiple CSV files, and clean messy spreadsheets instantly with custom Python scripts.

By Wekesa Ezra

Python Engineer | Data Science & Automation Specialist

Sold by Weks Data & Automation., Nairobi, Juja, near JKUAT campus, Nairobi city, Nairobi, 00100, Kenya.

£52.50incl. £2.50 service fee3 days delivery

Illustration of the format of the I will build Python scripts to automate Excel reports and merge CSV files. deliverable. Not a sample of your document.Doc
Illustration of the deliverable’s format — not a sample of your document.

What you’ll receive

In the Basic package:

  • Merge or clean up to 5 CSV/Excel files into a single formatted output file.
  • Files: no files
  • Done by the seller in person

About this service

Are you spending hours manually copying, merging, and cleaning spreadsheets?, I write custom Python scripts that automate your routine Excel and CSV workflows so you can run complex report operations in seconds. Whether you need to combine hundreds of files, format data automatically, or generate recurring business summaries, I provide clean, robust code tailored to your exact workflow. What I Can Do For You: 1) File Merging & Splitting: Combine multiple CSV/Excel sheets automatically or split large datasets based on criteria. 2) Automated Data Cleaning: Remove duplicates, fix formatting errors, reorder columns, and handle missing values automatically. 3) Report Generation: Create dynamic summary tables, calculate key metrics, and export clean output files. 4) Formula & VLOOKUP Automation: Replicate complex spreadsheet formulas and cross-file lookups directly in Python using pandas and openpyxl.

Outcome
1) Automated Python Script: Clean, fully commented .py file or Jupyter Notebook. 2) One-Click Execution Guide: Simple instructions to run the script on your machine without technical knowledge. 3) Sample Output File: Processed sample Excel or CSV output proving the automation works as specified
Delivered as
.py, .ipynb, .xlsx, .csv and .pdf (varies by package)
Not included
Manual data entry of handwritten/scanned documents, software licensing fees, or permanent server hosting.
Limitations
Processing speed depends on system hardware for large files exceeding 1,000,000 rows.
How this service works

Completed by a human seller whose application GigBlend staff reviewed.

Completed by a human seller whose application GigBlend staff reviewed.

N/A — human

What "admin-reviewed" means: a GigBlend staff member read the seller's application and listing scope against our policies before it went live. It is not an identity, background or credential check — GigBlend never collects or holds identity documents. Sellers who take payouts are identity-checked by Stripe, for payment purposes only.

Supplied by Weks Data & Automation. (Wekesa Ezra), Nairobi, Juja, near JKUAT campus, Nairobi city, Nairobi, 00100, Kenya, who sells on GigBlend as a business (a trader) and is responsible to you for this service. GigBlend runs the marketplace and takes payment.

Choose your package

Packages compared. Prices include the buyer service fee.
FeatureBasicSelectedStandardPremium
All-in price£52.50£126.00£210.00
Deliverables
  • Merge or clean up to 5 CSV/Excel files into a single formatted output file.
  • Automating complex multi-sheet reporting, cross-file lookups, and data transformations.
  • End-to-end spreadsheet processing pipeline with GUI or scheduled execution
Turnaround3 days5 days7 days
Revisions1 included2 included3 included
Who produces itWekesa EzraWekesa EzraWekesa Ezra
Human reviewDone by a personDone by a personDone by a person
Filesno filesno filesno files

Prices are the total you pay, including the buyer service fee. Optional extras are chosen at checkout.

What we need from you

You complete this brief at checkout, before you pay. Nothing starts until it is submitted. Leave out personal data the work does not need.

  • Describe the manual Excel/CSV task you want to automate. What are the step-by-step actions you currently do manually?Required
  • What format are your input files in (.xlsx, .xls, .csv), and how many files need to be processed per run? Please attach sample files or scrubbed mock dataRequired
  • What exact output do you expect (e.g., a single combined .xlsx file, multiple .csv exports, specific tab layouts, font styling, or calculated summary metrics)?Required
  • Where will you run this Python script?Required
  • a) Local PC (Windows)Required
  • b) Mac/LinuxRequired
  • c) Google Colab/Jupyter NotebookRequired
  • d) Cloud/Scheduled ServerRequired
  • Are there specific formulas, lookup logic (VLOOKUP/XLOOKUP), column mappings, or edge cases (like blank cells or missing values) the script must handle?Required

How delivery works

  1. 1

    Pay and submit your brief

    Your order starts once payment and the brief are both in.

  2. 2

    Work in progress

    Wekesa Ezra works on your order and can message you from the order page.

  3. 3

    Delivered

    Files appear on your order page within 3 days. If that date passes, you can cancel for a full refund.

  4. 4

    Review, revise or accept

    Ask for up to 1 in-scope revision, raise an issue, or accept. With no action, delivery is accepted automatically after 3 days.

If an order cannot be completed, it is handled under the refunds and cancellation policy.

Something wrong with this listing? Report it

See more →
Continue — £52.50

Basic · incl. £2.50 service fee

I will build Python scripts to automate Excel… · GigBlend