Export one widget as CSV
Download a widget’s data as a CSV file that opens in Excel: the table’s rows with their columns, or the chart’s categories with their values.
Before you start · for owners and managersThe “Export dashboards” permission + access to open the dashboard
- You need: The “Export dashboards” permission + access to open the dashboard
Steps
How it works
Table: its columns use the current field names, and each amount column is followed by a “(Currency)” column, so the amounts can still be added up.
Other widgets: columns for the key, the label, the series key, the series label, the value and the currency. A goal adds the remaining amount, the period end and the days left.
Activity: time, event, actor, unit, record, field, from and to.
The file is UTF-8, so Arabic opens correctly in Excel. Numbers are exact, with no rounding, and cells that could be read as a formula are protected with a mark.
Text, Embed and old widgets can’t be exported as CSV.
An instant file doesn’t take a place in the queue, and isn’t refused when the queue is busy.