KNOWLEDGE BASE

CSV Format Is Different Between Export Data From Tableau Desktop and Download From Tableau Online


Published: 16 Nov 2020
Last Modified Date: 19 Nov 2020

Issue

Character encoding, delimiter, and line feed code are different as below when exporting data from the View Data window of Tableau Desktop to CSV and downloading Crosstab in CSV format from Tableau Online.
  • Tableau Desktop
    • Character Encoding:  UTF-8
    • Delimiter: Comma
    • Line Feed Code: CR+LF
  • Tableau Online
    • Character Encoding: UTF-16.
    • Delimiter: Tab
    • Line Feed Code: LF

Environment

  • Tableau Desktop
  • Tableau Online

Resolution

The possible workaround is converting a CSV file to the desired format after exporting or downloading by a text editor.

 

Cause

The ability to change character encoding, delimiter and line feed code when exporting or downloading data to CSV is not built in a product currently.
Did this article resolve the issue?