How to Build a Dashboard in Tableau Public

Tableau Public is a free tool for building interactive data dashboards and publishing them on the web. Unlike paid tools, it requires no server setup, no SQL knowledge, and no coding. The trade-off is that everything you publish becomes publicly visible on your Tableau profile, and workbooks save to the cloud rather than locally. For most analysts who need to share dashboards with a team or embed them in a site, neither constraint is a problem.

Preparing Your Data

Tableau Public reads Excel (.xlsx), CSV, Google Sheets, JSON, PDF, and a range of database connectors. For most analysts, a clean CSV or Excel file is the fastest starting point.

Before connecting, four rules prevent the majority of beginner errors.

Column headers in row one. Tableau treats the first row as field names. If your spreadsheet has a report title in A1 with headers in A2, Tableau reads A2 as a data row, not as a header. Delete any title rows above the header row before importing.

One flat table per sheet. Multi-table layouts with subtotals, blank separator rows, or merged cells break the import. Strip the sheet down to a single rectangle of data with no extra formatting.

Dates formatted as real date values. Tableau auto-detects data types but misreads dates stored as plain text, such as "March 2026" or "Q1 Sales." Format date columns as proper date values before importing. The ISO format YYYY-MM-DD works reliably across both Excel and CSV files.

No trailing blank rows or columns. Tableau stops reading data at the first blank row in a detected range. Delete blank rows at the bottom of your dataset before importing.

A practical test dataset: a 200-row sales CSV with columns Date, Region, Product, Units, and Revenue covers everything in this guide. According to Tableau's published documentation, workbooks with under one million rows perform without any noticeable lag on standard hardware.

Installing Tableau Public Desktop

Go to tableau.com/products/public and click Download the App. The installer is approximately 700 MB. During setup, Tableau will prompt you to create a free account. That same account is what you use to publish and share dashboards later.

Tableau Public Desktop is available for Windows and macOS. The minimum requirements are modest: 8 GB RAM and 1.5 GB of disk space handle files up to around 50,000 rows without slowdown.

One important limitation: Tableau Public Desktop saves workbooks only to your Tableau Public cloud profile, not to a local file. There is no local save option in the free version. If your data cannot be made public, you need a paid Tableau Desktop license.

Connecting Your Data

Open Tableau Public Desktop. On the start screen, the Connect panel on the left lists file types. Click Excel or Text File, navigate to your file, and click Open.

Tableau displays the Data Source tab. Your sheet appears in the left pane. Drag it onto the main canvas. Tableau shows a data preview and assigns a type icon to each field: Abc for text, a number sign for numbers, and a calendar icon for dates.

If your column names appear as F1, F2, F3 placeholder labels, Tableau did not recognize the header row. Click Clean with Data Interpreter below the sheet pane, and Tableau will attempt to auto-detect the layout. If the interpreter does not fix it, go back to the source file and remove any content above the header row.

Double-click any field name in the preview to rename it. Click the type icon to change the detected type. Getting types right at this stage prevents the most common errors later.

Once the preview looks correct, click Sheet 1 at the bottom to open the worksheet view.

Understanding Dimensions and Measures

The left panel in the worksheet view shows two groups of fields. Dimensions (shown in blue) are categorical fields: text, dates, and identifiers. Measures (shown in green) are numeric fields that Tableau can aggregate through sums, averages, or counts.

Tableau auto-assigns fields based on data type. A Region column containing text becomes a Dimension. A Revenue column containing numbers becomes a Measure. Dates default to Dimensions but receive special handling, allowing you to group by year, quarter, month, week, or day from a simple right-click menu.

If a field is misclassified, right-click it in the left panel and choose Convert to Dimension or Convert to Measure.

Building Charts

Drag fields to the Columns and Rows shelves at the top of the worksheet canvas to build charts. Tableau selects a chart type automatically based on the combination of field types you drop onto the shelves.

Bar chart (Revenue by Region): Drag Region to Columns, drag Revenue to Rows. Tableau creates a horizontal bar chart. To sort descending, click the sort button in the toolbar. To add color coding by region, drag Region to the Color card in the Marks panel.

Line chart (Revenue over time): Create a new worksheet by clicking the plus icon next to the sheet tab. Drag Date to Columns and Revenue to Rows. Tableau defaults to grouping dates by year. Right-click the Date pill on the Columns shelf, choose the date part option, and select Month to see monthly trends. Switch the chart type in the Marks panel from Automatic to Line.

Map (Units by Region, for geographic data): Drag a geographic field such as Country or State to the canvas. Tableau auto-generates a filled map. Drag a measure like Units to the Color card to shade regions by value.

Rename each worksheet by double-clicking the tab. The name appears in the dashboard panel, so descriptive labels like "Revenue by Region" or "Monthly Revenue Trend" are worth setting before assembling the dashboard.

Assembling the Dashboard

Click the dashboard icon at the bottom of the window, or go to Dashboard > New Dashboard in the menu bar.

The dashboard canvas opens. Your worksheets appear in the Sheets list on the left. Drag each worksheet onto the canvas. Tableau tiles them by default. Drag the borders between charts to resize. Switch to the floating layout option in the left panel for more precise positioning.

To add cross-chart filtering: click any chart on the canvas to select it, then click the funnel icon (Use as Filter) that appears in the top-right corner of the selected chart. Clicking a bar or data point in that chart will now filter every other chart on the dashboard to match.

To add a text title, go to Dashboard > Show Title and edit the text in the canvas.

Publishing

Go to File > Save to Tableau Public. If you are not already signed in, Tableau prompts for your account credentials. Enter a workbook name. Tableau uploads the file (between 10 and 90 seconds depending on file size) and opens the live URL in your browser.

The published dashboard URL follows this pattern: public.tableau.com/views/WorkbookName/DashboardName

From the published view, click Share to get an embed code for inserting the dashboard into a website or intranet page. The dashboard remains fully interactive when embedded.

To update the data later, edit the workbook in Tableau Public Desktop, replace or refresh the data source, and go to File > Save to Tableau Public again. The same public URL updates automatically without requiring a new link.

Common Problems and Fixes

"No data to display" after connecting: Usually a data type mismatch. Go to the Data Source tab and verify that numeric fields display a number-sign icon rather than Abc. If Revenue is marked as Abc, right-click the field header and change the type to Number.

Date chart showing a single aggregated bar: Tableau collapsed dates to the YEAR level. Click the Date pill on the Columns shelf, choose a date part like Month, and switch from measure to dimension if Tableau placed it in the wrong group.

Filters not updating other charts: Right-click the filter pill and choose Apply to Worksheets > All Using This Data Source.

Upload blocked or timing out: Tableau Public has a 15-million-row limit per workbook. For transactional data at scale, aggregate it before import using Excel pivot tables or a simple formula to group by day or week.

If the data preparation step is where most of your time goes, tools like VSLZ let you upload a raw file and get a structured summary and charts directly, without a separate cleaning step.

What to Expect

A complete Tableau Public workflow from a clean CSV to a published four-chart dashboard takes under an hour the first time. After the initial setup, iterating on the layout or swapping in updated data takes under 20 minutes. The biggest time investment is data preparation: ensuring clean column headers, correct date formats, and a flat table structure. Once that foundation is in place, Tableau Public handles the rest through point-and-click.