To Excel/CSV: Convert transactions to a CSV or Excel compatible format

To work with your bank or credit card transactions as a spreadsheet in software like Excel or Google Sheets or Open office, the transactions must be in CSV or Excel (XLS or XLSX) format.

Extract transactions from PDF files

PDF files are great to view and print transactions but are suitable for printing or archiving statements. PDF files are not to work with as spreadsheet or import into accounting software like Quickbooks or Quicken or Xero. To extract transactions from PDF files downloaded from your bank, use the Transactions app, Bank2CSV converters. The converter is designed to look for transaction details only, leaving other details from the documents. Unlike other 'generic' PDF text/table extractors saving all details into the Excel file, Bank2CSV target transactions only leaving the 'noise' behind.

Extracting transactions from OFX, QFX, QBO, QIF, MT940 files

OFX, QFX, QBO, QIF, MT940 formats are great to store transaction details and import into accounting software. Many accounting products prefer to work with these formats as they provide only one way to store transaction details, so there are fewer errors in parsing these files. However, for human beings, these formats are not good to view, read or work with. Use converters like the Transactions app, Bank2CSV to view OFX/QFX/QBO/QIF/MT940 file and convert transactions to CSV or Excel format.

Reformat CSV/Excel files into specific layouts

Some CSV files like PayPal transaction downloads or Stripe transaction export have too many columns to work with. When usually details like date, amount, description, check number are needed, such CSV files have many other details. When you try to import such CSV files into Xero or Quickbooks Online/SelfEmployed or Quicken for Mac or other accounting software 'supporting' CSV import, the software often refusing to import such CSV files.

Bank2CSV converter is designed to help you extract required transaction details and create a new CSV file ready to import into specific accounting products demanding a certain CSV layout (or column order or column names).

Choose the CSV target

Bank2CSV and other 2CSV converters have the "CSV target" feature to create the most suitable CSV file from QFX, QBO, OFX, QIF, PDF, CSV files:

Import bank transaction files (OFX, QFX, QBO, QIF, PDF, MT940) into Excel

Import bank transactions into Excel (or convert to CSV and open either in Excel or other spreadsheet software). Online banking sites (as well as online credit card sites or investment brokers) provide “accounting downloads” in PDF, QIF, OFX, QFX, QBO formats. To open these files in Excel (or convert to CSV), use the converters listed below. Bank2CSV converters support extended QIF format to convert data exported from Quicken as QIF format (for transactions, memorized transactions, and categories).

Import bank transactions into Excel (convert to CSV)

Import transactions directly into Excel without saving to CSV file

Import Quicken QFX files into Excel

QFX files are extended OFX files and are not easy to read or work with if you are a bookkeeper or an accountant. QFX files are great to import transactions into accounting software like Quicken. QFX files are usually provided in your bank's Online Banking.

Can Excel open QFX, QBO, OFX, QIF, PDF, MT940 files?

No. You can try to manipulate QFX/OFX/QBO files into XML files, and then try to open this XML file in Excel. You can copy and paste from PDF files into Excel one row/column Save your time and use a specialized tool: Bank2CSV. Check if your bank provides CSV or Excel downloads.

How to import a QFX, QBO, OFX, QIF, PDF file into Excel

Here is a short video (1 min) showing the whole process of converting a QFX file to CSV format with QFX2CSV with other converters use a similar process:

How to convert a QFX, QBO, OFX, QIF, PDF file into a CSV file

How to convert a QFX, QBO, OFX, QIF, PDF file into Quickbooks Online ready CSV file

How to convert a QFX, QBO, OFX, QIF, PDF, MT940 file into Xero ready CS file

Supported Account types

Related articles