More articles

Import bank transactions 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 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 and QIF2CSV 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

Related articles for: