Skip to content

About

Streamlit app for multi-PDF table extraction using pdfplumber, automated cleaning, merging into downloadable Excel.

Topics

Resources

Stars

4 stars

Watchers

0 watching

Forks

Latest commit

 

History

10 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

📄 PDF Table Extractor & Excel Merger

A fully automated, web-based PDF table extraction platform built with Streamlit
Seamlessly convert tabular data from multiple PDF files into a single, downloadable Excel sheet.

Streamlit Python 3.10+ License


🔗 Use Online

Use the app instantly without any installation here:
👉 https://pdf-table-extractor-app.streamlit.app/

Just upload your PDF files, click Start, and download the merged Excel file in one click.


🚀 Key Features

  • 📥 Multi-PDF Upload: Upload multiple .pdf documents simultaneously.
  • 📄 Page-by-Page Extraction: Parses and extracts tables from every page (skipping page 1 by design).
  • 🧹 Automated Cleanup: Removes redundant headers, normalizes formatting, and replaces noisy dash lines.
  • 📊 Unified Excel Output: Consolidates extracted data from all PDFs into a single, clean Excel sheet.
  • ⬇️ Instant Download: One-click download of the processed Excel file—no file saved on server.

🛠️ Technology Stack

  • Backend: Python 3.10+
  • Libraries:
    • pdfplumber — For precise table extraction
    • pandas — Data manipulation and merging
    • openpyxl — Excel writer engine
    • streamlit — Lightweight Python UI framework

💼 Enterprise Use Cases

This tool is ideal for:

  • Government records processing
  • Educational institutes handling exam or admission PDFs
  • Healthcare systems aggregating reports from multiple sources
  • Financial auditors compiling bank/export reports

If your organization routinely receives tabular PDFs, this app can eliminate hours of manual copy-pasting.


💻 Local Development

git clone https://github.com/MuditIsOP/pdf-table-extractor-streamlit.git
cd pdf-table-extractor-streamlit
pip install -r requirements.txt
streamlit run app.py

☁️ Cloud Deployment (Streamlit Cloud)

  1. Fork or clone this repository
  2. Navigate to https://streamlit.io/cloud
  3. Connect your GitHub account
  4. Deploy this repo in one click

You'll get a public link to share with colleagues or clients.


👨‍💻 Author

Mudit Sharma
🎓 B.Tech in Artificial Intelligence, BBD University, Lucknow
💼 Passionate about automation, AI, and building tools that save human hours.
🔗 LinkedIn Profile


📝 License

Distributed under the MIT License. See LICENSE for more information.

About

Streamlit app for multi-PDF table extraction using pdfplumber, automated cleaning, merging into downloadable Excel.

Topics

Resources

Stars

4 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages