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 that were not imported.
You can also download a CSV file with the rows that were not imported, along with the reasons they were not imported.

After checking the error details and correcting the data in the CSV file, you can use the file to import the data sets that were not 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.

If you select the Use the new file import method option, you can select Stop importing file data further if an error is detected (Optional).

When this checkbox is selected, no further rows of data will be imported if data that cannot be imported is found during the file import process.

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.