Skip to content
demuddler

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.

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.

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.

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.

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 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.

The column holds true or false values, and this cell holds another value. Destination types and values lists the accepted values.

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.

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.

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.

The file has no content, or only spaces and blank lines. A worksheet with no values gives the same message.

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 importer reads CSV, TSV and Excel files, not JSON. Save the data as CSV or .xlsx, then import it.

The importer recognised the format of the file but cannot read it. The message names the format. Save the file as CSV or .xlsx.

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.

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 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.

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.

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.

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 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.

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.

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.

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.

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.

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.

An unavailable rule did not run. It does not count as a pass.

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….

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.

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.

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.

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.