A Python script that builds a short report from your Excel files and emails it from your own mailbox

Example result

python merge_sales.py --month 2026-10

2026-11-02 09:14:03 INFO  Folder: sales/2026-10, 9 files found
2026-11-02 09:14:03 INFO  shop-01.csv: 1,284 rows
2026-11-02 09:14:04 INFO  shop-02.xlsx: 967 rows
2026-11-02 09:14:04 WARN  shop-07.csv: 3 rows without a price skipped (lines 88, 412, 913)
2026-11-02 09:14:05 INFO  Done: 10,412 rows -> report-2026-10.xlsx (sheets "Sales" and "Totals")

[columns]
date = Date, Sale date, Day
product = Product, Item, Name
quantity = Qty, Quantity, Pcs
price = Price, Unit price

def read_shop_file(path: Path, columns: dict[str, list[str]]) -> pd.DataFrame:
    """Reads one shop's file and gives it the report's column names."""
    table = pd.read_excel(path) if path.suffix == ".xlsx" else pd.read_csv(path, encoding="utf-8-sig")
    renamed = {}
    for name, variants in columns.items():
        found = next((c for c in table.columns if c.strip() in variants), None)
        if found is None:
            raise ReportError(f"{path.name}: no column for '{name}' (looked for {', '.join(variants)})")
        renamed[found] = name
    table = table.rename(columns=renamed)[list(columns)]
    table["shop"] = path.stem
    return table

About this service

If someone in the office opens the same Excel file every morning, copies the totals and writes them into an email, this Python script can do that part. It reads the files you name, such as yesterday's sales export or a stock sheet in a shared folder, counts what you ask (totals, counts, averages by shop or product, the rows over a limit) and sends a short email with a neat table to the people you list, from your own mail account, with the file attached from Standard. You put the mail account's sending password into the settings yourself; it never goes into the code. The recipients are your own colleagues or clients, well within your mail service's sending limits. It reports the figures in your files; it does not check or explain them.

What is included

• What you getA ZIP archive with the Python script, a README with step-by-step instructions and, from Standard, a settings file with files, recipients and mail settings; the code is also shown on the order page.
• Your figuresTotals, counts and averages you choose
• A readable emailA short table that opens on a phone
• From your mailboxYour own mail account, password kept out of the code
• File attachedFrom Standard, the Excel file or a summary of it
• Readable codeWith comments, easy to add a figure later

How it works

1. 1
   TaskYou send a sample file and an example of the email you want
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it with only your own address on the list
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

One of the Excel files the report is made from, cut to a few rows or with figures changed, where the files appear (a folder, a shared drive) and how they are named, what the email should show (write it out as you would by hand), who gets it and from which mail account (naming the mail service is enough; the password you enter yourself). When it should go out, and the computer it will run on: Windows, macOS or Linux.

We will ask you:

• Which files is the report made from?
• What should the email show?
• Who gets it, and when?
• Where will it run?

Compare packages

Questions and answers

Did not find your answer? Ask us