For exporting reports, you can choose between two output formats: “Single-record format” and “Table format”.
*Only available to KANNA Report and Export function subscribers.
Difference in Output Format
In the following figure, we will show you how to export the cells highlighted in green color on a report template called “Report” as an example.
Single-record format
Outputs all input data in one line for each report.
This is useful when you want to tabulate data by input items since each report is outputted on a single line.
In the header line, the first column is "Report title”, the second column is “Created at”, and the third and subsequent columns are the "cell number and input item name".
If the input item name is not specified, only the cell address will be displayed.
Table format
Outputs the input data of a selected range in a table format.
Since the data is tabulated as it is in the selected range in tabular format, it is useful when you want to tabulate data by column.
The header line contains "Report title” in the first column, the “Created at” in the second column, and the “column number (alphabetical)” in the third and subsequent columns.
Procedure for setting up a Table format
By default, all sheets are set in single-record format.
Below is an explanation of how to export in table format.
1. Click [CSV Output Settings] on the Export File Details screen.
(Click here for basic operations for exporting KANNA Report data)
The output format can be changed to a table format from [CSV Export Settings] on the right side of the screen.
2. Click [Table Format] in the export format.
Please select “Table format” since “Single-record format” is selected by default.
3. Drag and drop the area you want to output
After selecting “Table format,” specify the range you want to export. When a range is selected, the values of the selected range will be displayed in the [Export Range] box at the top. To redo the range selection, click the [Reset] button or click directly on the selected range (highlighted in blue).
4. Edit additional information (optional)
In addition to the output range, you can optionally add any data that you want to include in all rows as additional information.
To select additional information, press the "Edit" button under "Additional Information" after selecting the range in table format.
5. Register additional information (optional)
Select the input items you wish to add. Selected items will turn purple.
Once you have finished selecting, press the "Completed" button.
6. Once the settings are complete, click "Save" to finish the configuration.
The output format can be set for each sheet. After completing the settings for all sheets, click "Save" to finish the CSV output configuration.
7. Click "CSV Download"
You can output the data by clicking "CSV Download." (For basic operations on exporting report data, click here.)