QBO2CSV: Convert QBO to CSV/Excel

Need to work with transactions in Excel, but the file cannot be opened by Excel? The the ProperConvert app. It extracts transactions from QBO files and converts to CSV or Excel.

Pricing Download

extract transactions from QBO files

extract transactions as CSV in Excel

Convert QBO files to CSV (QBO2CSV)

This tutorial shows how to convert a QBO file from your bank or credit card statement to CSV format.

Use the ProperConvert app to convert QBO to CSV. Other formats are supported as well.

Step by step instructions for Windows

Follow the steps below for the Windows version, followed by the Mac version.

Make sure you are using the latest version of QBO2CSV. Download it from the QBO2CSV download page. Start QBO2CSV and select a QBO file.

QBO2CSV Windows Step 1: select a QBO file

Review transactions before converting. Check that dates are correct, have the correct year, amount, withdrawals, and deposits are shown in corresponding columns.

QBO2CSV Windows Step 2: review transactions

Choose the CSV Target: Regular CSV, Excel (XLS or XLSX), Quickbooks Online, Xero, Quicken for Mac (CSV Mint), POSH or copy to clipboard to be pasted into any spreadsheet software like Excel.

QBO2CSV Windows Step 3: CSV Target

Click the 'Convert' button to create a CSV file.

QBO2CSV Windows Step 4: click Convert

Confirm the file name and location.

QBO2CSV Windows Step 5: file name and location and save

Now the CSV file is created.

QBO2CSV Windows Step 6: csv file created

Review created CSV file and import it into Quickbooks Online, Xero or work with the file in Excel.

QBO2CSV Windows Step 7: Review created CSV file

See this tutorial for windows as a video:

Step by step instructions for macOS

Make sure you are using the latest version of QBO2CSV. Download it from the QBO2CSV download page. Start QBO2CSV and select a QBO file.

QBO2CSV Mac Step 1: select a QBO file

Review transactions before converting. Check that dates are correct, have the correct year, amount, withdrawals, and deposits are shown in corresponding columns.

QBO2CSV Mac Step 2: review transactions before converting

Choose the CSV Target: Regular CSV, Excel (XLS or XLSX), Quickbooks Online, Xero, Quicken for Mac (CSV Mint), POSH or copy to clipboard to be pasted into any spreadsheet software like Excel.

QBO2CSV Mac Step 3: CSV Target

Set 'Open after save' to open application handling converted files to start import right after the conversion.

QBO2CSV Mac Step 4: Open after save

Click the 'Convert' button to create a CSV file.

QBO2CSV Mac Step 5: click Convert button

Confirm the file name and location.

QBO2CSV Mac Step 6: confirm name and location and save

Now the CSV file is created.

QBO2CSV Mac Step 7: CSV file created

Review created CSV file and import it into Quickbooks Online, Xero or work with the file in Excel.

QBO2CSV Mac Step 8: Review created CSV file

See this macOS tutorial as a video:

Related articles