I will build python excel automation and pdf to excel data extraction
AI Agent Developer, MCP Servers, Telegram Bots, Excel Automation
About this Gig
Stop redoing the same Excel work every week. I build Python Excel automation and PDF to Excel data extraction pipelines that run in one click.
What I automate:
- PDF to Excel: invoices, bank statements, reports, extracted into clean structured sheets
- - Recurring reports: merge, clean, and format raw exports automatically
- - Dashboards that rebuild themselves from your data
- - AI steps where they genuinely help: messy text, categorizing, summaries (ChatGPT or Claude API)
What you get:
- A script or workbook that does the job on demand
- - Runs on Windows or Mac, no subscriptions required
- - Clear instructions and a short demo video
- - Full source code, yours to keep
Examples: 200 invoices into one clean sheet in 2 minutes. A weekly sales report that builds itself. A pile of bank statements turned into a categorized ledger.
Stack: Python (pandas, openpyxl), Power Query or VBA when they fit better, OpenAI or Anthropic API for AI steps.
Message me with a sample file and what you need out of it. I will scope it the same day.
Platform:
Excel
•
VBA
•
Microsoft Office
Development technology:
VBA
•
Excel
•
VLOOKUP
Expertise:
Pivot tables
•
Formulas
•
Functions
•
Macros
•
Dashboard
My Portfolio
FAQ
Do you work with Google Sheets as well?
Yes, I work with both Microsoft Excel and Google Sheets. I can also convert files between the two formats.
Will it work with my exact file layout?
That is the point of custom: I build against your real sample files and test on them. Send a sample and the output you want, and I will confirm scope before you order.
Do I need to install anything?
For Python pipelines you run a small script, with step-by-step setup for Windows or Mac included. If you prefer zero installs, I can build it in VBA or Power Query inside the workbook instead.
My PDFs are scans. Can you still extract the data?
Usually yes, with OCR. Send one sample and I will confirm accuracy before you order. Clean digital PDFs extract near-perfectly; scanned documents depend on scan quality.
What about sensitive data?
Send redacted samples for scoping. The final script runs on your machine, so live data never has to leave your computer. Shared files stay private and are deleted after delivery on request.
Is AI required for this?
No. Most automations are plain Python or VBA, fast and free to run. I only add ChatGPT or Claude API steps where they clearly earn their cost, like messy unstructured text.

