In this article, we will show you how to copy a bank statement into Excel using Lido. Simply follow the steps below!
To convert a PDF bank statement to Excel, we will be using Lido, which is a spreadsheet tool designed to streamline and automate repetitive tasks. You can register for an account using the following link for free: https://www.lido.app/go/signup.
Here's how to convert your PDF bank statement to Excel using Lido's PDF importer tool:
Log into your Lido account and navigate to the Files page. Create a new spreadsheet by clicking on "New file" to organize and analyze the data extracted from your PDF.
In your new spreadsheet, click on the "File" menu located at the top. Select the "Import from PDF" option from the dropdown menu. This tool will help convert PDF data into a structured spreadsheet format.
Press "Click to Upload" in the file importer tool and select the PDF you want to upload from your computer, or you can simply drag and drop the file.
After uploading the PDF, you will see an interface to select the specific area of the bank statement you want to extract.
Carefully adjust the selection box to include all parts of the table by dragging the blue corners that appear, then press "Extract data" to start the extraction process.
Ensure your data is complete and has been correctly extracted in the new window.
If the selected area contains only text, each line of text will be placed in a separate cell. For tabular data, it will be extracted as tables. If both tabular data and plain text are present, the plain text will be ignored.
Once done, click "Insert at active cell" to close the dialog box. If you need to extract more tables, click "Back" to return and repeat the process.
Your data should now be in your spreadsheet. After verifying all necessary data has been correctly extracted and is in your spreadsheet, click on the three-dot menu next to the worksheet's name, then select "Export Values to Excel."
Save your Excel worksheet to your computer.
Here, we'll use Lido's unique formula, IMPORTPDF, to extract all content from the provided PDF. Note that IMPORTPDF does not work with scanned PDF documents. If you have a scanned PDF bank statement, consider using the second method, which employs the EXTRACTTABLESFROMPDF formula.
Start by logging into your Google Drive account and uploading the PDF bank statement you want to extract data from by clicking on "New" then selecting "File upload." This is important as this will allow Lido to access your file online.
Log in to your Lido account and go to the Files page. Click on "New file" to create a new spreadsheet, which will serve as the document for organizing the data extracted from your PDF bank statement.
Within your Lido spreadsheet, click the plus (+) icon at the top left corner of your screen to create a new worksheet.
Type "=IMPORTPDF(GOOGLEDRIVEFILE" into cell A1 (excluding the quotation marks).
Click the "Add Credential" button that appears then in the dialog box, click "Connect to Google Drive" and follow the on-screen instructions to link the Google account where you uploaded the PDF. This will grant Lido access to your file. Ensure you complete all the steps to set up your account properly.
After connecting your Google account, press the comma key to move to the next argument in the formula. Then, click "Select a file" to open the file dialog.
In the file selector, navigate through your Google Drive and click on the bank statement you uploaded earlier. This will link the selected PDF directly to the IMPORTPDF formula.
Finish the formula by adding a close parenthesis and a comma, then typing your output cell to designate where the extracted data should be placed, for example, starting at cell B2 in Sheet1. Close the parentheses. The complete formula now looks like this:
=IMPORTPDF(GOOGLEDRIVEFILE(<drive-credential>,"<file>"),<output-cell>)
Press ENTER.
Right-click on cell A1 after entering the formula and select "Run action" from the context menu. This will execute the IMPORTPDF formula and start the data extraction process from your PDF
After the formula has executed, navigate to Sheet1 and review the extracted data. Ensure that all data is accurately displayed and correctly represented in the cells.
After verifying that the data extraction is correct, click the three-dot menu next to the Sheet1 tab and select "Export Values to Excel." This will convert your data into an Excel file, allowing you to save, share, or further analyze it outside of Lido.
For this method, we will use Lido’s custom formula, EXTRACTTABLESFROMPDF, which extracts all recognized tables from a PDF file. This formula is particularly effective with scanned documents.
Sign into your Google Drive account and upload the PDF file you wish to extract data from. Ensure the PDF is accessible online for use with Lido's tools.
Navigate to Lido's Files page and create a new spreadsheet by clicking on the "New file" button at the top right side. This document will be used to organize and manage the data extracted from your PDF file.
Click the plus icon at the top left corner next to your default sheet to add a new worksheet.
In your newly created worksheet, go to cell A1 and input the formula "=EXTRACTTABLESFROMPDF(".
Click the "Add Credential" button to link your Google Drive to Lido. Follow the on-screen instructions to connect your account and allow Lido to access your PDF file.
Press the comma key to advance to the next part of the formula (make sure it's inside the parentheses). Click "Select a file" to open the file selector.
Find and select the PDF bank statement you uploaded earlier to Google Drive. This will link the PDF to the formula for data extraction.
Complete the formula by typing ",Sheet1!B2)" to specify where the extracted data should be placed, starting at cell B2 in Sheet1. Press ENTER to finalize the formula.
Right-click on the three-dot menu in cell A1 and choose "Run action" from the context menu. This will run the formula and extract the table data from your PDF into the spreadsheet.
Switch to "Sheet1" to inspect the extracted data. Ensure the tables have been accurately extracted and correctly reflect the contents of your bank statement. Only tabular data will be extracted.
Once you have verified the extracted data from your bank statement, click the three-dot menu next to the Sheet1 tab and select "Export Worksheet to Excel."
We hope that you now have a better understanding of how to convert PDF bank statements to Excel.