Downloading Visual Data to CSV Files

Arcadia Enterprise enables you to save the data used in visualizations as CSV files. The filename is the same as the name of the visual, and has a timestamp specifying the date and time when the file is created.

Before you begin to download a CSV file, you must first Enable CSV Download. Note that the site administrator can override this setting in the Enable "Download as CSV/Excel" by default in the Site Settings interface. See Downloading Maximum Number of Rows in CSV Files.

To save data used in a particular visualization, follow these steps while on the visualization you want to capture.

  1. In Visual Designer, click the (ellipsis) icon at the top of the interface.

  2. Click Download as..., and select CSV from the secondary menu.

    Selecting the (ellipsis) icon at the top of the interface, clicking Download as..., and then selecting CSV from the secondary menu.

  3. A Generating the requested file message appears.

  4. After the download is complete, open the default download folder on your computer. Arcadia Enterprisesaves the current sheet to a *.csv file.

    In our example, the generated file name, Table_Visual_20190207110756, has the following components:

    • Table_Visual

      Same name as the dashboard

    • 20190207

      Signifies the date the file is created, in YYYYMMDD format

    • 110756

      Signifies the time the file is created, in hhmmss format

    Note that Arcadia Enterprise renames sheets with names that contain characters not supported by the file system. For example, for the sheet Table/Visual, it generates the file as Table_Visual_xxxxxxxxxxxxxx.csv, replacing the forward-slash (ASCII #47) character with an underscore (ASCII #95) character.

    Displaying the visual as a *.csv file, file name same as the name of the visual, and the timestamp when the file is created.
Related content: