The pdf-to-excel-converter repository provides a web application designed to convert PDF documents into Excel spreadsheets. This application allows users to upload PDF files through a web interface and select specific conversion options, ultimately enabling them to download the processed data as an Excel file.
The core functionality of the application is centered around two primary extraction modes:
This mode extracts all textual content and tabular data from the PDF and consolidates it into a single Excel worksheet. This process involves merging diverse data types into a coherent output.
This mode focuses exclusively on identifying and extracting tabular data from the PDF. Each detected table is then organized into a separate sheet within the generated Excel workbook. This is particularly useful for PDFs where structured data in tables is the main interest. Users interact with the application by navigating to the main page, where they can upload a PDF file and choose their preferred extraction mode. Upon submission, the application processes the PDF, extracts the relevant content, generates an Excel file, and then offers it for download. The web application handles the file upload, initiates the conversion process, and manages the delivery of the final Excel output. The overall architecture is built around a Flask web application, which orchestrates these operations. For more details on the web application's structure and workflow, see Flask Application Structure and Workflow.
- Convert entire PDF text content into Excel format.
- Extract tables from PDF pages and export them as separate sheets in Excel.
- Easy-to-use web interface for uploading PDF files.
- Supports multiple processing options for different user needs.
- Well-structured codebase for easy customization and extension.
-
Clone the repository:
git clone https://github.com/yourusername/pdf-to-excel-converter.git
-
Navigate to the project directory:
cd pdf-to-excel-converter -
Install dependencies:
pip install -r requirements.txt
-
Start the Flask server:
python pdftoexcel.py
-
Open your web browser and navigate to http://localhost:5000.
-
Upload a PDF file using the provided form.
-
Choose the processing option:
- All Text: Convert entire text content of the PDF into an Excel file.
- Tables Only: Extract tables from the PDF and export them as separate sheets in Excel.
-
Click on the "Convert" button and wait for the conversion to complete.
-
Download the generated Excel file.
Contributions are welcome! Please follow these steps to contribute:
- Fork the repository.
- Create a new branch (
git checkout -b feature/yourfeature). - Make your changes.
- Commit your changes (
git commit -am 'Add new feature'). - Push to the branch (
git push origin feature/yourfeature). - Create a new Pull Request.
- Documentation: docs/ folder
- Bug Reports: GitHub Issues
- Feature Requests: GitHub Discussions
- Show Support: Star the repository if you find it useful!
This project is licensed under the MIT License - see the LICENSE file for details.