Guides

How to get tables out of PDF files and into the tools you already use.

• How to copy a table from PDF to Excel →Four ways to copy a table from a PDF to Excel without columns falling apart: paste and split, Excel's own PDF import, Acrobat, and a table extractor.
• How to convert a bank statement PDF to Excel →Turn a PDF bank statement into an Excel sheet you can sort and sum: where to get the right file, how to convert it, and how to check that no transaction is missing.
• How to convert a PDF to Google Sheets →Google Sheets cannot open a PDF, but you can get its tables in. Two ways that work: through Google Docs, or by extracting the table to Excel or CSV and importing it.
• What is a QBO file? →A QBO file is a QuickBooks bank statement file, usually downloaded from your bank. What is inside it, how it differs from OFX, QFX and CSV, and where to get one.
• What is an OFX file? →An OFX file holds bank data in the Open Financial Exchange format. What the format is, how OFX 1.x and 2.x differ, and how it relates to QFX, QBO and CSV.
• Excel vs CSV: which is better for a bank statement? →CSV is plain text, Excel is a workbook. How the two formats differ, what gets lost in a CSV, and which one to pick for bank statement data.
• What is a searchable PDF? →A searchable PDF has real text you can select and search. A scanned PDF is only a picture. How to tell them apart and why it matters when you extract tables.
• How to read a bank statement →What each part of a bank statement means: statement period, beginning and ending balance, deposits, withdrawals and the running balance.

Or go straight to the tool: extract tables from a PDF.