Convert an Excel Spreadsheet to a QBO File for QuickBooks

Why QuickBooks Desktop won't import your Excel sheet

It feels like you should be able to hand QuickBooks a spreadsheet of transactions, but QuickBooks Desktop does not import Excel or CSV transaction files at all. It reads bank activity only from a QBO Web Connect file, so an .xlsx of dated rows, however tidy, has nowhere to go. Whether the spreadsheet came from another program's export or you built it yourself to track an account, it has to be turned into a QBO before Desktop will take it. Converting the workbook to a QBO re-packages your rows into the Web Connect format QuickBooks expects, so the same transactions import cleanly rather than being re-typed.

Preparing the worksheet before converting

A spreadsheet needs a little tidying that a bank's own file would not. Keep the transactions on a single worksheet with a header row on the first line, using columns for date, amount, payee or description, and optionally memo and check number, with one transaction per row. Then remove the things people add in Excel that are not transactions: subtotal and total rows, blank spacer rows, merged cells, and any formula cells, which should be pasted as plain values. Strip currency symbols and thousands separators out of the amount column, since QuickBooks wants a plain number like 1250.00 rather than a formatted 1,250.00 dollars. A clean sheet converts without surprises.

Converting the XLSX to QBO

With the worksheet prepared, upload it and convert it to a QBO. The converter reads the columns, maps date, amount, and payee into the Web Connect structure, and writes the QuickBooks identifiers the .qbo format requires, and every transaction stays reviewable before you export. Because an Excel file can carry hidden formatting that a plain CSV does not, having each value shown for review is where a stray character or a mis-typed amount gets caught. The output is a QBO carrying your exact transactions in the one format QuickBooks Desktop imports.

Importing the QBO into QuickBooks

Bring the QBO in the same way you would a bank download. In QuickBooks Desktop open the Banking menu, choose Bank Feeds, then Import Web Connect Files, select the QBO, and pick the account it belongs to. QuickBooks routes the transactions into the Bank Feeds Center, where you match and add them. If the account has an active direct-connect feed, deactivate its online services first so the Web Connect import does not conflict. QuickBooks Online is a little different, since it imports a CSV directly through Upload from file, so from Excel you would save a CSV or convert to QBO depending on the edition.

Accuracy and privacy

Because the conversion re-packages your rows rather than re-deriving them, the amounts, dates, and payees that import match the spreadsheet you started from. That matters most with Excel, where a formatted display can differ from the underlying value, so the review step confirms what will actually import. The workbook holds real account activity, so it is processed to build the QBO and then deleted automatically, with nothing retained on a server afterward. For anyone converting a file on behalf of a client, that automatic deletion keeps the account data from lingering in a third-party tool.

Frequently Asked Questions