I will automate your weekly excel or CSV sales report with python

South Korea

I speak Korean, English

Excel and CSV weekly report automation with Python

I build small tools that turn the Excel and CSV files you export every week into the same finished report with one click. I work with Python and Excel: merging files with different column names, clean...
About this Gig

Do you build the same sales or KPI report by hand every week? Copy the exports, fix the columns, paste, sum, make the chart, check it again.

Send me the files you export each week and the report you make today. I build a small Python tool that turns them into the same report.

It handles:

  • Files with different column names
  • Exports where the header is not on the first row
  • Files with quantity and unit price but no total
  • Comparison with last week, by channel and by product

You get:

  • One Excel workbook: Summary, By Product, By Day, All Orders, Check
  • The Check sheet lists every source file, rows read and its total. They must match the report
  • A Windows tool (Python, runs outside Excel; no Excel button or VBA) and a one-page guide

How we work:

  • You send exported files only. I never ask for passwords or account access
  • Please remove customer names, emails and phone numbers first
  • I test the tool on your real files before delivery

Not included: live sync with online accounts, automatic emailing, Power BI, accounting or tax advice.

Before ordering, send an anonymized sample to confirm size, rows, formats and acceptance criteria.

Technology:

Excel

•

Python

Expertise:

Data manipulation

•

Data validation

•

Normalization