Convert PDF, QBO, QFX, OFX, QIF, MT940 to CSV or Excel

Excel cannot open the transaction files banks, credit card sites and brokers offer: QBO, QFX, OFX, QIF, PDF and MT940. You can open some of them as text, but they are hard to read or edit. Convert them to CSV or Excel with ProperConvert and you get a plain table you can sort, filter and import.

Convert a transaction file to CSV or Excel

1. Log into your bank, credit card or broker site and download your transactions.
2. Download and install ProperConvert (free trial).
3. Start ProperConvert, click Browse, select the file (PDF, QFX, QBO, OFX, QIF, CSV or MT940) and click Open.
4. Review the transactions on screen.
5. Set the CSV target (see below) and the format: CSV or Excel.
6. Convert and save the file where you want it. Or copy to the clipboard and paste straight into a spreadsheet.

See select files and work with transactions for the details of each step.

Supported account types

• Bank (checking, savings, credit line): PDF, QFX, QBO, OFX, QIF, CSV, MT940.
• Credit card: PDF, QFX, QBO, OFX, QIF, CSV.
• Investment: QFX, QBO, OFX, QIF.

Choose the CSV target

The CSV target sets the columns of the output file:

• Regular CSV, or Excel XLSX/XLS: all details.
• QuickBooks Online CSV: date, description, amount. See QuickBooks Online.
• Xero CSV: date, description, amount, payee, reference, check number. See Xero.
• Quicken for Mac (CSV Mint): date, amount, description. See Quicken.
• Clipboard: all details, no file saved. Paste directly into Excel.

If your accounting app does not import CSV, convert to OFX instead.

Extract transactions from PDF bank statements to Excel

PDF statements are easy to view and print, but hard to copy transactions from. ProperConvert extracts the transactions and leaves out the fine print and legal text.

• Pulls the date, amount, description and check number.
• Works with statements in many layouts.
• Reads text-based PDFs best. Image and scanned PDFs are read with OCR (optical character recognition).
• Lets you choose the fields, then save as CSV or Excel, or copy to the clipboard.
• Runs on your computer. Your own and your clients' statements are not uploaded anywhere.

With the data in a spreadsheet you can sort, filter and review it for analysis, budgeting and tax prep, without typing each transaction by hand. See convert PDF to CSV.

Open QBO, QFX or OFX files in Excel

Online banking offers QBO, QFX and OFX files for transaction downloads. OFX files are also called "Microsoft Money" files. They hold the date, amount, payee or payer, memo, check number, and investment details. These formats store data in one fixed way, so they convert cleanly, but they are hard to read as they are. See convert QFX to CSV.

Open QIF files in Excel

QIF (Quicken Interchange Format) files hold transaction details. They come from:

• a download from your bank, credit card company or broker;
• an export from Quicken;
• an export from some other personal finance apps.

Excel and Google Sheets cannot open QIF files directly. Convert QIF to CSV or Excel first.

Open MT940 files in Excel

Many banks provide MT940 (also called SAT) files for transaction downloads. They are not readable in Notepad or Excel. Convert them to CSV or Excel first.

Extract columns from multicolumn CSV files

Some CSV files, like PayPal or Stripe exports, have too many columns. Most accounting apps only need the date, amount, description and check number. Xero, QuickBooks Online and Quicken for Mac import CSV but may reject files with extra columns.

Open the file in ProperConvert, pick the details you need, and save a simplified CSV that is ready to import. See export CSV from PayPal.

Convert Microsoft Money and Quicken data files

• MS Money (.mny): open the file in Microsoft Money Sunset Edition on Windows and export to QIF. Then convert the QIF to CSV or Excel. See MNY to CSV.
• Quicken (.qdf): you need Quicken installed to open a QDF file. Export the data as QIF, then convert the QIF to CSV or Excel. See QDF to CSV.

CSV/Excel extraction questions

Is there an online version of the converter?

No. ProperConvert runs on your Windows or macOS desktop, so your data stays on your computer.

Does it work with scanned PDF statements?

Yes. Text-based PDFs give the best results, and OCR is included for image and scanned statements.

Can I paste the transactions into a spreadsheet without saving a file?

Yes. Choose the Clipboard target, then paste into Excel or Google Sheets.

CSV/Excel output settings

CSV is useful for review in a spreadsheet and for imports that accept a simple transaction table. A general-purpose layout uses Date, Memo, and Amount. Some destinations instead require separate Debit and Credit columns, so choose the column arrangement before saving.

Keep amounts numeric: do not place a currency symbol inside the amount cell. Use explicit signs in a single Amount column, or unsigned values in separate Debit and Credit columns. Save account name, currency, and statement notes outside the transaction table unless the destination explicitly requests them.

CSV/Excel questions

Can I set the output date format?

Yes. Choose the date order required by the destination, such as MM/DD/YYYY, DD/MM/YYYY, or YYYY-MM-DD. Use four-digit years so spreadsheet software does not infer the wrong century or year.

Can I set the decimal separator?

Yes. Use a point or comma according to the destination and regional settings. The field delimiter must remain unambiguous; a comma-decimal CSV commonly uses a semicolon as its delimiter.

Does the CSV open in Microsoft Excel?

Yes. Excel opens CSV files directly. Confirm that Excel interpreted dates and decimal marks correctly before saving, because spreadsheet auto-formatting can change them.

Does the CSV work with Google Sheets?

Yes. Import the CSV into Google Sheets and select the locale and separator that match the file. Review dates and amounts after import before sharing or exporting it again.

Should debit and credit be one column or two?

Use one signed Amount column for a compact, general-purpose file. Use separate Debit and Credit columns when the accounting application or existing spreadsheet template requires them.