Import messages
Find the cause of an importer message and the next step. Covers file reading, validation, licence checks and exports.
Search this page for the message on your screen. To change the text of a message, see Messages.
A message on a cell has one of three categories:
- A parse problem means that the text does not fit the type of the column. The importer keeps the text, and you can edit the cell.
- A rule problem means that the importer read the value, but the value fails a rule of the schema.
- A shape problem means that the value passes every rule, but it does not look like the rest of its column. An example is a badly formed address in a column of email addresses.
Each kind of problem has this effect on the import:
| Problem | Effect |
|---|---|
| A value fails a rule | The row stays, with a mark. The person can exclude it. |
| A required field has no column | The person cannot leave Match columns until a column matches. |
| A selected value does not convert to its type | The delivery or the download stops. |
On a cell
Section titled “On a cell”The Problems tab names each problem of a column with these messages. The
tooltip of a cell gives a short form of the same problem, such as
not an integer. For a row with missing or extra cells, the tooltip gives the
number of values in the row and the number that the header expects.
Not a whole number
Section titled “Not a whole number”The column holds whole numbers, and this cell holds something that is not a number. If the column type is wrong, choose Type in the column menu and read the column as text.
The leading zero is lost. Read the column as text
Section titled “The leading zero is lost. Read the column as text”The column holds whole numbers, and this cell holds a code with a zero in front,
such as 02150. A number drops the zero, so the cell is empty. Choose Type
in the column menu and read the column as text. Text keeps every zero.
A different currency from the rest of the column. Read the column as text
Section titled “A different currency from the rest of the column. Read the column as text”The column holds amounts in one currency, and this cell has another currency
sign, such as €12 in a column of dollars. The importer cannot add these
amounts, so the cell is empty. Read the column as text, or put each currency in
its own column.
Not a number
Section titled “Not a number”The column holds numbers, and this cell is not a number in the format of the
column. For example, 1.234,56 gives this message in a column that uses a
decimal point. Before you edit cells, set Decimal comma in the column menu.
One change fixes every row.
Not a readable date
Section titled “Not a readable date”The column holds dates, and this value is not a date, or it does not use the date order of the column. First set Date order in the column menu. One change fixes every row.
The time cannot be read. The date is kept
Section titled “The time cannot be read. The date is kept”The column holds dates with times. The importer read the date of this value but not its time, so the value has the time midnight. The message keeps the original text. Correct the time in the cell.
Not a yes or no value
Section titled “Not a yes or no value”The column holds true or false values, and this cell holds another value. Destination types and values lists the accepted values.
Row is missing cells
Section titled “Row is missing cells”The row has fewer values than the header has columns. Each missing cell is empty and has this mark. Look at the separator and the quotation marks in the source row.
Row has extra cells
Section titled “Row has extra cells”The row has more values than the header. The importer does not import the extra values. The message names them. Look for a separator inside an unquoted value.
Some characters cannot be read and show as �. Choose another encoding
Section titled “Some characters cannot be read and show as �. Choose another encoding”The value holds the replacement character �. Some of its bytes are not valid
in the encoding that the importer used, or the file already held �. The
importer keeps the value. Set the encoding in File settings. See
Accented characters look wrong.
cannot be read
Section titled “cannot be read”The cell did not parse, and the file has more than 100,000 failures. After that number, the importer still marks each failure, but it does not keep the original text. You can edit the cell.
On the whole file
Section titled “On the whole file”file is empty or contains no data
Section titled “file is empty or contains no data”The file has no content, or only spaces and blank lines. A worksheet with no values gives the same message.
cannot identify any columns
Section titled “cannot identify any columns”This message is for Excel files only. The sheet has rows but no columns. Save the sheet again in your spreadsheet app, or save it as CSV.
The file expands to more than … which the importer cannot open
Section titled “The file expands to more than … which the importer cannot open”This message is for a gzip-compressed file only. A gzip-compressed CSV or TSV file can unpack to at most 4 GiB. A gzip-compressed Excel file can unpack to at most 512 MiB. Extract the file first and open the extracted file, or save the sheet as CSV.
a quoted value starting on line N is longer than … bytes and never closes
Section titled “a quoted value starting on line N is longer than … bytes and never closes”A quotation mark on that line does not close, so the importer cannot find the end of the value. Close the quotation mark in the file and open it again.
this workbook has a password, or it is another kind of Office file
Section titled “this workbook has a password, or it is another kind of Office file”The importer cannot open a workbook that needs a password, or an Office file that holds no workbook, such as a Word document. Save a copy of the sheet in your spreadsheet app, then import the copy:
- Excel: select File, then Save As, and choose Excel Workbook (.xlsx). To remove a password, select File, Info, Protect Workbook, then Encrypt with Password, and delete the password.
- LibreOffice Calc: select File, then Save As, choose Excel 2007-365 (.xlsx), and clear Save with password.
- Numbers: select File, Export To, then Excel.
CSV works too, but it keeps only one sheet.
the file is JSON
Section titled “the file is JSON”The importer reads CSV, TSV and Excel files, not JSON. Save the data as CSV or
.xlsx, then import it.
unsupported format
Section titled “unsupported format”The importer recognised the format of the file but cannot read it. The message
names the format. Save the file as CSV or .xlsx.
On an export
Section titled “On an export”this schema has N columns and a worksheet holds M
Section titled “this schema has N columns and a worksheet holds M”This message is for Excel downloads only. Your schema has more columns than a worksheet can hold. Download CSV. It has no column limit.
this export has more than N rows, which is all a worksheet can hold
Section titled “this export has more than N rows, which is all a worksheet can hold”This message is for Excel downloads only. Download CSV.
cannot write the workbook
Section titled “cannot write the workbook”The importer did not build the workbook. If the message names the limit of 32,767 characters, a cell holds more text than Excel allows. The importer counts most emoji as two characters, as Excel stores them. Shorten the value, or download CSV. For another cause, the message names it.
cannot export row N: a value cannot be converted to the destination type
Section titled “cannot export row N: a value cannot be converted to the destination type”A selected value does not fit the type of its field, so the export stops. The importer makes no file. Correct the value, exclude the row, or change the type of the field.
File warnings
Section titled “File warnings”File warnings show at the top of the Problems tab. Read the file warnings tells you how to show the affected rows and how to dismiss a warning.
cells contain formulas
Section titled “cells contain formulas”The importer uses the last result of each formula that the Excel file stored. That result can be out of date. See Formula results can be out of date.
A quotation mark on line N is never closed
Section titled “A quotation mark on line N is never closed”This warning is for CSV only. A value starts with a quotation mark that does not close. The importer reads the rest of the file as that one value, so the rows after it are missing. The warning names the line. Close the quotation mark in the file and open it again.
sheets cannot be read
Section titled “sheets cannot be read”This warning is for Excel files only. The importer cannot read these sheets, so it opened the next sheet that it can read. Choose another sheet in the file settings, or save the file again in your spreadsheet app.
The first N rows look like one header
Section titled “The first N rows look like one header”A row of categories, such as Billing and Shipping, sits above the field
names. The importer does not join the rows itself, because that changes which
row is the first data row. To join them, set Header rows in the file
settings to the number in the warning. A blank category takes the category on
its left. So Billing over Email and Name gives Billing · Email and
Billing · Name.
The first N lines are a title above the table
Section titled “The first N lines are a title above the table”A report name, a date or a blank line sits above the header, so the importer skipped those lines. To read them as rows, set Rows to skip above the header to 0 in the file settings.
rows look like totals
Section titled “rows look like totals”Rows such as Total or Grand Total stay data, so a sum of the column counts
them again. To leave them out, select Show these rows, then choose
Leave out of the import in the row menu of each.
rows are hidden in Excel
Section titled “rows are hidden in Excel”This warning is for .xlsx files only. Rows that Excel hides stay data. To see
them, select Show these rows. To leave one out, choose Leave out of the
import in its row menu.
columns hold amounts in more than one currency
Section titled “columns hold amounts in more than one currency”The amounts in these columns have different currency signs, such as $ and
€. The columns stay text and keep the signs. Put each currency in its own
column. To remove the signs and read the amounts as numbers, choose a number
type in the column menu.
merged ranges gave their value to every cell
Section titled “merged ranges gave their value to every cell”This warning is for Excel files only. A merged range shows one value across several cells, so the importer copies that value into each cell of the range. The first row that the importer reads never gets a copy, because it can be the header. To keep each value in its first cell only, turn off Merged cells fill every cell they cover in the file settings.
has columns that … does not have
Section titled “has columns that … does not have”You opened several files together. A later file has columns that the first file does not have, so the importer does not import their values. Add these columns to the first file, or import the later file on its own.
does not have these columns
Section titled “does not have these columns”You opened several files together. A later file does not have some columns of the first file, so those cells are empty in its rows.
values in … do not fit their column type
Section titled “values in … do not fit their column type”The message names the file. Its values do not fit the type that the first file set for their column, so they are empty. Correct them in the table or in the file.
rows have too few or too many values
Section titled “rows have too few or too many values”Missing values are empty, and the importer does not import extra values. To see the rows, select Show these rows. See Row is missing cells and Row has extra cells.
values do not fit their column type
Section titled “values do not fit their column type”These values are empty, and the table marks them. To see them, select Show these rows. Correct them, or choose another type for the column. The messages on each cell are under On a cell.
Messages about a rule
Section titled “Messages about a rule”An unavailable rule did not run. It does not count as a pass.
cannot be checked against them
Section titled “cannot be checked against them”A minimum or maximum rule is on a column that holds values that are not numbers. The rule did not run on those values. Look at the column type and the rule.
the page did not register this validation hook
Section titled “the page did not register this validation hook”A custom rule names a hook that your page did not register, so the rule did
not run. See When a rule cannot run.
The importer removed the rules of these columns
Section titled “The importer removed the rules of these columns”This message is for a schema that the importer made from the file. The importer read the file again with other settings, or you undid a split, and some columns are gone. The importer removed the rules that use them. The message names the columns that held those rules. The rules of every other column stay. Look at the settings in File settings, or set the rules again in Rules….
Messages about suggested repairs
Section titled “Messages about suggested repairs”This repair exceeds the preview memory budget. No values were changed.
Section titled “This repair exceeds the preview memory budget. No values were changed.”The preview needs more memory than its limit. The values do not change. Split the source file and fix each part.
This repair has not passed its checks.
Section titled “This repair has not passed its checks.”The full preview must finish, change at least one value, and have no new conflicts and no unavailable checks before the repair can apply. Look at the reported problems and your schema rules.
The data or schema changed. Review the repair again.
Section titled “The data or schema changed. Review the repair again.”An edit, a mapping change or a schema change made the preview out of date. Start a new preview before you apply the repair.
Messages about the account
Section titled “Messages about the account”These messages show when you sign in to your Demuddler account.
That code is wrong or expired. Ask for a new one.
Section titled “That code is wrong or expired. Ask for a new one.”A code works once, for 10 minutes, and only in the browser that asked for it. Too many wrong guesses end it. Ask for a new code in the same browser.
The email could not be sent. Try again later.
Section titled “The email could not be sent. Try again later.”The mail service refused the request or did not answer. Ask for a new code. A new request replaces the previous code of this browser.
Too many codes requested. Try again later.
Section titled “Too many codes requested. Try again later.”An address can get only a few codes in a short time. If you have a passkey, sign in with it instead.
The passkey did not pass the check. Try again.
Section titled “The passkey did not pass the check. Try again.”The passkey check failed or took longer than 5 minutes. Start the sign-in again.
The passkey check was cancelled or took too long. Try again.
Section titled “The passkey check was cancelled or took too long. Try again.”You closed the passkey prompt of your browser, or it ended before you unlocked the passkey. Start again.
This device already has a passkey for the account.
Section titled “This device already has a passkey for the account.”Each device keeps one passkey for an account. Use it to sign in, or add a passkey on another device.
This browser cannot use a passkey here. Use an email code instead.
Section titled “This browser cannot use a passkey here. Use an email code instead.”The browser has no passkey support, or it refused the request. Sign in with an email code.
You opened a checkout in the last hour. It can still become a payment, so try again in an hour.
Section titled “You opened a checkout in the last hour. It can still become a payment, so try again in an hour.”A checkout can still charge for up to an hour after you open it, so you cannot delete the account in that time. Wait an hour, then delete the account.
Confirm that it is you first.
Section titled “Confirm that it is you first.”A change to your passkeys, sign-in email, licence key or domains, the billing portal, deletion, and signing out your other browsers each need a passkey check in the last 5 minutes. On an account with no passkey, a new email code does the same.