How Do You Download Data from a Tableau Dashboard to Excel?

To download dashboard data to Excel, start with the table finance actually needs. In our example, the dashboard contains a sales chart, a returns summary and a store-level sales table. Choosing the dashboard’s name is not enough to explain which of those results belongs in the spreadsheet.

For the example, select the week ending 18 October 2026 and the North region, then open Download > Crosstab. Choose the relevant dashboard sheet and select Microsoft Excel (.xlsx). Tableau’s download guide confirms that the dialog lists dashboard sheets, including hidden sheets, and that current filters, parameters and selections are reflected in the crosstab.

Open the Download menu, then choose Crosstab to select a sheet and Excel output. The toolbar shown is Tableau’s documentation example.

If finance needs underlying records rather than the displayed summary, use Data instead: first select the dashboard sheet, then inspect the available summary or detail data and download CSV. Excel can open that text file, but it is a different deliverable from a native XLSX crosstab.

Open the result before sharing it. For the North region example, compare a store identifier, the selected week and the sales total with the intended source table. Those checks establish what this particular download contains; a familiar filename alone does not.

A useful spreadsheet has the right data at the right level. A row representing a store’s weekly total serves a different purpose from individual transactions, even when both come from the same dashboard. Agree that distinction with finance before designing an automated job.

Compare the interactive choices in Tableau’s download guide with the limits of its XLSX crosstab method. ATRS Excel output settings address preparation of the exported workbook. If finance needs a different level of detail, agree an appropriate export view with the author before preparing the workbook.

For our analyst, the first success criterion is a usable North sales table. Recreating charts, adding template formulas and scheduling delivery are separate requirements that can be added once the source output is understood.

Once the selected table matches finance’s reconciliation, use that sample as the specification for the recurring job. Record the source view, period, region, required columns and destination. The sample gives the analyst and finance something concrete to compare with each later output.

Create an ATRS Single Schedule, choose the linked Tableau account and report path, and give it a recognizable name such as “North weekly sales workbook.” Supply the report’s required parameters and preview the content. A filter used in your browser should not be assumed to carry into this separate reporting job; configure the required values explicitly.

Under Destinations, choose the delivery location and Excel format. Both MS Excel and MS Excel Data Only produce XLSX. Use the latter’s Advanced settings when finance needs template placement, selected totals or column formatting. Follow the Single Schedule setup and Excel export instructions for the installed application.

Choose the source table first, then evaluate the spreadsheet it produces. This illustration shows the reporting choice, rather than a product screen.

For this example, deliver the workbook to an agreed operations folder and select a weekly recurrence after the reporting data is expected to be ready. Check the current ATRS host and Office prerequisites for advanced Excel output, including access to the destination from the account running the job.

Open the delivered sample and repeat the North table checks from chapter 1. Also check its name and location, so finance can distinguish a new workbook from last week’s file. Decide who will investigate a failed export or missing file before enabling the recurring job. ATRS then takes over the repeated export, workbook preparation and delivery choices that the analyst previously handled by hand.

An internal application may need a download button for the same finance table. Start from the specific view identifier, rather than assuming the dashboard URL means “export every sheet.” This keeps the application’s promise aligned with the file its endpoint actually returns.

After signing in to the Tableau REST API, use the returned credentials token in the request header. The following is an illustrative request; replace the API version, site and view identifiers with values from the authorized deployment.

GET /api/<api-version>/sites/<site-id>/views/<view-id>/crosstab/excel
X-Tableau-Auth: <tableau-session-token>

The documented XLSX method is available from API 3.9. It returns summary data; when the requested view is a dashboard, only its first view is included, and story-dashboard downloads are unsupported. Non-administrators need Read and ExportData permissions on both the view and its containing workbook.

That first-view rule differs from the interactive sheet-selection dialog. Resolve the intended worksheet’s exportable view identifier where available, or work with the author to publish an appropriate export view. Do not silently return the sales chart’s summary when the button promises the store reconciliation table.

Keep any required period and region in the export request’s approved configuration. Temporary selections in another browser session do not define this request. Repeated downloads can be cached, so verify source freshness separately; changing a cache interval does not refresh an extract.

Check the response status and expected XLSX content type, then validate the workbook against the agreed columns and totals before returning or delivering it. Keep each user’s authorized selection separate from another user’s request. If the application needs a maintained export-and-delivery job, the ATRS Developer Hub describes that separate integration route; downloading an XLSX response by itself does not email it.

For a one-off reconciliation, the native Crosstab download is a proportionate starting point. Choose the intended sheet, open the workbook and confirm that the table answers finance’s question. Use the available Data download when the task calls for detail instead of the displayed summary.

Consider ATRS Tableau report automation when the same table needs a repeatable workbook preparation and delivery process. Bring the approved source, the checked sample spreadsheet and its destination to the evaluation. That makes it possible to judge the actual file rather than the dashboard’s appearance.

Explore Tableau Excel report automation and template workbooks

Planning a recurring Excel handoff? Use the guide to review ATRS deployment, access and reporting requirements with the colleagues who will maintain and receive it.

Download the ATRS Internal Evaluation Guide