List of Data Types That Can Be Imported or Exported

The permanent link has been copied.

Article Number:04056

This section describes the types of data that can be imported from or exported to a file.

Import/Export of Function Data

The permanent link has been copied.

The table below describes whether each data set can be imported/exported.

✔: Can be imported/exported
Blank cell: Cannot be imported/exported

Import/Export of Function Data
Data type	Import	Export
App Settings	✔ ^*1	✔ ^*1
App data	✔ ^*2	✔ ^*2
Space settings	✔ ^*1	✔ ^*1
Space data
People data
System settings

^*1: Creating a template from an app or space enables you to import or export the app or space settings in a file.
      Downloading App as Template
      Creating a Template from an App and Registering the Template in Kintone
      Creating a Template from a Space
      Some settings are not included in templates.
      Settings That Are Not Included in App Templates
      Data That Is Not Included in Space Templates
^*2: For details on app data to be imported or exported, see "Import/Export of App Data".

Import/Export of App Data

The permanent link has been copied.

Use a CSV file to import or export data. For details, refer to the following pages:

Steps to import data: Creating and Updating Records in Bulk
Steps to export data: Exporting Data to a File

The table below describes whether each data set can be imported/exported.

✔: Can be imported/exported
Blank cell: Cannot be imported/exported

Import/Export of Field Values
Field Type	Import	Export
Label
Text	✔ ^*1	✔
Rich text	✔	✔
Text area	✔	✔
Number	✔	✔
Calculated	^*1	✔
Radio Button	✔	✔
Check box	✔	✔
Multi-choice	✔	✔
Drop-down	✔	✔
Date	✔	✔
Time	✔	✔
Date and time	✔	✔
Attachment
Link	✔	✔
User selection	✔	✔
Department selection	✔	✔
Group selection	✔	✔
Related records
Lookup	✔ ^*2	✔
Record number		✔
User who created the record	✔ ^*3	✔
Created datetime for the record	✔ ^*3	✔
User who updated the record	✔ ^*3	✔
Updated Datetime for the record	✔ ^*3	✔

^*1: In the case of a Text field that you set automatic calculation for, or in the case of a Calculated field, the value will be re-calculated after the file import.

^*2: You can import data to a Lookup field only when the "Prohibit duplicate values" option is enabled for the Key field. Value for a field that is specified as "Field Mappings" will be updated using the value specified for the lookup field.

^*3: The data for Created by/Created datetime/Updated by/Updated datetime fields can be imported from a file only when you are trying to add new records to the app. To perform import action, you need to have permission to manage apps, as well as permission to import from files.

Import/Export of Information Other Than Field Values
Type	Import	Export
Category^*1	✔	✔
Status^*2		✔
Assignee^*2		✔
Comment
History

^*1: The category can be imported or exported only when the Category feature is enabled.
Categorizing Records

^*2: The status and assignee can be exported only when the Process Management feature is enabled.
Setting Process Management