Exporting an Aggregate Result to a File

Article Number:040467

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

  1. 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. Image

  2. 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.
  3. 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. Image