Can Tableau Subscriptions Email Excel Attachments?
Native Tableau subscriptions email PNG images, PDF snapshots or both. They do not provide Excel attachments as a subscription format. For a one-off spreadsheet, an authorized user can download a crosstab as XLSX and share it through an approved route. For recurring workbook emails, use an owned export-and-mail integration or Advanced Tableau Report Scheduler (ATRS).
Consider a Monday sales update: managers need the headline snapshot, while finance needs store-level spreadsheet rows to reconcile the weekly total. Keep the useful native snapshot where it fits and define a separate Excel deliverable for finance. The important result is the workbook finance can use, rather than an image that only looks like a table.
- THE DIRECT ANSWER Use the right output for the reader’s task
- REQUIREMENTS AND LIMITATIONS Choose between a subscription and an Excel delivery job
- END-USER WORKFLOWS Prepare the workbook attachment in ATRS
- DEVELOPER AND API WORKFLOWS Export the XLSX before building application delivery
- CHOOSE YOUR NEXT STEP Check the received workbook before making it recurring
Use the right output for the reader’s task
Tableau subscriptions and Excel attachments meet different reporting needs. The native subscription’s PNG/PDF choices provide a snapshot to review. Finance’s workbook needs usable rows and columns for reconciliation. Changing the email subject or giving an image an .xlsx filename will not produce that spreadsheet.
Define the tabular workbook finance needs before choosing its export and delivery route.
For an occasional request, open the permitted Tableau view and choose Download > Crosstab. Select the intended sheet when working from a dashboard, then choose Microsoft Excel .xlsx. Current filters, parameters and selections are reflected in that downloaded crosstab. The Tableau download instructions describe those choices and their permission requirements.
Open the downloaded workbook before sharing it. For the weekly sales example, identify the required stores, reporting dates and sales measure. Compare the selected crosstab with that requirement; being able to download a file does not establish that it contains every underlying transaction or every dashboard sheet.
A manual download is a reasonable route for a rare request. If finance needs the same workbook every Monday, account for the repeated selection, export, naming and email work. That is the point to evaluate a maintained export-and-delivery process. The Tableau subscription email guide remains the reference for the separate PNG/PDF email.
Define the spreadsheet request
Rows: Name the stores and reporting period.
Columns: Agree the fields finance needs.
Values: Distinguish editable data from a screenshot.
Audience: Approve the attachment’s recipients.
Choose between a subscription and an Excel delivery job
Keep the managers’ snapshot and finance’s reconciliation workbook as explicit deliverables. That makes the choice clearer than asking a subscription setting to perform an unsupported format conversion. Compare what each complete workflow will produce and who will maintain it.
| Requirement | Native or owned export route | Where ATRS helps |
|---|---|---|
| A recurring image or PDF | A native subscription supplies the supported snapshot to permitted Tableau users. | Use a separate reporting job when the same requirement also needs workbook preparation or other destinations. |
| An occasional spreadsheet | An authorized user downloads the selected sheet’s XLSX crosstab and shares the checked file. | A maintained schedule becomes useful when the same preparation and sending recur. |
| A recurring XLSX email | Use an owned authorized export integration with its own scheduler, file checks and mail delivery. | Configure the Excel output, recurrence, filename and Email destination together. |
| A company workbook layout | A crosstab can be a starting file; any additional preparation remains part of your process. | MS Excel Data Only provides template placement and additional workbook controls. |
| A correct and usable attachment | Choose the required sheet and data scope, then inspect the actual file. | Check the source rows and finished workbook; a scheduled export does not establish completeness by itself. |
Tableau’s REST API also offers an XLSX crosstab export. That is useful for a team that wants to own the integration. Its documented result is summary crosstab data; for a dashboard, the method returns the first view, and story-dashboard downloads are unsupported. Plan for those boundaries rather than assuming that one call exports an entire analytical workbook.
ATRS supports Tableau Excel report automation by maintaining the export and delivery configuration. It still needs an appropriately authorized Tableau account and a source view containing the intended information. It does not turn a dashboard screenshot into editable data or automatically include data absent from the selected export.
Compare complete workflows
Native: Use PNG/PDF for the snapshot audience.
Download: Use an authorized XLSX for a one-off need.
Integration: Own scheduling, output checks and sending.
ATRS: Maintain recurring workbook and delivery settings.
Prepare the workbook attachment in ATRS
Start the ATRS job with the workbook finance has agreed to receive. Create a Single Schedule, choose the linked Tableau account and sales report, set the weekly recurrence and supply the reporting-period values. Preview the selected content before adding its Email destination. Follow the ATRS Single Schedule workflow for those report settings.
In the destination’s Format section, select MS Excel for a straightforward XLSX export. Select MS Excel Data Only when the workbook needs template placement, totals or the additional styling controls. Both produce .xlsx files. The ATRS Excel export guide describes the two modes. Check the current host and Office prerequisites before configuring advanced Excel output.
If finance needs a prepared company template, use MS Excel Data Only and identify its worksheet and starting row and column. Check that a representative larger export stays clear of required formulas and review areas. Template placement is an option to configure and test; it does not guarantee that formulas expand or old data is cleared automatically.
Finance’s Monday workbook acceptance
Row set: Include the agreed stores and week, with the expected record count.
Reconciliation: Match the agreed sales total to the approved source.
Usability: Check dates, numeric cells and any identifier formatting in the spreadsheet application finance uses.
Delivery: Open the attachment received at the controlled test address.
In the Email destination, enter the approved recipients, a subject identifying the reporting period and a short message explaining the workbook’s purpose. Select the configured sending account and a recognizable output filename. The Email destination guide covers message and sending settings.
Use Tools > Test with a controlled destination and inspect the received workbook. If managers should also receive a PDF, define that as another output or reporting requirement instead of assuming the Excel file includes the same visual presentation. A Tableau report scheduler can maintain the recurring choices that the analyst would otherwise repeat each week.
Review the actual attachment
Content: Check row count and the agreed total.
Types: Inspect identifiers, dates and numeric values.
Layout: Check worksheets and any template insertion area.
Mail: Open the workbook received by the test reader.
Export the XLSX before building application delivery
For an owned integration, Tableau’s Download View Crosstab Excel method provides the XLSX export step. Use the authorized account, supported API version and identifiers for the selected view. This illustrative request downloads a file; it does not create an Excel subscription or send an email.
GET /api/<api-version>/sites/<site-id>/views/<view-id>/crosstab/excel
X-Tableau-Auth: <tableau-session-token>A non-administrator caller needs Read and ExportData permissions for both the workbook containing the view and the view itself. Validate the HTTP response and XLSX content type, then save and open the returned workbook. Confirm the expected rows and total before handing the file to the approved mail service. Refer to the native XLSX method reference for its scope and caching behavior.
Keep the view-selection boundary explicit: this summary export is not an all-transactions download, and the dashboard method’s first-view result may differ from the sheet finance intended. Test the exact identifier and data scope used by the application rather than only a manual download from a different sheet.
An owned application also needs recurrence, recipient selection, naming, mail delivery and recovery. If it instead requests an existing ATRS reporting job, retain the execution identifier and inspect both the result and destination outcome. The ATRS Developer Hub documents that execution route. Either approach needs a checked workbook at the end of the handoff.
Treat the API as an export
Permission: Use the authorized Tableau account.
Scope: Check which view supplies the crosstab.
File: Validate the downloaded XLSX.
Handoff: Send it through the separately configured route.
Check the received workbook before making it recurring
For the Monday example, let managers keep the native snapshot if it meets their need. Give finance the separately defined workbook through a manual export for an occasional request, an owned integration or an ATRS job for recurring delivery. Choose the route based on the file the reader needs and the work your team wants to maintain.
Before making it recurring, open the received attachment in finance’s spreadsheet application. Confirm the reporting period, store rows, data types and weekly total, along with any template formulas or editable areas. That is the acceptance check for the Excel attachment.
Explore ATRS Excel output and template workbooks
Considering recurring Excel attachments? Share the guide with the colleagues responsible for deployment, the workbook specification and report delivery.
Contributors:
Christian Ofori-Boateng
CEO, ChristianSteven Software
