Move a multi-page bank statement into Excel on Mac
When the only copy of a bank statement is a multi-page PDF, getting its transactions into a spreadsheet takes more than changing the extension. Lemora can extract its tables into an XLSX workbook on your Mac. The essential next step is to compare page boundaries, amounts and totals with the statement before analyzing the data.
Turn a PDF table into an Excel workbook
- Save the statement, invoice or report as a PDF in Finder. Keep the source available so you can compare it with the workbook.
- With Lemora running, select the PDF and press Shift-Command-E. Open the Convert page and choose XLSX.
- Open the saved workbook in your spreadsheet app. Check that the headings and values have landed in the intended columns.
- Compare several rows and any totals with the PDF before sorting, filtering or adding formulas.
Results are saved beside the originals when folder access is available, or in Downloads/Lemora otherwise. Source files are never overwritten.
Where to find these actions
- Convert → XLSX (Convert to Excel): Each table becomes a sheet, even one that runs over several pages.
What you get
Convert to Excel
Each table becomes a sheet, even one that runs over several pages.
Works with: PDFs with tables, such as statements, invoices and reports.
Use the bank's transaction export when one is available
Check whether the bank provides a CSV or spreadsheet download for the period you need. A structured export avoids reconstructing rows from a page layout. Use PDF extraction when the statement is the source available to you, and keep that statement beside the workbook throughout review.
Begin with the table you actually need
For a bank statement, that may be transaction dates, descriptions and amounts. For an invoice, it may be item names, quantities and prices. Identify those columns in the PDF first. This gives you a clear way to judge the conversion instead of treating an opened workbook as proof that every value is correct.
Check numbers before doing arithmetic
Inspect negative amounts, decimal separators, currency symbols and parentheses. Check whether a value is stored as a number or as text in your spreadsheet app. An amount that looks right on screen may still be excluded from a sum if it was imported as text. Reconcile a subtotal or closing balance with the source when the document provides one.
Pay attention where pages meet
Lemora can join a table that continues across pages. Review those boundaries carefully: repeated headers, page totals and wrapped descriptions can look like ordinary rows. Compare the last entries on one PDF page with the first entries on the next and confirm that nothing was duplicated, split or omitted.
If the workbook contains text instead of a table
When Lemora does not find a table, it falls back to exporting page text as rows. That can help recover content, but it is not the same as a reconstructed transaction table. Check whether the output has usable columns before sorting it or applying calculations.
Scanned statements need an extra level of review
A scan starts with pictures rather than selectable text, so recognition quality affects the extracted values. Faint digits and tightly spaced columns deserve particular attention. If the scan is difficult to read, obtain a clearer copy when possible. A workbook with plausible-looking figures still needs comparison with the original.
When CSV is the required output
Convert the PDF to XLSX first, then select the workbook in Finder and use Convert to CSV. Inspect the CSV in the application that will import it. CSV carries rows of values rather than a workbook's formatting, and the receiving application may interpret dates and numeric identifiers differently.
Keep debit and credit meaning intact
Check how this statement represents money in and money out before adding a signed amount column. Separate debit and credit columns, minus signs and parentheses are different conventions. Compare sample entries with the statement, and preserve the original extracted values while you work. A matching total is useful evidence, but it does not prove every row is correct.
Questions
Does the conversion recreate spreadsheet formulas?
Do not expect formulas from a PDF. A PDF generally shows the displayed result, not the formula that produced it. Build and verify any calculations you need in the workbook.
Is the PDF uploaded to extract its tables?
No. Lemora processes the PDF on your Mac.
Will every PDF produce a usable table?
No. Table structure, page layout and scan quality affect the result. Review the workbook before using it for analysis.
Try this workflow on your Mac
Download Lemora on the Mac App Store Free to try: every feature for your first 25 actions. macOS 15 or later.