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

Table Listing Supported Format for Fields

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.

FAQ: Can I Import Values from a File to a Lookup Field? (kintone FAQ, Japanese only)
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.

Note:
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

How to Handle If Errors Appear When You Try to 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. See "Actions to be Taken When You Failed to Bulk Register/Update Records" page for the solutions.