In this article:
Blog
>
PDF

Convert Bank Statement PDF to Excel (Easiest Way in 2024)

In this article, we will show you how to convert PDF bank statements to Excel using the Lido app. Simply follow the steps below!

How to Convert PDF Bank Statement to Excel

To convert a PDF bank statement to Excel, we will be using Lido, which is a spreadsheet 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.

Method 1: Using the PDF Importer Tool

Here's how to convert your PDF bank statement to Excel using Lido's PDF importer tool:

Step 1: Create a New Spreadsheet

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.

bank statement pdf to excel

Step 2: Use the PDF Importer Tool

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.

pdf to excel bank statement

Step 3: Upload Your PDF Bank Statement

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.

convert bank statement pdf to excel

Step 4: Choose and Extract Data

After uploading the PDF, you will see an interface to select the specific area of the PDF 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.

pdf bank statement to excel

Step 5: Review and Insert Extracted Data

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.

convert pdf bank statement to excel free

Step 6: Export Your Data to Excel

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 Worksheet to Excel."

how to convert bank statement pdf to excel

Method 2: Using the IMPORTPDF Formula

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.

Step 1: Upload Your PDF to Google Drive

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.

convert pdf bank statement to excel

Step 2: Create a New Lido Spreadsheet in the Files Page

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.

pdf bank statement to excel free

Step 3: Add a New Worksheet

Within your Lido spreadsheet, click the plus (+) icon at the top left corner of your screen to create a new worksheet.

convert pdf bank statements to excel

Step 4: Enter the IMPORTPDF Formula

Type "=IMPORTPDF(" into cell A1 (excluding the quotation marks).

how to convert pdf bank statement to excel

Step 5: Connect Your Google Account

Click the "Add Credential" button that appears 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.

how to import pdf bank statement into excel

Step 6: Press Comma and Select a PDF File

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.

converting pdf bank statements to excel

Step 7: Link the PDF in Google Drive

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.

can you transfer a pdf bank statement to an excel spreadsheet

Step 8: Complete the IMPORTPDF Formula

Finish the formula by typing ",Sheet1!B2)" to designate where the extracted data should be placed, starting at cell B2 in Sheet1. Press ENTER to finalize and apply the formula.

Step 9: Run the IMPORTPDF Formula

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

Step 10: Check the Extracted Data

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.

Step 11: Export Data to Excel

After verifying that the data extraction is correct, click the three-dot menu next to the Sheet1 tab and select "Export Worksheet to Excel." This will convert your data into an Excel file, allowing you to save, share, or further analyze it outside of Lido.

Method 3: Using the EXTRACTTABLESFROMPDF Formula

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.

Step 1: Upload Your PDF Bank Statement to Google Drive

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.

Step 2: Set Up a New Spreadsheet in Lido

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.

Step 3: Create a New Worksheet

Click the plus icon at the top left corner next to your default sheet to add a new worksheet.

Step 4: Enter the EXTRACTTABLESFROMPDF Formula

In your newly created worksheet, go to cell A1 and input the formula "=EXTRACTTABLESFROMPDF(".

Step 5: Link Your Google Account

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.

Step 6: Proceed with File Selection

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.

Step 7: Select the PDF Bank Statement

Find and select the PDF bank statement you uploaded earlier to Google Drive. This will link the PDF to the formula for data extraction.

Step 8: Finalize the Formula

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.

Step 9: Execute 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.

Step 10: Review the Extracted Data

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.

Step 11: Export the Data to Excel

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.

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!