If Creating an App from an Excel or CSV File Fails

Article Number:040626

This article describes the actions you should take when you fail to create an app from an Excel or CSV file.
The actions differ depending on the timing at which an error occurs.

If an error appears when you select a file for import

Error example:
Screen

Error situation Solution
The following error message is displayed:
When you have selected Create from Excel:
Cannot recognize the contents of the uploaded file as .xlsx format. Confirm the content of the file. (GAIA_TD01)

When you have selected Create from CSV:
Cannot recognize the contents of the uploaded file as CSV format. Confirm the content of the file. (GAIA_TD01)
When you have selected Create from Excel:
  • The file content may not be recognized as .xlsx. Confirm the content of the file.
  • Check whether the Excel file is protected with a password, and if so, disable the protection.

When you have selected Create from CSV:
Ensure that the file contains comma-separated values. Note that you can import a file even if the file format is text or TSV.
The following error message is displayed:
The file size of "***" may exceed the limit allowed.
The size of the file to import exceeds 1 MB (for Excel) or 100 MB (for CSV). Make the data smaller and try to import it again. For information on importing Excel files larger than 1 MB, refer to What to do if your Excel file exceeds the 1 MB, 1,000 rows, and 500 columns limit.
The following error message is displayed:
When you have selected Create from Excel:
Cannot upload "***.xls." Please upload the file with .xlsx extension. In case you would like to create an App from a CSV file, click "Exit" to go back to the Marketplace screen, then click "Create from CSV" to upload the file.

When you have selected Create from CSV:
Cannot upload "***." Please upload the file with .csv extension. In case you would like to create an App from an Excel file, click "Exit" to go back to the kintone Marketplace screen, then click "Create from Excel" to upload the file.
When you have selected Create from Excel:
You cannot import Excel workbook files created using Excel 2003. Import a workbook file created using Excel 2007 or later versions (the file with an extension of ".xlsx").

When you have selected Create from CSV:
Import a file whose extension is ".csv", ".tsv", or ".txt".
The following error message is displayed:
The first row in the data range causes an error. Take the following actions. 1\. Ensure that the first row of the data range contains the column names (first row of your selection: Row 1 of the file). 2\. Ensure that the column names (first row of the data range) do neither contain blank cell nor cells whose values exceed the maximum length of characters allowed (128 characters or less). In case of Excel, also ensure that the file does not contain hidden cells nor merged cells.
Make sure that none of the cells in the first row of the table in the file have a value longer than 128 characters.

If an error appears when you select the data range to import (Only when importing an Excel file)

Error example:
Screen

Error situation Solution
The following error message is displayed:
The first row in the data range causes an error. Take the following actions. 1\. Ensure that the first row of the data range contains the column names (first row of your selection: Row 1 of the file). 2\. Ensure that the column names (first row of the data range) do neither contain blank cell nor cells whose values exceed the maximum length of characters allowed (128 characters or less). In case of Excel, also ensure that the file does not contain hidden cells nor merged cells.
  • Make sure that none of the cells in the first row of the designated range have a value longer than 128 characters.
  • A value of a hidden cell may be causing the error. Unhide hidden cells and check the values. 
  • Check that the first row of the imported range is not empty. Also, check that there are no empty cells in the upper right of the imported range.
The following error message is displayed:
Invalid range. "Top Left Cell" and "Bottom Right Cell" may be inverted.
Check whether the top left cell and the bottom right cell have been specified inversely.
The following error message is displayed:
Invalid value entered. To identify a cell, specify the column letter first, followed by the row number (e.g. A1).
All cell identifiers must be written in half-width alphanumeric characters.
The following error message is displayed:
The number of columns exceeds the limit of 500 that can be imported at a time. Reduce the number of columns.
Ensure that the imported data range contains 500 columns or less.
 The following error message is displayed:
The number of rows exceeds the limit of 1,000 that can be imported at a time. Reduce the number of rows. For details on how to import an Excel file with more then 1,000 rows, see the Help.
Ensure that the imported data range contains not more than 1,000 rows.
For information on importing a data range that contains over 1,000 rows, refer to What to do if your Excel file exceeds the 1 MB, 1,000 rows, and 500 columns limit.

If an error appears after the app is created

If the data import fails after an app is created, the error message "File import failed." appears. When you click Imported Files, the "Imported Files" screen is displayed, and you can check the details of the error on the screen.
Error example: Screen Arrow
Screen

The following table describes symptoms and solutions when data fails to be loaded from a file.

Error situation Solution
The following error message is displayed:
GAIA_IL17: The format of field "***" at row number *** of the file is invalid. In kintone, the supported formats for importing vary for each field type. Check the value of field "***" at row number *** in the file.
This error occurs when the data format of a value in row 100 or a subsequent row differs from that in the preceding rows of the file. Check and correct row 100 and subsequent rows for a value that is in a different format. For example, a row containing a text value in a field although other preceding rows contain numeric values in the field. Refer to Supported Formats for Adding/Updating Records.

However, the data has been imported to the app from the first row to just before the row number R.
The following error message is displayed:
GAIA_IL16: The value of field "***" at row number *** of the file is invalid. Please confirm the field conditions such as "Required field" or "Prohibit duplicate values", and modify the value of the file. If the field type is a Drop-down or a Radio Button, please confirm that the value matches one of the options included in the field settings.
This error occurs when the data type of a value in row 100 or a subsequent row differs from that in the preceding rows of the file. Check and correct row 100 and subsequent rows for a value of a different type. For example, a row contains a text value in a field although other preceding rows contain e-mail addresses in the field. Refer to Supported Formats for Adding/Updating Records.
The following error message is displayed:
GAIA_II05: Failed to import the file. Please reduce the data size in row number ***.
This error can occur only for CSV files. Reduce the length of a row or the number of columns.

However, the data has been imported to the app from the first row to just before the row number R.
The app name is truncated. The file name cannot be longer than 64 characters. Rename the Excel file. Or change the name of the created app on kintone.
Changing the Name and Icon of an App