Exporting DataSets
You can export DataSets from Domo as Microsoft Excel or CSV files. You do this in the Details view for the DataSet in the Data Center.
Notes:
- Excel supports only up to one million rows when exporting.
- DataFusions cannot currently be exported.
Important: By default, Domo disables any formulas in Excel files before they are exported (as these formulas could contain malicious code). If you are an Admin user or have a custom role with the "Manage All Company Settings" privilege enabled, you can re-enable Excel formulas when exporting by doing into Admin Settings > Security > Exporting data and unchecking the box reading "Disable Excel formulas." However, it is strongly recommended that you do not uncheck this box.
Video - Exporting a DataSet
To export a DataSet as an Excel or CSV file,
-
Click Data in the toolbar at the top of the screen.
The Data Center opens, with the Data Warehouse tab opened by default. -
Click the
icon on the left side of the screen to open the DataSets tab.
-
Locate and click the DataSet you want to export.
The Details view for the DataSet opens. -
Click the ellipses icon
in the top right-hand corner of the screen, then select Export data.
-
Select either Excel or CSV.
The DataSet is downloaded to your machine as an Excel or CSV file.