Convert a Bank Statement PDF to Excel or CSV

The safest way to convert a bank statement PDF to Excel or CSV is to use your bank's official CSV export when available, or use a trusted table extraction workflow and then verify every date, description, debit, credit, and balance column before importing. PDF conversion is useful, but it is easier to corrupt data than a direct CSV export.

Try the official export first

Many banks offer:

• CSV export
• Excel export
• OFX/QIF export
• Account activity download

Use those before converting a PDF. A direct export usually has cleaner columns and fewer formatting errors.

When PDF conversion is needed

PDF conversion may be needed when:

• The bank only provides PDF statements.
• Older statements are PDF-only.
• A card statement has no CSV option.
• You need historical rows from archived documents.

If Tika has a verified parser for that bank and statement profile, use the Bank Statement Import workflow directly. Otherwise, convert carefully and review the output.

Check the extracted columns

After converting, confirm:

| Column | Check | |---|---| | Date | Same date format on every row | | Description | Merchant text did not split into multiple rows | | Debit | Outflows are clean numeric values | | Credit | Inflows are clean numeric values | | Amount | Signed amount is correct if debit/credit are merged | | Balance | Optional, but useful for reconciliation |

Remove page headers, footers, subtotal rows, and blank lines before import.

Watch for PDF extraction errors

Common issues:

• Descriptions split across rows
• Debit and credit columns swapped
• Decimal places lost
• Negative signs removed
• Page totals imported as transactions
• Dates mixed with reference numbers
• Password-protected files extracted incorrectly

If the converted file looks suspicious, do not import it until corrected.

Clean the CSV before upload

Use one row per transaction.

Minimum clean file:

date,description,amount
2026-06-01,Groceries,-120.50
2026-06-02,Salary,8000.00

If the file has separate debit and credit columns, map them carefully or convert them into one signed amount column.

Review after import

After upload:

1. Check duplicate warnings.
2. Confirm debit/credit signs.
3. Review categories.
4. Mark transfers.
5. Reconcile closing balance.

Use Why Your CSV Import Has Wrong Categories if categories look wrong.

Security note

Bank statements contain sensitive financial data. Use trusted tools, avoid uploading documents to unknown converters, and delete local temporary files when finished. If a statement is password-protected, treat the password as sensitive.

See Is It Safe to Upload Bank Statements to a Finance App?.

The short answer

Use official CSV or Excel exports first. Convert PDFs only when needed, clean the columns carefully, remove non-transaction rows, verify signs and balances, then import and reconcile.

Start with the CSV Bank Statement Import Guide.