Can Tableau’s Export All Extension Run Automatically on a Schedule?
Finance gets its Sales and Returns workbook by clicking Export All every Monday. When the analyst is away, someone else has to repeat the download before the review can start.
Advanced Tableau Report Scheduler (ATRS) can prepare and deliver the recurring workbook from Tableau Cloud, including the merge and Excel preparation finance needs.
- THE PROBLEM AND ANSWER Turn finance’s weekly download into a recurring workbook
- YOUR OPTIONS Choose how the complete workbook will be prepared
- SET IT UP Prepare Sales and Returns for the same reporting week
- FOR DEVELOPERS Let your application request the finance package
- YOUR NEXT STEP Have the review workbook ready without the weekly download
Turn finance’s weekly download into a recurring workbook
Export All has made the analyst’s weekly download convenient. One click produces the selected Sales and Returns data, and finance knows how to use that workbook.
The next request is familiar: could the file be waiting before the meeting, even when nobody is there to press the button? That is a recurring reporting job rather than another interactive download.
The Information Lab’s documented extension workflow is button-driven. ATRS provides its own preparation and delivery route, using the Tableau Cloud reports needed for finance’s workbook.
Keep the existing workbook beside you when planning that route. Its selected sheets, fields and reporting week show the useful result the analyst has been delivering by hand.
Use the selected sheets and columns from the existing Export All workbook as the specification for finance’s scheduled output.
What Export All documents and what the scheduled job must supply
The Tableau Exchange listing describes a dashboard button, selected sheets and columns, and a single Excel download. The developer’s public project documents the interactive setup and describes summary-data export. Neither documents a built-in unattended scheduling and email service for this workflow.
If the extension is unavailable to interactive users, ask the Tableau administrator to review its network-enabled extension approval and site policy. That access issue is separate from configuring recurring delivery. Do not assume enabling the extension creates a scheduler.
Use the existing file to confirm fields, aggregation, filters and period for each report. An alternative export route must be checked against that requirement; it should not be presented as automatically reproducing Export All’s workbook or configuration.
Bring the workbook finance already uses
Its fields and tabs give everyone a shared picture of the file the meeting needs.
Choose how the complete workbook will be prepared
For an occasional request, keep the interactive download. There is no need to replace a convenient button when the reader wants to choose a file while using the dashboard.
The weekly meeting adds a different need. Someone must select the period, prepare the report outputs, assemble the workbook and deliver it in time. ATRS can hold those choices in a report package.
Sales and Returns can become useful tabs in one Excel workbook, with the template, formats and protection finance uses. The package can email the finished file and save an archive copy, taking more of the repeated Monday work off the analyst’s list.
Include the finishing work
Ask what the analyst does after Export All completes. Naming, combining and sending may take as much repetition as the download.
Prepare Sales and Returns for the same reporting week
Begin with the Sales and Returns reports and a known week. In an ATRS Package Reports Schedule, select their Tableau Cloud account and report paths, then choose the Excel output for each.
Preview the reports before combining them. Finance can help compare them with its familiar Export All workbook, including the columns and totals that matter to the review.
Enable Merge all Excel Files, give the reports useful worksheet names and prepare any required template or formatting. Write the short email finance expects when the pack arrives.
Use Test Package to send the complete workbook to a controlled destination and open it together. Once it supports the same review, set the advancing reporting period and Monday recurrence. The analyst can maintain the job without being the person who has to press the button every week.
The package report list brings its outputs together. This knowledgebase example uses PDF reports; the separate Merge all Excel files option is the one relevant to finance’s workbook.
Package, Excel preparation and delivery options
The Package Schedule guide covers report selection, destinations, Excel/PDF merging and exception handling at report and package levels. Excel merging retains formatting and style. Check each member and the final combined file, including how the job responds to missing required content.
The Excel guide covers worksheet names, workbook passwords, file properties and naming. Data Only supports a template worksheet with a specified or next available row/column, selected row/column totals, reusable styling and header-based data types and custom formats. Test formulas, changing row counts and any old cells around inserted data.
Related Files & Folders tasks can merge existing Excel files or change a workbook’s password, read-only setting and file summary. Build Excel Workbook creates a file from database queries and datasets; it is separate from exporting Tableau reports.
Use clear filenames and date/time suffixes for recurring outputs. ZIP password protection, configured PGP encryption and deferred delivery are available preparation choices where appropriate. Check the current host and 64-bit Office prerequisites for advanced Excel output.
For personalized packs, the Data-Driven Package guide covers grouping and merged PDF or Excel delivery. Grouped package outputs are attachments rather than embedded report bodies. Verify the intended audience and file for each sample.
ATRS supports Tableau Cloud only. It does not schedule a click on Export All or automatically import the extension’s selected sheets and columns. Configure the equivalent reporting requirement and test it through ATRS’s own output and delivery route.
Read Sales and Returns together
Finance’s first received pack is a good place to discuss whether the tabs and reporting week support the review.
Let your application request the finance package
The finance application may need the same workbook for an additional meeting. It can request the saved ATRS package, reusing its reports and Excel preparation.
The reporting team keeps the assembly and destinations in ATRS while the application follows that particular requested pack through its result.
API example: execute and monitor the stored report package
Find the intended package and its actual UniqueId through the documented folder and package discovery operations. This example uses ScheduleType: package for an ordinary report package. Replace 101 with its stored identifier, use your ATRS HTTPS address and keep the token on the backend.
POST /api/Schedule/ExecuteScheduleAsync
Authorization: Bearer <ATRS-access-token>
Content-Type: application/json
{
"ScheduleType": "package",
"UniqueId": 101,
"RunBy": "Finance application"
}
GET /api/Schedule/GetExecutionStatus?ExecutionId=<returned-id>
Authorization: Bearer <ATRS-access-token>Authorize the caller for this finance package. Save the returned ExecutionId, poll within a defined time limit and parse the JSON-encoded ResultJson. Completed can contain Result=false. Check every required report and the destination, rather than treating a finished execution as proof of a complete workbook.
The request runs the package’s saved report inputs, merge and delivery settings. It does not invoke Export All, supply a new reporting period or return the workbook bytes. Configure assembly through the supported ATRS workflow unless the API explicitly documents the setting you need.
For a data-driven package, use its actual stored family and documented execution contract. After an uncertain response, inspect the execution and destination before resubmitting to avoid duplicate deliveries. See asynchronous execution and monitoring and delivery verification.
Keep the package ready for another meeting
The application can request the same maintained workbook without recreating its assembly.
Have the review workbook ready without the weekly download
Finance can begin its review with Sales and Returns ready in the workbook, even when the analyst is away. The interactive download can remain useful for other questions during the week.
Start with the file the team already accepts. Use it to explore the report preparation and delivery that ATRS can make recurring.
Contributors:
Christian Ofori-Boateng
CEO, ChristianSteven Software

