Each field type has its own limitations for the entry format. Refer to the table below or the Field Entry Limits page to enter values in each field.

Sample Import Files:
You can download a sample import file from the following link:

Sample CSV file for all field types
sample_all_fields_app.csv

Field Type	Supported Format
Text	Enter the values. Example:
Text area
Number	Enter numerical values. The following numerical values can be entered: Integer Decimal Negative number Example: -1.23 Exponential number Example: 500,000 can be entered as 5.00E+05. In CSV files, the following symbols cannot be used. ',' (thousands separator) Currency symbols such as '￥' (Yen sign) Example:
Rich text	Enter values in HTML format. Example:
Check box	Use a column for each option, and leave each cell blank or filled in with '1'. Enter '1' to select the option, or leave it blank to clear the option. In the first row, enter the field name in the following format: Field Name[Option name] Example: Checkbox1[Option1] Example:
Multi-choice
Radio button	Enter the options. Example:
Drop-down
Date	For Excel workbook files, all date formats that are identified by Excel can be used for entries. For CSV files, enter the date in one of the following formats: YYYY-MM-DD (Example: 2014-12-20) YYYY/MM/DD (Example: 2014/12/20) YYYYMMDD (Example: 20141220) YY/MM/DD (Example: 14/12/20) MM/DD/YYYY (Example: 12/20/2014) MM/DD/YY (Example: 12/20/14) DD/MM/YYYY (Example: 20/12/2014) DD/MM/YY (Example: 20/12/14) For all formats but "YYYYMMDD", any month or day that is represented in a single digit (between 1 and 9) can be entered in either one- or two-digit format. Example: The 8th can be entered as "8" or "08". If the value for day is not specified, it becomes the 1st. Example: "2014/01" is converted into "2014/01/01". If the value for month and day is not specified, it becomes January the 1st. Example: "2014" is converted into "2014/01/01". Example:
Time	For Excel workbook files, all time formats that are identified by Excel can be used for entries. For CSV files, enter the date in one of the following formats: HH:MM AM/PM (Example: 11:20 PM) HH:MM (Example: 23:20) For hour or minute that is represented in a digit (between 1 and 9), either one- or two-digit format is acceptable for the entry. Example: 8 o'clock can be entered as "8" or "08". The part that indicates seconds is ignored. Example: "11:01:25" is converted into"11:01". If the value for minute is not specified, it becomes "0". Example: "11" is converted into "11:00". Example:
Date and time	For Excel workbook files, all time formats that are identified by Excel can be used for entries. For CSV files, the date is followed by the time, separated by a space. Example: 2014/01/11 11:01 The part that indicates the time in seconds cannot be specified. If the value for time is not specified, it becomes 00:00. Example: "2014/01/11" is converted into "2014/01/11 00:00". The date and time can also be entered in ISO8601 format. Example: 2014-01-11T12:00Z If a time zone is specified to date and time, a time zone you specify when you import the CSV file to an app will be ignored. Example:
Link to (URL)	Enter an address beginning with "http://" or "https://". The following characters can be used: Alphabetical characters (uppercase or lowercase) Arabic numbers The following symbols -_.!~*'():@&=+$,;?/#% Some symbols may not be used depending on the part of an address. Example:
Link to (Telephone number)	Enter a telephone number. Example:
Link to (E-mail address)	Enter an E-mail address in the following format: (local part)@(domain). For the local part, the following characters can be used: Alphabetical characters (uppercase or lowercase) Arabic numbers The following symbols .!#$'%&*+/=?^_-`{}|~ For the domain part, the following characters can be used: Alphabetical characters (uppercase or lowercase) Arabic numbers The following symbols .- Example:
User selection	Enter user login names for selection. When you want to select multiple users, enter user login names that belong to those users in one cell with line breaks. When using a text editor to edit the CSV file, set a value between commas to a list of user login names with line breaks. Example:
Department selection	Enter department codes for department selection. When you want multiple departments to be an option, enter the department codes all in one cell with line breaks. Example:
Group selection	Enter group codes for group selection. When you want multiple groups to be an option, enter the group codes all in one cell with line breaks. Example:
Lookup	Enter values contained in the key field. Note that the key field must be configured to accept only unique values. For example, as shown below, the Sales & Leads app retrieves customer information from the Customer Database app by using the Customer ID field as the key. In this case, you specify the Customer ID values in the import file. If the Customer ID field contains duplicate values, the system cannot identify a value to retrieve. You must configure the Customer ID field of the Customer Database app so that only unique values are accepted. Example: The Sales & Leads app uses a Lookup field to retrieve information from the Customer Database app. Configure the Customer ID field of the Customer Database app as follows: Create a file to be imported to the Sales & Leads app as follows: * ID such as "ID123" is a value in the referred field. Reference: Is it possible to import values in a file into a Lookup field?
Record number	Enter the corresponding record numbers to update records. Even if the app has an app code, enter only the record number. Example:
Category	Enter the options. When you want multiple categories to be an option, enter the categories all in a cell with line breaks. Notes: Category values can be imported only when the Category feature is enabled. Example:
Table	When you want to update/add a table, enter the contents of that table. If you specify the Key to Bulk Update when you import a file, the already created table is updated. In the import file, set the first column to an asterisk (*) or leave it blank. A table is composed of a row with an asterisk (*) and its subsequent rows without an asterisk (*). Shown below is an example where a table has Date, Transportation, and Amount fields. In this example, record number is specified as the Key to Bulk Update. When the first column of the row is an asterisk (*), and the record number is empty: Record containing a table is newly created as another record. When the first column of the row is an asterisk (*), and the record number exists: Table in the same record is updated. When the first column of the row and the record number are empty: Row is added to the table in the same record.
Created by	Enter only one login name of a user. You cannot specify the following values and users. A value other than login name Multiple users A user who do not exist A user who has been suspended or deleted A user who is not using Kintone A user in the department for which you do not have view permission. A guest who are not the member of the space if the app belongs to a guest space Notes: You can import data into the Created by/Updated by fields only when you add new records to the app. You cannot update values for existing records with the values imported from a file. Example:
Updated by
Created Datetime	For Excel workbook files, all time formats that are identified by Excel can be used for entries. For CSV files, the date is followed by the time, separated by a space. Example: 2021/03/12 11:01 The part that indicates the time in seconds cannot be specified. If the value for time is not specified, it becomes 00:00. Example: "2021/03/12" is converted into "2021/03/12 00:00". The date and time can also be entered in ISO8601 format. Example: 2021-03-12T12:00Z If a time zone is specified to date and time, a time zone you specify when you import the CSV file to an app will be ignored. Notes: You can import data into the Created datetime/Updated datetime fields only when you add new records to the app. You cannot update values for existing records with the values imported from a file. Make sure that the date and time included in the file is earlier than that of the import from file action. Example:
Updated datetime

If you import a file with blank cells for fields which are configured as required (values must be entered), errors appear and you cannot import the file.
There are many other factors that can cause errors. Refer to "What to Do If You Failed to Bulk Add/Update Records" page for the solutions.