Coming Soon! We’re launching a new sub-community within the Google Cloud Community dedicated to cloud security: The Google Cloud Security Community. In preparation for the launch, this site will be in read only mode from 22 September 12am PST - 23 September 7pm PST

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

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.

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 05:55 PM
Updated by: