# ladykerr/pdf-to-excel architecture

> Architecture diagram of the GitHub repository ladykerr/pdf-to-excel, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-03). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/ladykerr/pdf-to-excel
- Repository: https://github.com/ladykerr/pdf-to-excel

## Overview

A small Python utility converts every table in a PDF into a separate Excel worksheet. The user runs the script or calls its function; the function reads all PDF pages with tabula-py and writes the returned tables through pandas. The source excerpt confirms the runtime calls; README text documents the input/output behavior.

Main entry points: [`pdf_to_excel.py`](https://github.com/ladykerr/pdf-to-excel/blob/main/pdf_to_excel.py) (PDF converter)

## Diagram (Mermaid)

```mermaid
flowchart TD

node_user(("User"))
node_converter["PDF converter<br/>[pdf_to_excel.py]"]
node_pdf["PDF input"]
node_tabula["tabula-py"]
node_tables["Extracted tables"]
node_pandas["pandas ExcelWriter"]
node_excel["Excel workbook"]

node_user -->|"runs"| node_converter
node_converter -->|"reads PDF"| node_tabula
node_pdf -->|"supplies input"| node_tabula
node_tabula -->|"returns tables"| node_tables
node_converter -->|"opens writer"| node_pandas
node_tables -->|"writes worksheets"| node_pandas
node_pandas -->|"writes workbook"| node_excel

click node_converter "https://github.com/ladykerr/pdf-to-excel/blob/main/pdf_to_excel.py"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_user toneBlue
class node_converter toneTeal
class node_pdf,node_tabula,node_tables,node_pandas,node_excel toneIndigo
```

## Components

### Other components

- **User**
- [PDF converter](https://github.com/ladykerr/pdf-to-excel/blob/main/pdf_to_excel.py): `pdf_to_excel.py`
- **PDF input**
- **tabula-py**
- **Extracted tables**
- **pandas ExcelWriter**
- **Excel workbook**

## Connections

- User → PDF converter: runs (evidence: `README.md`)
- PDF converter → tabula-py: reads PDF (evidence: `pdf_to_excel.py`)
- PDF input → tabula-py: supplies input (evidence: `README.md`)
- tabula-py → Extracted tables: returns tables (evidence: `README.md`)
- PDF converter → pandas ExcelWriter: opens writer (evidence: `pdf_to_excel.py`)
- Extracted tables → pandas ExcelWriter: writes worksheets
- pandas ExcelWriter → Excel workbook: writes workbook (evidence: `README.md`)
