Exporting an Aggregate Result to a File
Data aggregated using the chart feature can be exported in tabular format to a CSV file. Aggregation conditions and other settings applied to the chart displayed will also be applied to the aggregate data when it is exported.
Exporting an aggregate result to a CSV file
-
Display the aggregate result you want to export and click Export to CSV File from the Options icon at the upper right of the screen.
-
Configure the following items:
- Include header row
Select this check box if you want to export the item names of the table to the file. - Character Encoding
Select the character encoding of the file to which the result is to be exported.
If you plan to open the exported file in the Japanese version of Excel, select "Shift-JIS."
For details on which character encoding to use, see the following page:
How do I specify character encoding when exporting data to a file? - Delimiter
Select a delimiter used to separate fields.
- Include header row
-
Click Export.
Exporting pivot tables in Excel format
Pivot tables that are created in apps can be exported in Excel format.
Display the aggregate result you want to export and click Save as Excel File from the Options icon at the upper right of the screen.