Why is Looker adding apostrophes to my data in CSV downloads?

[LookerExperts]

Knowledge Drop

Last tested: Oct 25, 2018
 

Check the General Settings Page for the Block Formulas and Macros in CSV Files toggle.

If fields start with the following special characters, then this feature will snap into action!

=, -, +, or @

>When this is enabled, Looker will add a 'character to any cell value that begins with a special character (=, -, +, or @) when generating a CSV file. This disables all macros in Looker-generated CSV files.

https://docs.looker.com/admin-options/tutorials/managing-bizusers/bizuser-features#preventing_inject...

This content is subject to limited support.