I will write a python script to clean, merge and convert excel or csv files

K
koontzconsultes
K
koontzconsultes
Justin Koontz

About this gig

Copying the same columns between spreadsheets every week? Send me the messy files. I write a small Python script that cleans them, merges them and saves one tidy Excel or CSV, and you can run it again any time with one click.


WHAT I AUTOMATE

Merging exports: Shopify, Square, QuickBooks, bank or POS CSVs into one sheet

Cleaning: duplicates, dates, totals, inconsistent names

PDF tables (statements, invoices, reports) into Excel

Weekly or monthly summary tabs with charts


HOW IT WORKS

1) Send 2-3 sample files (fake or redacted numbers are fine) and the report you want at the end.

2) I build it in Python and test it on your samples.

3) You get the finished .xlsx, the script and plain-English run instructions. No coding needed on your side.


I automate my own store and finance reports the same way. Scripts run on Windows or Mac with free tools, and your files stay on your own computer.


Not sure which package fits? Message me a sample file first.

Get to know Justin Koontz

Justin Koontz

Shopify, Excel and Python Automation Specialist

  • FromUnited States
  • Member sinceOct 2026
  • Languages

    English
I fix and build the practical stuff small businesses get stuck on, and I deliver fast. Shopify: store setup, theme fixes, product imports, apps and channel setup. Excel and Google Sheets: formulas, dashboards, cleanup and Apps Script automations. Python: scripts that clean, merge and convert data or pull it from APIs. I recently built and launched my own 20-product Shopify brand end to end. Before that I spent 8 years as a precision CNC machinist, so I confirm scope up front, test before delivery and hit deadlines.

My Portfolio