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
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.
Character Encoding: UTF-8
Line Feed Code: CR+LF
Character Encoding: UTF-16.
Line Feed Code: LF
The possible workaround is converting a CSV file to the desired format after exporting or downloading by a text editor.
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.
Thank you for providing your feedback on the effectiveness of the article.