Tableau Desktop · Tableau Public — live calculated fields — no upload
Connect CSV to Tableau Text File connector, calculated fields live.
Step-by-step guide to connect a CSV to Tableau Desktop or Tableau Public. Enter your field names — the calculated field examples update live with your actual column names. Covers the Text File connector, data source page, field types, LOD expressions and chart building. Your data never leaves your browser.
Desktop & Tableau Public
Live calculated fields
DATETRUNC + LOD
Step-by-step guide
Always free
Personalise calculated field examples with your field names Tableau
Enter your CSV field names — calculated field examples update live below
Calculated fields — Analysis → Create Calculated Field
Create each calculated field via Analysis → Create Calculated Field, or right-click any field in the Data pane → Create → Calculated Field. Each formula is a separate field.
Connect your CSV — step by step
The Text File connector works the same in Tableau Desktop and Tableau Public.
1
Open Tableau Desktop
Launch Tableau Desktop. The Start page shows the Connect panel on the left.
2
Connect → Text File
Under To a File in the Connect panel, click Text File. Browse to your CSV and click Open.
3
Data Source page
Tableau opens the Data Source page. Your CSV appears as a table in the left panel. Drag it to the canvas — the data preview appears at the bottom.
4
Assign field types
Above each column in the preview, click the type icon (Abc / # / calendar / T|F) to set the correct type. Pay particular attention to date columns — Tableau often imports them as strings.
5
Rename fields (optional)
Double-click any column header in the preview to rename it. Clean field names here save time building charts — avoid spaces by using underscores or title case.
6
Go to Sheet 1
Click the Sheet 1 tab at the bottom left. Dimensions appear in blue in the Data pane; Measures in green. Drag fields to Rows, Columns or the Marks card to start building.
1
Open Tableau Public Desktop app
Download and launch the free Tableau Public app from public.tableau.com. The Start page shows the same Connect panel as Desktop.
2
Connect → Text File
Under To a File, click Text File. Browse to your CSV and click Open. Tableau Public supports CSV, Excel and Google Sheets as data sources.
3
Data Source page and field types
Same as Desktop — drag the table to the canvas, assign types, rename fields. Note: Tableau Public workbooks are published publicly — do not use CSV files containing private or sensitive data.
4
Build and publish
Click Sheet 1, build your visualisation, then File → Save to Tableau Public. The workbook is published to your Public profile. You must be signed in to save.
Data Source page — key tips
Three things to do before clicking Sheet 1 that will save time later.
Fix date field types
Tableau often imports date columns as String. Click the Abc icon above the column → Date. If dates are in a non-standard format (e.g. DD/MM/YYYY), use a calculated field: DATEPARSE("dd/MM/yyyy", [date_col]).
Set numeric field roles
IDs and codes (customer ID, postal code) should be Dimensions, not Measures. Right-click the field in the Data pane → Convert to Dimension. Tableau puts any numeric column in Measures by default.
Create a hierarchy
If you have Year, Month and Day columns (or Country, Region, City), drag one onto another in the Data pane to create a hierarchy. This enables drill-down in charts — click + on a date axis to expand.
More calculated field formulas
Common Tableau formulas that go beyond what the personaliser above generates.
LOD expressions — fixed calculations
// % of total — ignores filters on the view dimension
% of Total Sales =
SUM([Sales]) / {FIXED : SUM([Sales])}
// Customer-level average — regardless of date filter
Avg Sales Per Customer =
{FIXED [Customer ID] : SUM([Sales])}
// First order date per customer
First Order Date =
{FIXED [Customer ID] : MIN([Order Date])}
LOD (Level of Detail) expressions compute at a different granularity than the view. FIXED ignores view-level dimensions. INCLUDE adds extra dimensions. EXCLUDE removes them.
Table calculations — running totals and rank
// Running total of Sales
Running Total = RUNNING_SUM(SUM([Sales]))
// Rank by Sales (1 = highest)
Sales Rank = RANK(SUM([Sales]))
// % difference from previous period
Period Change =
(SUM([Sales]) - LOOKUP(SUM([Sales]), -1))
/ ABS(LOOKUP(SUM([Sales]), -1))
// Moving average (3-period)
Moving Avg Sales = WINDOW_AVG(SUM([Sales]), -2, 0)
Table calculations compute across rows in the view. Right-click the pill on the Rows/Columns shelf → Edit Table Calculation to set direction (across, down, etc.).
When do you need CSV to Tableau?
Interactive dashboards
Tableau's drag-and-drop interface builds interactive charts and dashboards from CSV data faster than writing code. Filters, highlights and drill-downs are configured visually — no HTML or JavaScript required.
Exploratory visual analysis
Show Me suggests chart types based on the fields you select. Dragging dimension and measure combinations onto the canvas reveals patterns in CSV data that are invisible in a spreadsheet view.
Sharing with Tableau Public
Tableau Public lets you publish interactive charts for free and embed them in websites or share links. CSV data from surveys, open datasets and research can be visualised and published without a Tableau Server licence.
Enterprise reporting
CSV exports from Salesforce, SAP, Oracle and other enterprise systems are the most common Tableau data source. Connecting Tableau directly to a CSV export enables ad hoc reporting without waiting for IT to set up a database connection.
csv to tableautableau import csvconnect csv to tableauhow to import csv into tableautableau csv connectortableau public csvtableau text file csvtableau calculated field examplestableau datetrunc csvtableau lod expression csvtableau csv date formatconnect csv tableau desktop
Calculated fields written for your columns. Not placeholders.
The personaliser above generates Tableau calculated field formulas using your actual field names — profit margin uses your Sales and Profit columns, DATETRUNC uses your date field, IF bucketing uses your numeric range. No [Measure Name] placeholder strings to hunt and replace.
The LOD expression examples cover the three most useful patterns — FIXED % of total, FIXED per-customer aggregation, and FIXED first event date. These are the calculated fields that trip up Tableau newcomers most often, with notes on what each level of detail keyword does.
Live field name personaliser
Four inputs, eight formulas updated — every calculated field uses your actual column names.
Desktop + Public guide
Tabbed steps for both Tableau Desktop and Tableau Public — same connector, slightly different publishing flow.
LOD + table calculations
FIXED, INCLUDE, EXCLUDE, RUNNING_SUM, RANK and WINDOW_AVG — the advanced patterns with explanations.
Free, no conditions
No account, no upload. Funded by display advertising only.
Frequently asked questions
How do I connect a CSV to Tableau?
On the Tableau start page: Connect → Text File. Browse to your CSV and click Open. Tableau opens the Data Source page — drag the table to the canvas. Assign field types (date columns are often imported as strings), then click Sheet 1 to start building visualisations.
How do I create a calculated field in Tableau?
Analysis menu → Create Calculated Field. Or right-click any field in the Data pane → Create → Calculated Field. Type the formula — field names in square brackets, functions in caps. Click OK — the field appears in the Data pane with a = icon and can be used in any chart.
Why is my date column showing as a string in Tableau?
Tableau imports CSV date columns as strings if the format isn't recognised. Fix on the Data Source page: click the Abc icon above the column → select Date. If that fails (non-standard format), use a calculated field: DATEPARSE("dd/MM/yyyy", [date_col]) — adjust the format string to match your data.
Does Tableau Public support CSV files?
Yes — same Text File connector as Desktop. Note that Tableau Public workbooks are published publicly on your profile. Do not use CSV files containing private, sensitive or confidential data with Tableau Public.
How do I refresh a CSV data source in Tableau?
In Tableau Desktop: Data menu → Refresh All Extracts, or click the Refresh icon on the Data Source page. For live connections (not extracts), the data is read each time the workbook is opened. For Tableau Server/Cloud scheduled refresh, use a published data source or store the CSV in a shared location accessible by the refresh agent.
