# Import Google Sheets into QuickBooks Online as a CSV

- Author: SimpleBankConvert (https://www.simplebankconvert.com)
- Published: 2026-01-05
- Updated: 2026-01-05
- Category: QuickBooks Online imports
- Canonical: https://www.simplebankconvert.com/blog/import-google-sheets-into-quickbooks-online

> Import Google Sheets into QuickBooks Online: lay out the sheet in bank upload columns, download it as CSV and avoid the date and number formats that fail.
To import Google Sheets into QuickBooks Online, arrange one tab as a bank upload file with Date, Description and Amount columns, download that tab as a CSV, and upload the CSV to the right bank account. QuickBooks cannot read a Google Sheets link directly, so the CSV download is the bridge between the two.

## Laying out a Google Sheets tab in bank upload columns

A Google Sheets tab is ready for the QuickBooks Online bank upload when row 1 holds the headers and every row below is one transaction. Use three columns, Date, Description and Amount, or four, Date, Description, Credit and Debit. Remove totals, notes, blank rows and anything else that is not a transaction.

Intuit's [manual upload help page](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) gives the two layouts and a few extra rules: no more than 1,000 lines, a file of 350 KB or less, the word "amount" removed from Credit and Debit headers, and money cells left blank rather than filled with zeros.

In the three-column layout, money in is positive and money out is negative. In the four-column layout, both columns hold positive numbers, and the column itself says which way the money went. Pick one layout and stay with it, because the mapping screen asks you to choose each time.

Keep the transactions for one account per tab. If a tab mixes a debit card and a checking account, the upload puts every row into whichever account you pick. Card lines have quirks of their own, which [importing debit card transactions](/blog/import-debit-card-transactions-into-quickbooks-online) covers.

## Which Google Sheets date and number formats fail the upload?

Google Sheets formats that look fine on screen can turn into something else in a CSV. The usual problems are dates in more than one format, amounts with currency symbols or commas, and negative numbers shown in brackets. Set each column to a plain format before you download, so the file holds exactly what QuickBooks expects.

The table compares good and bad cells. The values are examples.

| Column | Works in the CSV | Causes trouble |
| --- | --- | --- |
| Date | 03/14/2026, the same format on every row | 14 Mar 2026 on some rows, 2026-03-14 on others |
| Date | A real date value | Text such as "Mon 03/14" with the weekday attached |
| Amount | -412.80 | $412.80, (412.80) or 412.80- |
| Amount | 1250.00 | 1,250.00 written as text |
| Description | EXAMPLE OFFICE SUPPLY | A cell with a line break inside |

To fix dates, select the column, use Format, then Number, and choose one date format for the whole column. Intuit's page asks for a single date format throughout and suggests splitting out a weekday if your source added one.

To fix amounts, choose a plain number format with two decimals and no currency symbol. If some amounts were typed as text, they will sit to the left of the cell. Retype them or convert them, or they may not import as numbers.

## Downloading the Google Sheets tab as a CSV file

Downloading is the step that turns a Google Sheets tab into a file QuickBooks Online can read. Open the tab you want, then use the File menu, choose Download and pick the comma-separated values option. The file lands in your computer's downloads folder, ready to upload.

[Google's help page on downloading a file](https://support.google.com/docs/answer/49114) gives the path: open the file, select **File**, then **Download**, and choose a file type. For QuickBooks, choose CSV.

Open the downloaded file in a plain text editor before uploading if you want to be sure. Each line should look like `03/14/2026,EXAMPLE OFFICE SUPPLY,-412.80`, with nothing extra. Then upload it from the bank account's **Upload from file** option, match the columns on the mapping screen, and review the lines before you accept them.

Spreadsheet work is similar in Excel, though its save dialog has more CSV choices. [Importing Excel into QuickBooks](/blog/import-excel-into-quickbooks) covers that version.

## Does a workbook with several Google Sheets tabs upload in one go?

A workbook with several tabs does not upload in one go. A CSV holds a single table, so each download covers one tab. If you keep a tab per month or per account, download each one separately and upload each to its account, or copy the months you need into one tab first.

Copying months into one tab works well for a single account, as long as you stay under the 1,000-line limit. Remove the header rows from every pasted block except the first. Check that the dates still use one format, since tabs created at different times often drift apart.

Keep accounts separate. Upload the checking tab to checking and the card tab to the card account. Mixing them is one of the main causes of transactions landing in the wrong place.

## Uploading an edited Google Sheets CSV a second time

Uploading a corrected Google Sheets CSV again brings in every row a second time, including the rows that went in correctly. QuickBooks Online treats each upload as new lines to review. Before you upload a fixed file, remove the rows already in QuickBooks, or undo the first upload completely.

The simplest habit is to start each new file the day after the last transaction already in the account, which is the rule on Intuit's upload page. Keep a copy of each CSV you uploaded, named with the account and date range, so you know exactly what went in.

Duplicates from repeated imports are not limited to spreadsheets. QuickBooks Desktop users see the same thing with bank files, and [fixing duplicate Web Connect transactions in Desktop](/blog/duplicate-web-connect-transactions-in-quickbooks-desktop) covers that case. For receipts kept alongside your sheet, [uploading receipts to QuickBooks Online](/blog/upload-receipts-to-quickbooks-online) shows how to attach them to the lines you imported.

If your sheet started life as a copy of a PDF bank statement, there is a shorter route. [SimpleBankConvert](/) is being built to turn the PDF straight into an upload CSV with consistent dates and one amount column.