The Kintone development team is currently working on an updated method for importing data from Excel or CSV files into existing apps.
The new method allows Kintone to continue importing files even if they include some data sets that result in errors. (Data sets that contain errors are skipped, and only the data sets that do not contain errors are imported to the relevant app.)
With the method that has been used until now (the "classic" method), the import process stops if a single instance of non-importable data is encountered. In this case, no data from the file is imported.

You can try out the new file import method before it is officially released. To do so, go to the "Update Options" screen and enable New File Import Method under New Features in Development.

For more details about the changes made to the file import method and information on how to try out the new method, see below.

With the classic file import method:
If a single instance of data that cannot be imported is found in a file, the import process stops and none of the file's data will be imported.

With the new file import method:
If a file includes data sets that cannot be imported, those data sets will be skipped over and the import process will continue. Only data that can be imported will be imported to the relevant app.

With the classic file import method:
The "Imported Files" screen shows the details of the first error that was encountered during the file import process.

With the new file import method:
The "Imported Files" screen shows the number of rows skipped due to errors.
Additionally, all of the data sets that resulted in an error, along with the error details, can be downloaded in CSV format. After checking the error details and correcting the data in the CSV file, you can use the file to import only the data sets that could not be imported during the import session.

With the classic file import method:
A "Lookup" field cannot be specified as an import target if Prohibit duplicate values is disabled for the Key Field set in the "Lookup" field's settings.

With the new file import method:
A "Lookup" field can be specified as an import target even if Prohibit duplicate values is disabled for the Key Field set in the "Lookup" field's settings.

To try out this feature before its official release, go to the "Update Options" screen and select the Enable this feature: New File Import Method checkbox under New Features in Development.