Tableau to CSV — Desktop · Server · Cloud — tabcmd automation
Export Tableau to CSV Download data, Crosstab and tabcmd.
Three ways to get data out of Tableau as CSV — Download Data from view, Crosstab export and tabcmd command-line automation. Works in Tableau Desktop, Tableau Server and Tableau Cloud. Dashboard export limitation explained with the correct workaround.
The most direct method — exports the data underlying the current view as CSV. Works in Tableau Desktop, Server and Cloud. Active filters and parameters are applied to the exported data.
1
Open the sheet (not a dashboard)
Navigate to the specific worksheet tab you want to export. Dashboards don't have a direct download — click a worksheet within the dashboard first, or use the Go to Sheet option from the dashboard.
2
Tableau Desktop — Worksheet menu
Worksheet → Export → Data. A dialog opens showing the underlying data. Click Export All at the bottom left and save as a .csv file.
3
Tableau Server / Cloud — Download button
In the published view toolbar, click the Download icon (arrow pointing down) → Data. Choose Download all rows as a text file for CSV output.
4
Apply filters before exporting
All active filters, parameters and context filters in the view are reflected in the export. Filter to the date range or dimension value you need before downloading to get a targeted subset.
What gets exported: The View Data dialog shows two tabs — Summary (aggregated as displayed) and Full Data (row-level detail). Click Full Data then Export All to get the underlying rows rather than the aggregated view.
Crosstab export preserves the visual structure of the view — rows, columns and measure values exactly as displayed. Best for pivot-style exports that need to match the report layout.
1
Tableau Desktop — Worksheet → Export → Crosstab to Excel
Go to the worksheet → Worksheet → Export → Crosstab to Excel. This opens the Crosstab export dialog. Choose your dimensions and measures, then click Export.
2
Convert Excel to CSV
The Crosstab export always produces an .xlsx file. Convert it to CSV using CSVShift Excel to CSV — upload the .xlsx and download the .csv.
3
Tableau Server / Cloud — Download → Crosstab
In the published view: click Download → Crosstab. Choose Excel or CSV. On Server and Cloud, CSV is available directly — no intermediate .xlsx conversion needed.
Crosstab vs Download Data: Crosstab exports the view layout (row/column headers + measure values). Download Data exports the underlying rows. Use Crosstab when the output needs to match the visual structure exactly. Use Download Data when you need the raw row-level records.
tabcmd is Tableau's free command-line tool for automating exports from Tableau Server and Tableau Cloud. Schedule CSV exports without opening a browser.
1
Install tabcmd
Download from tableau.com/support/releases/tabcmd. On macOS: brew install tabcmd. On Windows: run the installer. tabcmd is free and included with Tableau Server.
2
Login to your Server / Cloud
Run tabcmd login -s https://yourserver.com -u username -p password. For Tableau Cloud use your Cloud URL (e.g. https://prod-apnortheast-a.online.tableau.com).
3
Export the view as CSV
Run the export command (see code block below). The --type csv flag downloads the view data. Replace WorkbookName/SheetName with your workbook and sheet.
4
Schedule with cron or Task Scheduler
Wrap the commands in a shell script and schedule with cron (Linux/macOS) or Windows Task Scheduler for daily or weekly automated exports.
tabcmd vs REST API: tabcmd is simpler for one-off and scheduled exports. The Tableau REST API gives more control — filter by parameter value, iterate over workbooks, export multiple sheets. Use tabcmd first; switch to REST API when you need programmatic logic.
tabcmd export commands
Copy and adapt for your server URL, workbook and sheet names.
tabcmd — login and export CSV
# Login to Tableau Server (run once per session)
tabcmd login \
-s https://your-tableau-server.com \
-t SiteName \
-u your_username \
-p your_password
# Export a sheet as CSV
tabcmd export "WorkbookName/SheetName" \
--type csv \
--filename output.csv
# Export with URL filters applied
tabcmd export "WorkbookName/SheetName?Region=West&Year=2024" \
--type csv \
--filename output_west_2024.csv
# Logout
tabcmd logout
WorkbookName/SheetName is case-sensitive and must match the URL in Tableau Server exactly. For Tableau Cloud use -s https://prod-useast-a.online.tableau.com (your region's URL).
The $(date +%Y-%m-%d) creates a dated filename: tableau_2024-01-15.csv. Schedule with cron: 0 6 * * * runs daily at 6am. Store credentials in environment variables rather than hardcoding for production scripts.
Export methods compared
Method
Works in
Automated?
CSV direct?
Best for
Download Data
Desktop · Server · Cloud
✗ Manual
✓
Quick row-level export, filtered subsets
Crosstab (Desktop)
Desktop only
✗ Manual
⚠ .xlsx → convert
Preserving visual layout, pivot tables
Crosstab (Server/Cloud)
Server · Cloud
✗ Manual
✓
Published views, layout-matched output
tabcmd
Server · Cloud
✓ Scriptable
✓
Scheduled recurring exports, CI/CD pipelines
Tableau REST API
Server · Cloud
✓ Scriptable
✓
Programmatic exports, filtering by parameter
Common issues and fixes
Exporting a dashboard
Dashboards don't export directly. Click a sheet within the dashboard → Go to Sheet from the right-click menu, or click the sheet tab directly. Then export the individual worksheet. Each sheet in a dashboard must be exported separately.
Export only filtered data
Apply filters, parameters or context filters to the view before exporting. Download Data and Crosstab both respect active filters. In tabcmd, pass URL parameters: WorkbookName/Sheet?Region=West exports only the West filter value.
Download button missing
The Download option can be disabled by Tableau Server admins. Check with your server administrator. In Tableau Desktop, Download Data is always available via the Worksheet menu even if the toolbar button is hidden.
Getting more rows
Tableau Desktop's View Data → Full Data → Export All has no hard row limit — it exports all underlying rows. On Server/Cloud the admin can configure the maximum rows via Server settings → Download full data. Default is typically 200,000 rows.
When do you need Tableau to CSV?
Sharing with non-Tableau users
Colleagues without Tableau licences can't view published workbooks. Exporting the underlying data to CSV lets them analyse it in Excel, Google Sheets or Power BI without needing Tableau access.
Automated reporting
tabcmd scheduled exports deliver CSV files daily or weekly to a shared folder or email — without manually opening Tableau. Finance teams use this for recurring data extracts that feed other reporting systems.
Python and R analysis
Tableau's visual layer is optimised for dashboards. Exporting filtered data to CSV and loading into pandas or R enables statistical analysis, machine learning and custom visualisations beyond what Tableau's calculated fields support.
Audit and compliance
Regulatory and compliance workflows often require point-in-time data exports from business intelligence tools as evidence. Tableau CSV exports with a datestamped filename (via tabcmd $(date)) create an audit trail of what the data showed on a specific date.
Download Data, Crosstab and tabcmd. Dashboard trap avoided.
The most common Tableau export frustration is trying to download data from a dashboard and finding no option — because Tableau's Download button only works on individual sheets, not dashboards. The guide above explains exactly how to navigate to the underlying sheet and what the difference between Summary and Full Data means for the exported rows.
The tabcmd scheduled export script creates a datestamped CSV file on every run — ready to drop into a cron job for daily automated delivery. No manual clicks, no browser required.
Three methods tabbed
Download Data, Crosstab and tabcmd — step by step for Desktop, Server and Cloud.
Dashboard export fix
The most common Tableau export confusion — explained and solved in step one of the guide.
tabcmd scheduled script
Full login + export + logout shell script with datestamped filename — ready for cron.
Free, no conditions
No account, no upload. Funded by display advertising only.
Frequently asked questions
How do I export data from Tableau to CSV?
In Tableau Desktop: go to a worksheet (not a dashboard) → Worksheet → Export → Data → Export All → save as .csv. In Tableau Server or Cloud: open a sheet → click the Download icon in the toolbar → Data → Download all rows as a text file.
How do I export a Tableau dashboard to CSV?
Dashboards don't export directly — only individual sheets do. Right-click a sheet within the dashboard → Go to Sheet, or click the worksheet tab directly at the bottom. Then use Worksheet → Export → Data. Each sheet must be exported separately if you need data from multiple charts.
What is the difference between Download Data and Crosstab?
Download Data exports the underlying row-level records — the raw data behind the view. Crosstab exports the visual structure as displayed — with row and column headers matching the view layout. Use Download Data for data analysis. Use Crosstab when the output needs to match the report's pivot table structure.
How do I automate Tableau CSV exports?
Use tabcmd: tabcmd login -s https://yourserver.com -u user -p pass then tabcmd export "Workbook/Sheet" --type csv --filename output.csv. Schedule the script with cron (Linux/macOS) or Task Scheduler (Windows). See the tabcmd tab and code blocks above for the full script.
How do I export more rows from Tableau?
In Tableau Desktop, View Data → Full Data → Export All has no hard limit. In Server/Cloud, the admin controls the maximum via Server settings → Download full data (default ~200,000 rows). To export beyond this, use tabcmd or the Tableau REST API, or export directly from the underlying data source.
