Knowledge Drop

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

  • 15 June 2021
  • 0 replies

Userlevel 5

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.


This content is subject to limited support.                



0 replies

Be the first to reply!