CSV/XLS Data Export

ThingsBoard allows you to export data from any applicable widget directly to CSV, XLS, or XLSX format. The export downloads immediately to your browser — no background jobs or separate retrieval steps are required.

The exported data reflects the current time window of the widget. Changing the dashboard or widget time window before exporting changes the date range and volume of the exported file.

To export widget data, a user must have the Dashboard export permission. Without it, the export options are not visible in widget menus.

See Role-based access control for permission configuration.

1. Open the dashboard containing the widget you want to export.
2. Hover over the widget to reveal the widget toolbar in the top-right corner.
3. Click the Export widget data icon (download arrow).
4. Choose the export format from the dropdown:
   • Export data to CSV…
   • Export data to XLS…
   • Export data to XLSX…
5. The file downloads immediately to your browser.

The file is named after the widget (e.g. time_series_chart_temperature_power_history.csv) and contains one row per datapoint with the following columns:

Column	Description
Timestamp	Date and time of the datapoint (e.g. 2026-03-29 21:12:29).
Entity Name	Name of the device or entity the datapoint belongs to.
<data key>	One column per configured data key (e.g. Temperature, Power). Cells are empty where an entity has no value for that key at that timestamp.

Example:

Timestamp	Entity Name	Power	Temperature
2026-03-29 21:12:29	IT Energy meter	24.1
2026-03-29 21:12:29	Smart sensor		14.1
2026-03-29 21:12:39	IT Energy meter	24.7
2026-03-29 21:12:39	Smart sensor		13.9

Columns in the export correspond to the data keys configured in the widget datasource. To control which keys are included, adjust the widget’s datasource configuration.

Format	Extension	Best for
CSV	.csv	Universal import into any tool; plain text, smallest file size.
XLS	.xls	Excel 97–2003 compatibility.
XLSX	.xlsx	Modern Excel format; recommended for large datasets.