Example of CSV format

• The first row of the file must have the item name, which is used as the field name when setting the data editing flow. You cannot select a column as a field that does not have an item name in the first row.
• The next and subsequent rows of the file are considered as data rows. Each row is used as record data when the data editing flow is executed.
• Supported character encoding
  • Japanese (Shift-JIS)
  • English (Latin 1)
  • Chinese (GBK)
  • Unicode (UTF-8)
• Supported delimiter
  • Comma
  • Semicolon
  • Tab
  • Space

Reading Output

Run time Behavior

• When executing the data editing flow, the first row of the file must contain all the items you selected at the time of setting command. The read will fail if there are not enough items to identify the column to read the data from.

File formats that can be read at run time

File formats that fails to read at run time

• A blank row is automatically skipped when reading the file.

Content of file to be read

Reading result

Example of Excel's List Format

• The first row of the data range must have the item name, which is used as the field name when setting the data editing flow. You cannot select a column as a field that does not have item name in the first row.
• The next and subsequent rows of the data range are considered as data rows. Each row is used as record data when the data editing flow is executed.
• It is not necessary to start the data range from A1 cell of the sheet. You can change the data range in file input command.

Reading Output

Set Data Range

In Excel list format, click the Change the Data Range button on the setting tab of the file input command. This will display the Excel File Setting Dialog in which you can specify the data range of the sheet.

The settings and operations of the Excel File Setting Dialog are as follows.

Top left cell	Bottom right cell	Description
(Empty field)	(Empty field)	Reads the range from the top left cell "A1" to the cell where the value exists.
Enter any cell position (example: B2)	(Empty field)	Reads the range from the position set in "Top left cell (e.g. B2)" to the cell where the value exists
Enter any cell position (example: B2)	Enter any cell position (example: E6)	Reads the range from the position set in "Top left cell (e.g. B2)" to the position set in "Bottom right cell (eg E6)".

Run time behavior

The run time behavior is similar to the CSV format Run time Behavior.

The form format is similar to the record detail screen of the Kintone app, where cell positions are freely arranged for entering item names and values in an Excel sheet.

To read an Excel form format file, you can use the file input command to set the cell position, cell range, field name, and field type where the target data is stored as template information. For more information regarding method to set the template, refer to Set Template of Form Format.

Example of Excel's Form Format

• You can select a cell that contains a sheet value and read it as a field.
• You can select a cell range in which the item name and value of the sheet are entered and read it as a table.
• The data read from one sheet is processed as one record while executing the data editing flow.

Reading Output