Hands on a laptop exporting comma separated data files

Retail analyst checking a long product export on a monitor

Excel to QuickBooks CSV converter for bank transaction and list imports

QuickBooks Online imports bank transactions from CSV files in a fixed layout, either Date, Description and Amount or Date, Description, Credit and Debit. Arrange your Excel columns in that order, keep one date format, convert the sheet to UTF-8 CSV and upload it in QuickBooks. XlsConverter prepares the file, and you review the import inside QuickBooks.

XLSX Encrypted, deleted after conversion

XLS, XLSX, XLSM, XLSB, ODS, CSV, TSV, Numbers, JSON, XML

Google Sheets share link

Convert to

Encrypted, auto-deleted

Demo converts up to 100 rows, once.

Sheet

Delimiter

Encoding

JSON shape

Minify JSON

SQL dialect

Table name

Wrap in a transaction

Dates

Row element

Orientation

Workbook password (if protected)

Trim spaces in every cell Remove duplicate rows Drop empty columns Stack all sheets into one table

Short answer

To import an Excel file into QuickBooks Online, reduce the sheet to the columns QuickBooks accepts (Date, Description, Amount, or Date, Description, Credit, Debit), use one date format, save it as CSV and upload it from the bank transactions screen. Remove totals, merged cells and extra columns. XlsConverter converts the XLSX or XLS to that CSV in a browser or in batch, with sheet, delimiter, encoding and date format fixed.

A bookkeeper receives a client bank export, a card statement or a vendor list as an Excel workbook, and QuickBooks Online wants a plain CSV in a fixed shape. Extra columns, a title row above the headers, amounts with currency symbols or a mix of date formats are the usual reasons an upload is refused or lands with the wrong figures. Once you serve several clients a month, fixing each file by hand costs real hours.

Arrange the columns first, then convert with comma and UTF-8 selected. The UTF-8 CSV conversion settings explain the encoding choices, and batch Excel to CSV conversion applies the same settings to a whole folder of client workbooks so every file loads the same way.

How to convert Excel to QuickBooks CSV in three steps

1Open the workbook and keep only the transaction rows. Arrange the columns as Date, Description and Amount (expenses negative, deposits positive), or as Date, Description, Credit and Debit. Remove title rows, subtotals, merged cells and notes.
2Choose the sheet, then CSV, comma and UTF-8, and pick a single date format for the date column. Convert and open the download to confirm headers, signs on the amounts and any special characters in descriptions.
3In QuickBooks Online, open the bank transactions upload screen, choose the bank or credit card account that matches the statement, upload the CSV and review the preview before you confirm. Load one month as a test before a full year.

Prepare Excel columns for a QuickBooks Online import

Intuit documents two accepted layouts for bank transaction CSV files. The three column layout uses Date, Description and Amount, with money going out shown as a negative number and deposits as a positive one. The four column layout uses Date, Description, Credit and Debit, and the Credit and Debit headers should read exactly that, without the word amount. Intuit also asks for a single date format throughout the file and for unneeded columns to be deleted. Check the current help article for your QuickBooks edition before each new client.

Signs and splits cause most wrong balances. A bank export that lists all amounts as positive numbers with a separate type column needs a sign applied, or a split into Credit and Debit, before conversion. Do it in Excel, check a few rows against the statement, and only then convert. Amounts must be plain numbers, so strip currency symbols and text before you save.

Select the right destination account when you upload. Card statements belong in a credit card account, not a bank account, and QuickBooks does not import into a subaccount. XlsConverter prepares the file only. It does not categorize transactions or check totals against your books, so review the QuickBooks preview before you accept.

Options for Excel to QuickBooks CSV

Sheet selection: Convert the first sheet, a named tab or all tabs, one CSV per tab. Keep summary and notes tabs out of the load file.
Delimiter and encoding: Choose comma and UTF-8 for QuickBooks. Semicolon, tab, pipe, UTF-8 with BOM and Latin-1 remain available for other destinations.
Date output: ISO 8601, US and EU date options are available in the converter and batch screens. Pick the one that matches your QuickBooks region setting and use it for every row.
Cleanup: Trim stray spaces from descriptions, drop empty columns and remove duplicate rows before upload.
Header templates: Business pipelines use a saved schema template to rename client column names such as Posting Date or Memo to the Date and Description headers, with optional AI header normalization.
Batch size: Pro handles 50 files per batch and Business 500, so a month of client statements converts in one run.

Run it automatically

On Business, save a schema template that renames incoming headers to Date, Description and Amount, with optional AI header normalization. Pick up workbooks from an inbox or supported cloud source on a schedule or every new file, then deliver CSV to SFTP, S3, a webhook or email for review. Pipelines do not log in to QuickBooks or import records, and they do not split large files by row. You complete the upload in QuickBooks.

Finance team working through month-end close with laptops and printed reports

Import bank and credit card transactions from Excel into QuickBooks

Bank exports from smaller institutions and client supplied registers often arrive as workbooks with a header block, running balances and a totals row. Cut those down to transaction lines, one row per transaction, then convert the finished tab to CSV.

Formulas are written as their calculated value in the CSV, so a column built from a formula converts as the number you see. Keep the original workbook as your record of the client data.

Operations coordinator importing a supplier file into an ERP system

Load vendor and customer lists from a spreadsheet

List imports carry names, emails, phone numbers and addresses. Phone numbers and postal codes lose leading zeros if Excel stores them as numbers, so format those columns as text first. Accented names need UTF-8, which is why the conversion should be set explicitly and not left to a default save.

QuickBooks supplies its own spreadsheet and CSV templates for lists. Fill the template headers exactly, then convert the sheet. XlsConverter does not split files by row, so divide very large lists across tabs and export one CSV per tab.

Accounts payable specialist reviewing incoming email attachments in the evening

Prepare QuickBooks CSV files for every client each month

Use Pro when you convert several client workbooks together at month end. Use Business when clients send workbooks with changing headers and you want inbox or cloud pickup with saved header renaming. Business pipelines accept files from an email inbox, S3, Google Drive, Dropbox or a URL, on a schedule or on every new file, and deliver to SFTP, S3, a webhook or email. The automatic Excel to CSV workflow describes the pattern.

Pro costs 49 USD per month, or 24 USD per month billed yearly, with 2,000 conversions and 100 MB files. Business costs 149 USD per month, or 74 USD per month billed yearly, with 10,000 conversions, 20 pipelines, 5 seats and 1,000 AI runs. See Pro and Business plans for your client volume. Firms that also keep books in Xero can use the Excel to Xero CSV converter. The one-time demo covers the first 100 rows.

Compare ways to get an Excel file into QuickBooks Online

Method	Preparation	How records reach QuickBooks	Ongoing work	Best for
Save As CSV in Excel by hand	Reorder columns, fix dates and signs, save the file	Upload on the bank transactions screen	Repeat for every workbook and client	Occasional files with stable columns
QuickBooks import templates	Copy data under the template headers	Browser import with a preview	Repeat the mapping for each file	Small lists for one company
CSV to QBO converter or import app	Map fields in the app, often a desktop install	Web Connect file or direct sync into QuickBooks	Maintain mappings and a license	Banks that only export odd formats, direct syncing
XlsConverter	Match columns, choose sheet, delimiter and date format	You upload the prepared CSV in QuickBooks	Review the file and the QuickBooks preview	Recurring workbooks needing UTF-8 CSV and batch conversion

Import apps and QBO converters win when you need a Web Connect file, direct syncing or special bank formats. XlsConverter fits repeatable file preparation with batch conversion and saved header templates before the QuickBooks upload.

Excel to QuickBooks CSV questions

How do I import an Excel file into QuickBooks Online?

QuickBooks Online imports CSV, so arrange the sheet as Date, Description and Amount (or Date, Description, Credit and Debit), keep one date format, save it as UTF-8 CSV and upload it on the bank transactions screen. Review the preview before you confirm. Test with one month first.

Can QuickBooks Online import an XLSX file directly?

The standard bank transaction upload takes CSV files, so convert the workbook first. Apps that read Excel and push data into QuickBooks suit automated syncs. For a file based workflow, convert each workbook to UTF-8 CSV with the sheet and date format you choose, then upload it.

What columns does a QuickBooks bank transaction CSV need?

Intuit accepts a three column layout of Date, Description and Amount, or a four column layout of Date, Description, Credit and Debit. Expenses are negative and deposits positive in the three column version. Delete other columns and check the current help article for your edition.

Why does QuickBooks reject or misread my CSV?

Common causes are extra columns, a title row above the headers, mixed date formats, currency symbols in amounts and amounts with the wrong sign. Remove the extras, apply one date format, make amounts plain numbers and convert again. Then compare a few preview rows with the statement.

What date format should an Excel to QuickBooks CSV use?

Use one format in every row and make sure it matches your QuickBooks region setting. The converter and batch screens offer ISO 8601, US and EU date output. Mixed formats in one column cannot be repaired afterwards, so check a few rows in the CSV before you upload.

Does XlsConverter upload transactions directly to QuickBooks?

No, XlsConverter prepares CSV files that you upload yourself in QuickBooks. Business pipelines deliver to SFTP, S3, a webhook or email and do not log in to QuickBooks. Choose an import app if you need records pushed straight from the source without a manual upload.

Related converters

XLSX to CSV UTF-8 Excel to CSV in bulk Excel to CSV automatically Excel to Xero CSV Excel to NetSuite CSV XLS to CSV

Convert full files and batches

Pro starts at $24 per month billed yearly. Cancel any time.

See plans