Fix Tableau CSV encoding and separator before connecting

Choose the separator and encoding that describe the file

If Tableau displays one wide field, or text becomes unreadable, compare the file's actual separator and encoding with the connector settings. Do not solve a header mismatch by changing the data values.

• A regional list separator changes the number of columns
• UTF-8, UTF-16LE, or a legacy code page produces different text
• A header is treated as data or a data row as a header

• Convert the CSV encoding or delimiter →Set source and output formats explicitly and create a separate CSV.
• Check the CSV character encoding →Choose the source encoding from the preview instead of guessing from the country.

Use the workbook connection as the contract

Tableau's text-file examples explain separators, field names, and encodings. Confirm the connection settings and the first row together before changing the export.

• Check whether the first row is a header in the source
• Keep quoted separators and line breaks inside their fields
• Do not convert numeric IDs to numbers when leading zeroes matter

• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.

Create a Tableau-ready copy

The conversion only changes the selected file format. Tableau calculated fields, extracts, and data types remain destination-side decisions.

1. 1Run CSV diagnosis on a copy of the source export
2. 2Select the real input encoding and separator from the preview
3. 3Convert to the encoding and delimiter used by the Tableau connection
4. 4Connect a small file and compare the first, middle, and last rows

Check the Tableau preview and refresh path

• Header names and field count match the connection
• Text containing commas, quotes, or newlines remains one field
• The row count matches the source after any intentional filtering
• The workbook refresh uses the same output file and encoding each time

• Convert the CSV encoding or delimiter →Set source and output formats explicitly and create a separate CSV.
• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.

If a worksheet still shows wrong values

Inspect Tableau's field type and calculated-field steps. A correct CSV cannot decide whether a date should be local time or UTC, or whether an ID is a measure.

• Diagnose CSV column counts and quoted fields →Review structural findings before changing a value or header.
• Check the CSV character encoding →Choose the source encoding from the preview instead of guessing from the country.
• Select the columns required by the template →Remove export-only fields while keeping all data rows.

Prepare the Tableau text file