If Creating an App from an Excel or CSV File Fails
The permanent link has been copied.
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
The permanent link has been copied.
Error example:
| 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:
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)
The permanent link has been copied.
Error example:
| 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. |
|
| 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 100 that can be imported at a time. Reduce the number of columns. |
Ensure that the imported data range contains not more than 100 columns. |
| 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
The permanent link has been copied.
When data import fails after an app is created, the error message "File import failed." is displayed.
Click Imported Files to view the details of the error on the "Imported Files" screen.
Error example:
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: Invalid formatting is found in the "***" field mapped column at row *** of the file. The supported formatting for each column differs depending on the field type to which the column is mapped. Check that the value specified in the "***" field mapped column at row *** of the file is formatted correctly. |
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. The field may have the "Required field" or "Prohibit duplicate values" options turned on. If the field type is a Drop-down or a Radio Button, the value may not match 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 ***. |
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 |