Is it possible, that there is an error/fault when importing *.csv files when a return (\r) or newline character (\n) (line breaks) are included? I always get a error when uploading *.csv files to Looker Studio, except when I first run a Phyton Script over my file which removes the carriage return (\r) and newline character (\n).
Information: double-quotes are used to enclose fields in the *.csv file according https://datatracker.ietf.org/doc/html/rfc4180#section-2
Python Script:
rows = [
[field.replace('\n', '').replace('\r', '') for field in row]
for row in reader
] # Remove newline characters from each field
LinkedIn
Twitter
