Creating App from CSV File
You can create a new app by importing a CSV file. In this way, you can create an app and import the file data into the app at the same time.
Overview of the steps to create an app from a CSV file
Step 1. Prepare a CSV file for import.
Step 2. Format the data in the CSV file so that the data can be imported into Kintone. Then, save the file.
Step 3. Follow the instructions on the wizard to import the file.
Details of the steps to create an app from a CSV file
Format the data in the CSV file so that the data can be imported into Kintone. Then, save the file on your PC.
Reference: Points to consider when formatting data in a CSV file
On the Kintone Portal, click the Create App icon in the Apps section.
Click Create from CSV.
Select the check boxes to confirm the check points, and then click Continue to the Upload screen.
Click Browse and select a file to import.
Check that the content of the file you are importing is correctly displayed in the Preview.
If characters in the file are garbled, select a different option from the Character Encoding drop-down list.
If the file is not separated into columns correctly, select a different option from the Delimiter drop-down list.
Check that auto-suggested field types are correct.
Appropriate field types are automatically selected for each item based on the data in the CSV file. Generally, you do not have to change the field types.
If there are some items you do not want to import into the app, select (Skip this row) for the items.
Click Convert on the bottom right side of the screen.
When the import completes, check the created app.
You can change the app name, icon, field positions, and other app settings.
If the app creation fails, refer to If Creating an App from an Excel or CSV File Fails, which explains the actions you should take when an error occurs.
Points to consider when formatting data in a CSV file
- An app can be created from a file that is not more than 100 MB in file size and has not more than 100 columns nor 100,000 rows.
If the file size exceeds 100 MB or if the file contains more than 100,000 rows, consider splitting the file into several files. After using one file to create an app, you can import the remaining data in additional files using the Import from File feature.
Importing Record Data from a File into an App
- If the file contains any characters other than Japanese or alphanumeric characters, specify "UTF-8" for the character encoding and then save the file.
When importing numeric values
The following symbols cannot be used.
- ',' (thousands separator)
- '￥' (Yen sign) and other currency symbols
When importing date and time data
In a CSV file, specify year, month, day, and time in any of the following formats:
- YYYY-MM-DD (Example: 2014-12-20)
- YYYY/MM/DD (Example: 2014/12/20)
- 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)
- HH:MM AM/PM (Example: 11:20 PM)
- HH:MM (Example: 23:20)
Single-digit months, days, and time can be entered in either the single- or double-digit format.
For example, you can enter either "8" or "08" to indicate 8.
Example of CSV file data
Field name 2023/8/8 11:02 PM 2023/08/08 23:02 PM 2023/8/8 23:2
When importing names, department names, or group names
The data can be imported into any of the following field types.
- "Text" field
- Fields with options ("Radio button" or "Drop-down" field)
- "User selection" field (Field for selecting one or more Kintone users)
- "Department selection" field (Field for selecting one or more departments)
- "Group selection" field (Field for selecting one or more groups)
When importing values into a "User selection," "Department selection," or "Group selection" field
Enter one of the following character strings:
- "User selection" field: Login name
- "Department selection" field: Department code
- "Group selection" field: Group code
If you want multiple users, departments, or groups to be selected in a field, separate the values using line breaks.
Example of CSV file data
Name "noboru_sato misaki_kato takuya_suzuki"