KNOWLEDGE BASE

Null Values Returned When Refreshing CSV Extracts


Published: 25 Oct 2016
Last Modified Date: 26 Oct 2016

Issue

When refreshing an extract based on a CSV file, valid data fields may be replaced with Null values. 

Environment

  • Tableau Desktop
  • CSV files containing unescaped strings

Resolution

Ensure any commas within strings are within quoted strings and not unquoted strings. This will ensure they are not read as a column separator. 
 

Cause

CSV files need to contain quotes around commas if the comma exists in the data and is not a field separator. They may also be required around other special characters.
Did this article resolve the issue?