In this article, we will show you how to scan bank statements into Excel using the Lido app. Simply follow the process below.
This guide will show you how to scan bank statements into Excel using Lido, a tool that automates various spreadsheet tasks. You can sign up for Lido here for free: https://www.lido.app/go/signup.
Here's how to OCR bank statements to Excel using Lido's PDF importer tool:
Log into your Lido account and navigate to the Files page. Click "New file" to create a new spreadsheet where you'll organize and analyze your bank statement data.
Open the "File" menu at the top of your spreadsheet. Select "Import from PDF" to convert your bank statement from PDF to an Excel-ready format.
Click on "Click to Upload" in the importer tool and select the PDF bank statement you wish to upload from your computer, or you can drag and drop the file directly into the tool.
After uploading the PDF, use the selection tool to choose the specific areas of the bank statement you want to convert. Adjust the selection box by dragging its corners to include all relevant data, then click "Extract data."
Check the extracted data in the new window to make sure all necessary information has been captured correctly. Click "Insert at active cell" to transfer the data into your spreadsheet. If you need to extract more data, click "Back" to repeat the extraction.
Once all data is in your spreadsheet and verified, click the three-dot menu next to the worksheet's name. Select "Export Worksheet to Excel" to save your data in Excel format.
In this method, we will use Lido's custom formula IMPORTPDF, which extracts all the content from your bank statement in one step. Make sure your document is in PDF.
Log into your Google Drive account and upload the bank statement you want to export to Excel. This step is necessary because the PDF file needs to be online to use it with Lido’s IMPORTPDF formula.
Open Lido and create a new spreadsheet by clicking on "New file." This will serve as your workspace where the bank statement will be imported.
Click the plus (+) button at the top left to add a new worksheet within your Lido spreadsheet. This new sheet is where you will insert the IMPORTPDF formula.
In cell A1 of the new worksheet, type "=IMPORTPDF(".
Click "Add Credential" and follow the instructions to connect the Google account where you uploaded your bank statement.
After connecting your account, type a comma to move to the next argument in the formula and then click "Select a file."
Browse through your Google Drive in the file selector and click on the PDF you previously uploaded. This action links the selected PDF directly to the IMPORTPDF formula.
Finish the formula by typing ",Sheet1!B2)" and press ENTER. This specifies that the data should be placed in worksheet Sheet1, starting at cell B2.
Right-click on cell A1 where you entered the formula and select "Run action" from the menu. This will execute the formula and begin the data extraction process.
Once the data has been extracted, click the three-dot menu next to the worksheet name and select "Export Worksheet to Excel." This converts your spreadsheet into an Excel file, which you can then save to your computer for further use or analysis.
We hope that you now have a better understanding of converting bank statements to Excel.
