In this article:

Extract Table from PDF (Easiest Way in 2024)

In this article, we will show you how to extract tables from PDF using an online tool called Lido. Simply follow the process below.

How to Extract Tables from PDF

The tool we will be using is called Lido. It is a spreadsheet for automating and simplifying repetitive tasks. You can make an account by following this link:

Method 1: Using the PDF Importer Tool

Here's how you can extract a table from a PDF file using the PDF importer tool in Lido.

Step 1: Start with a new blank Lido spreadsheet. 

Log into Lido and open a new, blank spreadsheet. This will be your workspace where the extracted table data from the PDF will be stored and managed.

Step 2: Select the PDF Importer tool from the File Menu.

Navigate to the File menu at the top of your Lido interface and select "Import from PDF". This tool is specifically designed to extract data, such as tables, from PDF documents and place it into your spreadsheet.

extract table from pdf

Step 3: Press "Click to upload" and choose your PDF file.

Click the "Click to upload" button within the PDF Importer tool to browse and select the PDF file from which you want to extract tables. Ensure you select the correct file containing the relevant data.

extract tables from pdf

Step 4: Move and resize the selection to cover the table you would like to extract and click "Extract data".

After uploading your PDF, a preview will appear allowing you to select the area containing the table you wish to extract. Adjust the selection box to precisely encompass the entire table, then click "Extract data" to initiate the extraction process.

pull table from pdf

Step 5: Confirm that the table has been correctly extracted from the PDF, then click "Insert at active cell".

Check the extracted table to ensure it appears correctly and all relevant data has been captured.

If the extraction is accurate, click on "Insert at active cell" to place the table into the spreadsheet at the selected cell.

If additional tables need to be extracted, click "Back" to return to the selection phase; otherwise, close the tool by clicking the "X" in the top right corner of the window.

extract pdf table

Step 6: The table is now in your Lido spreadsheet.

Confirm that the table is now correctly positioned and formatted within your document. This step completes the extraction process, and the data is now ready for any further analysis or manipulation.

get table from pdf

Method 2: Using the EXTRACTTABLESFROMPDF Formula

In this method, we will use Lido’s custom formula EXTRACTTABLESFROMPDF which extracts everything from the PDF it recognized as a table.

Step 1: Sign in into your Google Drive to upload your PDF.

Access your Google Drive account and upload the PDF file that contains the tables you want to extract. Ensure the PDF is accessible online, as Lido will need to retrieve it directly from Google Drive.

pdf table extraction

Step 2: Start with a new blank Lido spreadsheet. 

Create a new spreadsheet in Lido by opening a fresh, blank document. This spreadsheet will serve as your workspace for the table data you are about to extract from the PDF.

Step 3: Press the plus button to add a new worksheet.

Add a new worksheet to your spreadsheet by clicking the plus button. This new sheet will be where you input the formula and view the extracted data.

pdf table pull

Step 4: Insert formula "=EXTRACTTABLESFROMPDF(" into cell A1.

Go to cell A1 in the new worksheet and begin typing the EXTRACTTABLESFROMPDF formula. This formula is designed to identify and extract table data from the specified PDF.

pdf table retrieval

Step 5: Click "Add Credential" and follow the instructions to link the Google account where the PDF file is uploaded.

Initiate the credential linking process by clicking "Add Credential". This step is crucial as it allows Lido to access your Google Drive and the PDF file you uploaded, ensuring the formula can retrieve the necessary data.

extract data table from pdf

Step 6: Press the "," key to move to the next argument, then click "Select a file".

After adding your credentials, press the comma key to proceed to the next part of the formula where you will need to select the specific PDF file. Click "Select a file" to bring up your Google Drive files in a dialog box.

pull data table from pdf

Step 7: Choose the PDF file in your Google Drive.

Navigate through your files to locate and select the PDF from which you want to extract tables. This step links the chosen PDF directly to the formula in your spreadsheet.

retrieve data table from pdf

Step 8: Type ", Sheet1!B2)" to finalize the formula and press ENTER.

The final argument of the EXTRACTTABLESFROMPDF formula indicates where the extracted data should be placed. In this instance, we are specifying that the data should go into worksheet Sheet1, beginning at cell B2.

extract table content from pdf

Step 9: Right-click on cell A1 and select "Run action".

With the formula set, right-click on cell A1 where the formula is entered and select ‘Run action’ from the context menu. This command will execute the formula, triggering the extraction of table data from the PDF.

pdf extract table data

Step 10: Switch to "Sheet1" and ensure that the data has been extracted correctly.

Finally, navigate to "Sheet1" to verify that the tables have been extracted correctly and are displayed as expected in the spreadsheet. Check for accuracy and completeness of the data.

pdf table data extraction

We hope you now have a better understanding of how to extract tables from a PDF file.

Schedule a free automation consult
Learn more

Level up your Google Sheets skills with our free Google Sheets automation guide

Wasting too much time doing things manually in spreadsheets? Want to spend more time doing what you love? Our 100% free, 27-page Google Sheets automation guide is full of new tips and tricks that will save you time and money!