A Python script that merges PDF files into one or splits large PDFs into parts by pages or by rules

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

Scanned contracts that came as one file per page, a 300-page statement that needs to go out client by client, a set of documents that has to be sent as one PDF: this Python script does such PDF jobs in seconds instead of clicking through an editor. It merges files in the order you set (by name, by date or from a list), splits a PDF into single pages, fixed ranges or parts that start at each bookmark, and in Premium can cut where a page contains a word you name, such as Invoice No. Pages keep their quality because they are copied, not printed again. Send us the job and one or two sample files with nothing private in them. You run the script yourself on your computer. It does not edit text or read scans.

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 order, ranges and names; the code is also shown on the order page.
• Merge in your orderBy name, date or a list you give
• Split your waySingle pages, ranges or bookmarks
• No loss of qualityPages are copied as they are
• Clear file namesNumbers, page ranges or names from your list
• Readable codeWith comments, easy to change a rule later

How it works

1. 1
   TaskYou describe the job and send one or two sample PDFs
2. 2
   CodeWe write the script and the guide to running it
3. 3
   Try itYou run it on copies of your files and check the pages
4. 4
   ChangesYou ask for changes within your package and send any error message

What we need from you

What you need done: which files to merge and in what order, or how to split (every page, every N pages, by ranges, by bookmarks or by a word on the page), and how to name the results. One or two sample PDFs with nothing private in them, or the same layout with made-up content; if the split depends on a word, a page that shows it. Roughly how many files and pages, and your system: Windows, macOS or Linux.

We will ask you:

• Merge, split, or one after the other?
• How do you know where each part starts?
• How should the files be named?
• Where will it run?

Compare packages

Questions and answers

Did not find your answer? Ask us