QuickBooks CSV import: "#REF!, #NAME?, #N/A or #VALUE!" errors
Intuit's own help center states the rule for every spreadsheet you import into QuickBooks Online: “The spreadsheet doesn't have any formulas, charts, or blank rows,” and “The spreadsheet doesn't have any errors, such as #REF!, #NAME?, #N/A or #VALUE!.” Three different things a spreadsheet can carry, one documented refusal, and — for a bank-transaction upload specifically — QuickBooks treats a formula as a hard rejection rather than a warning.
Built for bookkeepers, accountants and small-business owners preparing a bank, invoice or journal file for Xero or QuickBooks Online.
Read from Intuit's own help centerImport customers or vendors from email contacts to QuickBooks Online — quickbooks.intuit.com, updated 2 September 2026 — read 7 September 2026
What this error means
QuickBooks Online's spreadsheet importer reads a CSV or Excel file cell by cell before it reads it as accounting data. Three shapes stop it outright: a cell that still holds a formula instead of the value the formula produced, a row with nothing in any column, and a cell that shows a broken-formula token such as #REF! (a reference to a cell that no longer exists), #NAME? (a name Excel does not recognise), #N/A, or #VALUE!. QuickBooks documents all three as reasons the import fails, not merely reasons it looks untidy.
What causes it, and what our engine actually checks
Accounting Import Check runs three separate rules over every cell in your file, matching this one documented QuickBooks requirement: spreadsheetError looks for the broken-formula tokens QuickBooks names (plus five more it does not — #DIV/0!, #NULL!, #NUM!, #SPILL! and #CALC!, which the same importer also rejects), formulaCell looks for any cell whose text still starts with “=”, and blankRow looks for a row every parser reports the same way QuickBooks does. Run against a five-row sample file built to exercise all three, the engine reported exactly what QuickBooks' own documentation predicts.
What the engine found in a sample file
Row 2’s Description cell held "#REF!" — a spreadsheet error, flagged as spreadsheetError and rated a blocker for QuickBooks Online. Row 3’s Description cell held "=SUM(B1:B2)" — a live formula, flagged as formulaCell and, for a QuickBooks bank-transaction upload specifically, also rated a blocker rather than a warning, because Intuit names formulas as a cause of import failure outright. Row 4 was entirely empty, flagged as blankRow and, for the same reason, also rated a blocker rather than a notice. The file’s overall verdict came back “not ready.”
spreadsheetErrorBlocker2“#REF!” → —
formulaCellBlocker3“=SUM(B1:B2)” → “SUM(B1:B2)”
blankRowBlocker4Blocker stops the import outright. Warning usually gets through but is worth checking before you trust the numbers. Notice is informational — safe to leave, safe to clear.
Reproduced from a sample file — read September 7, 2026.
Check your own file for this
Drop the file you were about to import below. It is read in this browser tab, the same engine runs the same check, and you will see immediately whether this exact problem is in it.
CSV, TSV or Excel, up to 20 MB
How to fix it by hand
Open the file in a spreadsheet program, not a text editor — formula and error tokens are easy to miss in raw CSV. Select every column and use "Paste Special → Values Only" over itself to turn every formula into the plain number or text it produced. Search for #REF!, #NAME?, #N/A and #VALUE! (Excel’s Find & Replace, or a filter on each column) and replace each one with the correct value — there usually is no way to recover what a broken reference meant, so this often means retyping the cell from the original statement. Delete any row that is completely empty rather than leaving it as a spacer.
Frequently asked questions
- Why does QuickBooks Online reject a CSV with #REF! or a formula in it?
- Intuit’s own help center states it directly: "The spreadsheet doesn’t have any formulas, charts, or blank rows" and "doesn’t have any errors, such as #REF!, #NAME?, #N/A or #VALUE!." The importer reads the raw cell text, not the number a formula would show on screen, so a live formula or a broken-reference token is what QuickBooks actually receives.
- Is a formula cell always a blocker in QuickBooks Online?
- For a bank-transaction upload specifically, yes — Accounting Import Check rates formulaCell a blocker for QuickBooks because Intuit names formulas as a cause of import failure outright, not merely as untidy data. Xero is more tolerant of the same cell, which is exactly why the check runs per target rather than once for every accounting system.
- Can Accounting Import Check fix a #REF! error automatically?
- It can clear the cell so the gap is visible instead of hidden, and every clear is listed with its row and column before you apply it — but it cannot invent the value a broken reference once pointed to. That number only exists in your original statement.
- Does QuickBooks reject any spreadsheet error besides #REF! and #NAME??
- Yes — Accounting Import Check’s spreadsheetError rule also catches #N/A, #VALUE!, #DIV/0!, #NULL!, #NUM!, #SPILL! and #CALC!, the full set a broken formula can leave behind, not only the two Intuit’s help article names as examples.
What Accounting Import Check does with this file
Upload a file carrying this problem into Accounting Import Check and it lists every #REF!/#NAME?/#N/A/#VALUE! cell, every formula cell and every blank row by row number before you import anything. The spreadsheet-error and formula findings both offer a one-click fix: spreadsheetError clears the broken cell so the gap is visible instead of hidden, and formulaCell keeps the text the formula last produced. Blank rows can be removed with the same one-click action. Every fix is listed cell by cell, before and after, and nothing is written until you choose to apply it.
The file you'd check is read in your browser tab — it is never uploaded anywhere.
What it cannot do here
Clearing a #REF! or #NAME? cell tells you where the gap is; it cannot tell you what value belonged there — that answer only exists in your original bank or accounting statement, and only you can put it back. The tool also cannot open the source spreadsheet formula for you to see what it once calculated; it only sees the text QuickBooks would have seen.