# How to Import Excel into QuickBooks Without Errors - Author: SimpleBankConvert (https://simplebankconvert.com) - Published: 2026-10-16 - Category: QuickBooks Online imports - Canonical: https://simplebankconvert.com/blog/import-excel-into-quickbooks > How to import Excel into QuickBooks: tidy a spreadsheet of bank transactions, save it as CSV and upload it to Online or Desktop with no rejected rows. To import Excel into QuickBooks, clean the sheet so it has one header row and one transaction per line, save it as a CSV file, and upload that CSV through the bank upload screen. QuickBooks reads the CSV, not the Excel workbook, so the save step is not optional. ## Can QuickBooks open an Excel workbook directly? No. The QuickBooks Online bank upload takes a CSV, a text file or a bank file, not an Excel workbook with the .xlsx ending. Intuit's page on [manually uploading transactions](https://quickbooks.intuit.com/learn-support/en-us/help-article/import-transactions/manually-upload-transactions-quickbooks-online/L0rE9OXBz_US_en_US) names .csv, .txt, .qbo and .ofx for a transaction list, and does not list Excel. ### What that means for your sheet You keep working in Excel, and the CSV is a copy you make for QuickBooks. A CSV holds only the visible values in one sheet, as plain text. Colors, column widths, extra tabs, formulas and formatting do not travel. This is useful: it means the clean-up you do is about what the cells contain, not how they look. ### Keep the original Save your workbook first under its own name, then make the CSV as a second file. If QuickBooks rejects the CSV, you fix the workbook and save again. If you overwrite the workbook with the CSV, you lose the formulas and the extra sheets. ### Online and Desktop The same CSV idea applies to QuickBooks Online. QuickBooks Desktop handles bank files differently, and its CSV route has its own steps, which are covered in the guide to [importing CSV bank transactions into QuickBooks Desktop](/blog/how-to-import-csv-bank-transactions-into-quickbooks-desktop). The sheet clean-up in this post helps in both cases, but follow the matching guide for the upload itself. ### When the data is not bank data A sheet of bank transactions is what the bank upload expects: dates, descriptions and amounts that came out of an account. A list of customers, invoices or products is a different kind of data and goes through a different import in QuickBooks. This post is only about bank and card transactions. ## Tidying the Excel sheet: one header row, no totals A sheet that imports cleanly has a single header row at the top, one transaction on every line below it, and nothing else. The tidy-up removes every row that is not a transaction: titles, blank lines, subtotals and a grand total at the bottom. QuickBooks reads each row as a transaction, so a total row looks like a real payment. ### The shape QuickBooks wants QuickBooks accepts a three-column layout (Date, Description, Amount) or a four-column layout (Date, Description, Credit, Debit), according to Intuit's guide to [formatting CSV files in Excel](https://quickbooks.intuit.com/learn-support/en-uk/help-article/bank-transactions/format-csv-files-excel-get-bank-transactions/L4BjLWckq_GB_en_GB). Everything else on the sheet either gets mapped to one of those fields or removed. ### Before and after The table below shows a messy example sheet and what it looks like after cleaning. The values are made up for illustration. | Problem in the original | Example in the original | After cleaning | | --- | --- | --- | | Title row above the headers | "March activity, Example Bakery" in row 1 | Row deleted; headers are row 1 | | Merged header cell | "Amount" merged across two columns | One cell per column, one word each | | Split money columns with a note | "Withdrawals (USD)" and "Deposits (USD)" | Headers become Credit and Debit, or one Amount column | | Day name in the date | "Tue 03/04/2026" | 03/04/2026 | | Zero in the unused column | 0.00 in Deposits on a payment row | Cell left blank | | Totals row | "Total" with sums at the bottom | Row deleted | | Blank separator rows | An empty row between weeks | Rows deleted | A cleaned sheet of three rows then reads like this: | Date | Description | Amount | | --- | --- | --- | | 03/04/2026 | Coffee supplier | -86.40 | | 03/05/2026 | Customer payment | 1250.00 | | 03/09/2026 | Office rent | -950.00 | ### Delete, don't hide A row that is hidden in Excel still goes into the CSV. Hiding a totals row or an old transaction does nothing for the import. Delete the row, or move it to another sheet. ### Check the first and last rows Scroll to the top and bottom of the sheet. Stray notes, a "Report generated on" line or a page number often sit in those places. The first row should be the header and the last row should be a real transaction. ### Plain descriptions Intuit's formatting guide says the Description column should not contain numbers and that special characters such as quotation marks, ampersands and commas should be removed from all fields. Use Find and Replace to strip them. A description like "Supplies #442, Main St" becomes "Supplies Main St". ## Merged cells, formulas and other Excel habits that break imports A spreadsheet that looks fine on screen can still be rejected, because what you see is not always what the CSV holds. Merged cells, formulas that return text, numbers stored as text, hidden columns and dates stored as plain words each change the saved file in ways that surprise people. ### Merged cells A merged cell keeps its value in the first cell of the merge, and the other cells it covers are empty in the CSV. A merged header over two columns becomes one header and one blank, and QuickBooks then sees a column with no name. Unmerge every cell, then give each column its own header. ### Formulas A CSV stores the result of a formula, not the formula. That is usually what you want, but a formula that errors out stores the error text, such as #VALUE!, in the file. Search the sheet for cells beginning with a hash sign before you save. If you built a running balance with formulas, delete the balance column, since the upload does not use it. ### Numbers stored as text A cell with a small green triangle in the corner often holds a number written as text, typically with a leading apostrophe or a trailing space. It may save fine, but the amount can read as text in QuickBooks. Convert the column to numbers, using the format option or a Paste Special that multiplies by one. ### Dates that are really words A date typed as "March 4th" is text, not a date. Excel only treats a cell as a date when it recognizes the pattern. Convert such cells to one date format, and keep the same format for every row, as Intuit's formatting guide advises. ### Hidden columns and extra sheets Hidden columns are saved in the CSV along with visible ones, and a CSV carries only the sheet that was active when you saved. Make sure the transactions sheet is the one open when you save, and delete any column you do not want sent. SimpleBankConvert exists for the case where you have a PDF statement and would otherwise retype it into a sheet. It is built to return a CSV with one date format and a single amount column, and it is not open yet, so [the get started page](/get-started) is where to ask for a place. ## Saving the Excel file as CSV the right way Save the cleaned sheet with File, Save As, and choose a CSV format in the file type list. Choose the plain comma-delimited CSV, not a macro-enabled or text format. QuickBooks reads CSV, and a wrong choice gives a file it cannot read. ### The Excel option to choose Excel's file type list offers more than one CSV entry. The plain CSV, comma delimited, is the safe pick. A variant that saves in UTF-8 also exists in newer versions of Excel. Either is a CSV, but if one is rejected, try the other. Intuit's formatting guide tells Mac users to save in Windows CSV format. ### The warnings Excel shows When you save, Excel says that only the active sheet will be saved and that some features may be lost. Both warnings are normal for a CSV. Choose to keep the format. Then close the file without saving again, and keep your .xlsx as the master copy. ### Open the CSV in a plain text editor Before you upload, open the CSV in Notepad or a similar editor. You should see lines of text with commas between values. Dates should look right, amounts should have no currency signs, and there should be no rows of only commas. A row such as ",,," at the end comes from stray formatting in empty rows, and it is easy to delete here. ### If the upload still fails Intuit's formatting guide suggests pasting the data into a new spreadsheet in the correct format and saving that as a Windows CSV. A fresh sheet drops hidden formatting that an old workbook has built up over the years. After the upload, the next problem is usually the mapping step, which is described in the post on [matching CSV headers on the mapping screen](/blog/quickbooks-import-csv-transactions#matching-csv-headers-on-the-quickbooks-mapping-screen). ### Size limits Intuit's page says an upload must be in English, 350 KB or less, and up to 1,000 lines. A spreadsheet of a whole year can exceed that, so split it by month or quarter and save a CSV for each part. ## What should the Excel amount column look like? For a three-column file, merge money in and money out into one Amount column with payments as negative numbers and deposits as positive ones. For a four-column file, keep two columns and fill only one per row. Either way, the cells should hold plain numbers with no symbols. ### Merging debit and credit into one column If your sheet has Withdrawals and Deposits, add a new Amount column. For each row, the amount is the deposit minus the withdrawal. As a formula, it looks like this, with the deposit in column D and the withdrawal in column C of the example: `=D2-C2` Fill it down, then copy the column and paste it back as values only. Delete the old two columns once you have checked a few rows. If you save the file with formulas still in place, the CSV holds the results, but pasting values keeps you safe from a broken reference. ### Or keep two columns If you prefer to keep them split, rename the headers to Credit and Debit and make sure each row has an amount in only one, with the other cell left empty. Intuit's guide says to leave cells that would hold only a zero blank. Check the mapping preview afterward, because which column QuickBooks reads as money in is something to confirm, not assume. ### Plain numbers only An amount should read -86.40, not ($86.40) or 86.40 CR. Remove dollar signs and thousands commas, and replace parentheses with a minus sign. Use the same number of decimal places throughout, which makes a visual scan easier. ### Credit card sheets A spreadsheet of card activity usually has charges as positive numbers, the opposite of what a bank sheet would use. Upload it to a credit card account in QuickBooks, and check the signs in the preview. The post on [importing credit card transactions into QuickBooks](/blog/import-credit-card-transactions-into-quickbooks) works through this. ### When only a few rows are left If the clean-up leaves you with five or six transactions, typing them is quicker than saving and uploading. The guide to [adding a transaction by hand in QuickBooks Online](/blog/how-to-manually-add-a-transaction-in-quickbooks-online) shows how.