Supported Formats for Each Field Type

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

Supported Format for Each Field

Field Type Supported Format
Text Enter the values.

Example:
Image
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:
Image
Rich text Enter values in HTML format.

Example:
Image
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:
Image
Multi-choice
Radio Button Enter the options.

Example:
Image
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:
Image
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:
Image
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:
Image
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:
Image
Link to (Telephone number) Enter a telephone number.

Example:
Image
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:
Image
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:
Image Image
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:
Image
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:
Image
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.
Image
Configure the Customer ID field of the Customer Database app as follows:
Image

Create a file to be imported to the Sales & Leads app as follows:
Image
* ID such as "ID123" is a value in the referred field.

Refer to Can I Import Values from a File to 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:
Image
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:
Image
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.
Image
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:
Image
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:
Image
Updated datetime

When Errors Appear and Cannot Import Files

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 "Actions to be Taken When You Failed to Bulk Add/Update Records" page for the solutions.