Import a Numbers Spreadsheet into QuickBooks Online

QuickBooks Online can't open a Numbers file, so to import a Numbers spreadsheet into QuickBooks Online you export it to CSV first. Lay the table out as date, description and amount, choose File, Export To, CSV in Numbers, leave table names off, then upload the CSV through the bank upload and pick the matching account.

Laying out the Numbers table in bank upload columns

A Numbers table is ready for QuickBooks when it has one header row and one transaction per row, in the columns the bank upload reads. Intuit's help article on uploading transactions asks for three columns (date, description, amount) or four (date, description, credit, debit).

The three-column layout is the easier one to get right. Here is a sample table with made-up values:

Money out is negative and money in is positive. Keep the table plain. Remove any title row above the headers, any totals row at the bottom and any blank rows in between. If a column holds a formula, such as an amount calculated from two other cells, that is fine, because the export writes out the result. Notes or category columns can stay in the table for your own use, since you can simply skip them on the mapping screen.

If you track a debit card in the same table as the checking account, keep in mind that those purchases already sit inside the checking statement. The post on importing debit card transactions into QuickBooks Online explains why they belong in the checking account rather than in a card account of their own.

Exporting the Numbers spreadsheet to CSV on a Mac

Numbers exports CSV from the File menu. Apple's guide to exporting from Numbers on Mac says the CSV writes each cell's contents as values separated by commas, and offers a choice between one file per table or one combined file.

The steps:

1. Open the spreadsheet in Numbers and make sure the transaction table is the one you want.
2. Choose File, then Export To, then CSV.
3. Choose to create a file for each table, unless the spreadsheet holds only one table.
4. Leave "Include table names" unticked.
5. Leave the text encoding at its default unless your descriptions use accented letters that come out garbled, in which case open Advanced Options and pick UTF-8.
6. Name the file after the account and its dates, such as checking-2026-04, and save it.

The result is a .csv file you can drop onto the QuickBooks upload screen. The upload screens themselves are covered in the guide to importing bank transactions into QuickBooks Online.

Should the Numbers export include table names?

No. Leave "Include table names" off for a QuickBooks file. Apple's guide describes the checkbox as a way to include each table's name in the export. For a bank upload you want the very first line of the file to be your header row, so the mapping screen sees Date, Description and Amount where it expects them.

Any extra text in the file is text QuickBooks has to read past. If a name such as "Table 1" lands where the mapping screen expects column names, the preview will look wrong. You could untick the header option on the mapping screen and pick columns by hand, but the cleaner fix is to export again with the box unticked.

A title typed inside the table's first row is a different problem. It is part of the table, so it travels into the CSV as a line of data. Delete it before exporting, and keep any title outside the table instead.

Why check dates and amounts after the Numbers CSV export?

Check them because the CSV holds the stored cell values, and those may not look like what you saw on screen. A date shown as "Apr 1, 2026" in Numbers may be written differently in the file. An amount formatted with a currency symbol may carry it into the file, and QuickBooks reads an amount column as numbers only.

The quickest check is to open the CSV in TextEdit rather than in Numbers, because Numbers will format it again as it opens. The raw file for the sample table should read like this:

Date,Description,Amount
04/01/2026,Studio rent,-1200.00
04/03/2026,"Client payment, Harbor Cafe",860.00
04/07/2026,Paper and ink,-54.30
04/10/2026,"Client payment, Wren Books",415.00

Look for three things. The dates should follow one pattern all the way down. The amounts should have no currency symbol and no thousands separator. And any description containing a comma should be wrapped in quotation marks, as the two client payments are, so the comma isn't read as a new column.

If a date or amount looks wrong, fix the format of that column in Numbers, export again and recheck. Setting the date column to a fixed format such as 04/01/2026, and the amount column to a plain number with two decimals, usually does it. Then pick the matching date format on the QuickBooks mapping screen.

Numbers files with several tables or sheets

A Numbers file with several tables needs one CSV per bank account, because each upload goes into a single QuickBooks account. Apple's guide lets you create a file for each table, which suits a workbook with one table per account. Combining tables into one file only makes sense when they all belong to the same account.

If one account's transactions are spread over several tables, such as one per month, the combined option will join them, but check the result. Each table may bring its own header row, so check the file, because a header in the middle of the data is a row QuickBooks cannot read. Copying all the months into one table before exporting avoids that.

The same layout rules apply in other spreadsheet programs. The guides to importing Excel into QuickBooks and importing Google Sheets into QuickBooks Online as a CSV cover the export screens there. If your books are in FreshBooks rather than QuickBooks, the post on importing a bank statement into FreshBooks covers its own file rules.

If the rows in your Numbers sheet were typed in from PDF bank statements, there may be a shorter route. SimpleBankConvert is being built to produce the CSV straight from the PDF statement. Accounts are not open yet, and SimpleBankConvert's homepage shows the file it makes.