How Do You Preserve Tableau Excel Export Formatting?

On Tableau Cloud or Server, download the required crosstab as XLSX. In Desktop, use Worksheet > Export > Crosstab to Excel. For a large Desktop export, Tableau may ask whether to include formatting because copying and formatting together can take longer. See Tableau’s crosstab guidance.

Tableau’s number-format controls set the display of decimals, units, currency and percentages. Check the exported cell value as well as its appearance. CSV is a text data handoff and cannot retain Excel worksheet styles or multiple tabs.

For a percentage, confirm whether the source supplies a ratio or percentage points. With 0.00%, a value of 0.0123 displays as 1.23%; a value of 1.23 displays as 123.00%. A store code such as 0027 also needs the right source type. Formatting cannot restore digits or precision already lost before the export.

The Excel guide covers worksheet naming, workbook passwords, file-summary properties and custom filenames. Data Only supports a chosen template worksheet and starting row/column, or the next available position, selected row/column totals, header-based data types and custom formats, and styles you can reuse.

The released Data Only controls include font weight, foreground and background colors for headers and totals, column formatting and data validation. Configure and test validation for your requirement; separately check the required columns, rows and agreed totals.

Use the Package Schedule guide for multiple attachments, ZIP packaging and Excel merging. The merge retains report formatting and style; check each report and the final tabs. Data-driven packages also support grouping and merged Excel output for the appropriate audience.

The Files & Folders tasks extend workbook preparation. Merge Excel Files combines existing files with destination, replacement, password and file-summary controls. Manipulate Excel changes an existing workbook’s password, read-only setting and summary. Build Excel Workbook creates a workbook from database queries and datasets; it is separate from exporting Tableau content.

Naming and delivery options include date/time suffixes, ZIP output with optional password protection, configured PGP encryption and deferred delivery. Use the controls that suit the recipient’s process. Read-only handling and password protection serve different purposes.

Check the current Windows and 64-bit Office prerequisites, plus unattended access to the template and destinations. ATRS supports Tableau Cloud only. Test formulas and changing table sizes explicitly; template placement does not guarantee that formulas expand or stale cells clear automatically.

This example runs an ordinary single-report schedule. Replace 101 with its actual UniqueId, use your ATRS HTTPS address and keep the bearer token on the backend. Configure and test the report, period, Excel options and destinations in ATRS first.

POST /api/Schedule/ExecuteScheduleAsync
Authorization: Bearer <ATRS-access-token>
Content-Type: application/json

{
  "ScheduleType": "report",
  "UniqueId": 101,
  "RunBy": "Finance application"
}

GET /api/Schedule/GetExecutionStatus?ExecutionId=<returned-id>
Authorization: Bearer <ATRS-access-token>

Save the returned ExecutionId and poll within a defined time limit. Parse the JSON-encoded ResultJson: Completed can contain Result=false. Inspect the result and verify the workbook and destination before telling the user the file is ready.

This execution request uses saved settings; it does not supply a template, starting cell, new recipient or format override. The response is tracking information, not the workbook bytes. For packages, use the actual stored identifier and documented package schedule type.

Keep advanced Excel preparation in the tested ATRS configuration; the API reference does not document every template or formatting control. After an uncertain response, inspect the execution and destination before retrying to avoid duplicate copies. See the ATRS execution guide.