In this article, we will show you how to copy a table from PDF to Google Sheets. Simply follow the process below.
Unfortunately, copying a table from a PDF to Google Sheets can be difficult, as it is not as simple as copying and pasting text.
For this purpose, we will use Lido’s PDF Importer Tool and the EXTRACTTABLESFROMPDF formula to extract the table from the PDF directly into Google Sheets.
Follow these steps to extract tables from a PDF using Lido's PDF Importer tool, which you can then copy to Google Sheets:
Log into your Lido account and go to the Files page. Click on the "New file" button at the top right to make a new spreadsheet.
In your new spreadsheet, click on the "File" menu at the top. Choose "Import from PDF" from the dropdown list.
Click on "Click to Upload" in the file importer tool and choose the PDF file from your computer, or just drag and drop the file into the area.
Once your PDF is uploaded, you will be presented with an interface where you can select the specific area of the PDF containing the table you want to extract.
Adjust the selection box by dragging the blue corners to ensure all parts of the table are included, then click "Extract data" to start the extraction process.
Verify that all the necessary data has been extracted correctly in the new window. If it’s a table, it should be formatted accordingly.
Once you confirm the data is accurate, click "Insert at active cell" to proceed, or click "Back" if you need to return and repeat the process.
You can then select the entire table in your Lido spreadsheet, then right-click and choose "Copy," or use the shortcut Ctrl+C (Cmd+C on Mac).
Open your Google Sheets document, navigate to the desired location, right-click and select "Paste," or use the shortcut Ctrl+V (Cmd+V on Mac). This will transfer the extracted table from Lido to Google Sheets.
This method uses Lido’s custom formula EXTRACTTABLESFROMPDF to extract tables from a PDF.
Log into your Google Drive and upload the PDF file that contains the table you want to extract. Ensure the PDF is accessible online, as Lido will need to retrieve it directly from Google Drive.
Sign in to your Lido account and go to the Files page. Start a new spreadsheet by clicking on "New file." This will help you organize and analyze the data you've pulled from your PDF.
Click the plus (+) button to add a new worksheet to your spreadsheet. This new sheet will be where you input the formula and view the extracted data.
In the new worksheet, go to cell A1 and begin typing the EXTRACTTABLESFROMPDF formula: "=EXTRACTTABLESFROMPDF(". This formula is designed to identify and extract table data from the specified PDF.
Click "Add Credential" then "Connect to Google Drive." Follow the instructions to link the Google account where the PDF file is uploaded. This step is crucial as it allows Lido to access your Google Drive and the PDF file you uploaded.
After connecting your Google account, press the comma key to move to the next part of the formula. Click "Select a file" to bring up your Google Drive files.
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.
Type ",Sheet1!B2)" to indicate where the extracted data should be placed. In this instance, the data should go into worksheet Sheet1, beginning at cell B2. Press ENTER to complete the formula.
Right-click on cell A1 where the formula is entered and select "Run action" from the context menu.
Switch to Sheet1 to verify that the table has been extracted correctly and displayed as expected in the spreadsheet. Check for accuracy and completeness of the data.
You can highlight the entire table in your Lido spreadsheet, then right-click and select "Copy," or press Ctrl+C (Cmd+C on Mac) to copy it.
Open your Google Sheets document, navigate to where you want the data, right-click and select "Paste," or press Ctrl+V (Cmd+V on Mac). This will copy the extracted table from Lido to Google Sheets.
We hope that you now have a better understanding of how to copy a table from PDF to Google Sheets.