Supported Data 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: ![]() |
Text area | |
Number | Enter numerical values. The following numerical values can be entered:
![]() |
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:
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:
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:
![]() |
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:
![]() |
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.
![]() |
Created by | Enter only one login name of a user. You cannot specify the following values and users.
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:
Example: ![]() |
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 "What to Do If You Failed to Bulk Add/Update Records" page for the solutions.