Data Table Extraction (PDF to Excel)

Extracts the data table from a PDF using the Python pandas function. The extracted data will be written into an Excel file

Top Benefits

  • Bot can be scheduled to run at any time
  • IT utility bot

Tasks

  • Data table extraction of PDF using Python
  • Extracts data table from PDF and write it into an Excel

The bot extracts table data from a PDF and writes the data into an Excel file. Python pandas function is used for extracting function. The bot can be used prior to using IQ Bot to extract data tables from PDF files and transfers the required data from the PDF into Excel.

Get Bot

Free

Bot Security Program
Level 1
Applications
Business Process
Category
Downloads
600
Vendor
Automation Type
Bot
Last Updated
May 19, 2021
First Published
March 24, 2021
Platform
Automation 360
ReadMe
ReadMe
Support

See the Bot in Action

Selecting the PDF page number to extracted
Excel sheet including the folder path
Data extracted from the selected PDF page range
PREV NEXT
Selecting the PDF page number to extracted
Excel sheet including the folder path
Data extracted from the selected PDF page range

Setup Process

Install

Download the Bot and follow the instructions to install it in your AAE Control Room.

Configure

Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)

Run

That's it - now the Bot is ready to get going!

Requirements and Inputs

  • Input PDF
  • Excel