In this article, we will show you how to convert PDF to Excel from Google Drive using Lido’s pdf extraction tools and formulas. Simply follow the steps below.
We will be using Lido, which is a spreadsheet created to simplify and automate repetitive tasks. You can create your account by following this link: https://www.lido.app/go/signup. As a starting point, we assume you have a PDF document in Google Drive which you wish to convert to an Excel file.
In this approach, we'll employ Lido's unique formula, IMPORTPDF, to extract all content from the provided PDF. However, IMPORTPDF is not effective with scanned PDF documents. If you're dealing with a scanned PDF, you might want to look into the second method, which utilizes the EXTRACTTABLESFROMPDF formula.
You can create a new Lido spreadsheet by going to the Files page.
To create a new worksheet, click on the plus icon located at the top left corner of the screen.
Enter the formula "=IMPORTPDF(" into cell A1.
Click on "Add Credential" and follow the steps provided to link the Google account containing the PDF.
To move on to the next argument, press the "," key and then choose "Select a file" by clicking on it.
Select your PDF file in Google Drive.
Insert ",Sheet1!B2)" to complete the formula. The final parameter of the IMPORTPDF formula indicates the destination for the extracted data. In this case, it is set to position the extracted data in the Sheet1 worksheet, beginning at cell B2.
Right-click on cell A1 and select "Run action".
Change to the worksheet named Sheet1 and confirm that the data has been accurately converted.
Click on the three-dot menu adjacent to worksheet Sheet1 and choose "Export Worksheet to Excel."
In this method, we will use Lido’s custom formula EXTRACTTABLESFROMPDF which extracts everything from the PDF it recognized as a table. This formula works on scanned documents.
Generate a fresh Lido spreadsheet from the files page.
To create a new worksheet, click on the plus icon located at the top left corner of the screen.
Enter the formula "=EXTRACTTABLESFROMPDF(" into cell A1.
Click on "Add Credential" and follow the steps provided to link the Google account containing the PDF.
To move on to the next argument, press the "," key and then choose "Select a file" by clicking on it.
Choose a PDF file from your Google Drive to use.
The final parameter of the EXTRACTTABLESFROMPDF formula indicates the destination for the extracted data. In this case, it is set to position the extracted data in the Sheet1 worksheet, beginning at cell B2.
Right-click on cell A1 and select "Run action".
Change to the worksheet named Sheet1 and confirm that the data has been accurately converted.
Be aware that only data in tables will be converted. If you need to convert data that isn't in table form, you should consider using method 1.
Click on the three-dot menu adjacent to worksheet Sheet1 and choose "Export Worksheet to Excel."
We hope that you now have a better understanding of how to convert PDF to Excel from Google Drive.