Cloudera Docs

Downloading a visual as an Excel file

You can save data from a visual into an Excel (XLSX) file in Cloudera Data Visualization. The downloaded file includes both the data displayed in the visual and a separate sheet listing any defined parameters. The file name reflects the visual’s name and includes a timestamp showing when it was created.

This feature is available for all visual types. When you download a visual as an Excel file, Cloudera Data Visualization exports the visual’s underlying data in a structured format suitable for further analysis.

The downloaded Excel file:
  • Preserves display formatting, allowing you to sort, filter, and calculate data immediately, without additional cleanup
  • Exports numbers as numeric values with applied formatting (for example, currency or percentage), rather than as plain text
  • Safely handles string values that begin with = by exporting them as text to prevent unintended formula evaluation in Excel.
  • Includes column totals, if totals are enabled in the visual. To enable totals in the visual, see Showing column totals.
Before downloading a visual as an Excel file, ensure that the Enable "Download as CSV/Excel" by default option is turned on in the site settings. For instructions, see Visuals in Managing dashboard site settings.
  1. Click the icon in the top-right corner of the visual and select Download as... > Excel.

    A message appears: Generating the requested file and Cloudera Data Visualization exports the visual to an XLSX file.

  2. When the download is complete, open your browser’s default download folder and locate the generated Excel file.

    In this example, the generated file name, Table_Visual_20251026150859.xlsx includes the following components:

    • Table_Visual: Same as the visual name
    • 20251026: Date of download in YYYYMMDD format
    • 150859: Time of download in hhmmss format

    Totals appear in the table only if they are enabled, as described in Showing column totals. If the visual includes filters, you can view the Params sheet in the Excel file to see the parameter definitions that were applied when the visual was created.