I am having issue with exporting data in excel from the look. I am using Looker version 4.14. When Looker exports data in excel following features don’t work All options setup in visulization, will not work Hide dimensions/measures appear in excel export View_label will appear in export eventhough its hidden in visulization Formated measures (like $ format) export as text not as numbers (so users can not do furher aggregation in Looker) This is really a major challange from our user side. Is there any work around or fix for this issue?

Question

Excel data export issue in Looker

Userlevel 2

I am having issue with exporting data in excel from the look. I am using Looker version 4.14.

When Looker exports data in excel following features don’t work

All options setup in visulization, will not work

Formated measures (like $ format) export as text not as numbers (so users can not do furher aggregation in Looker)

This is really a major challange from our user side. Is there any work around or fix for this issue?

Userlevel 3

Hi @kshah7,

For versions before Looker 4.16, it was possible to download the data in the data table, but not the data from the visualization settings.

As of 4.16 you can use the “apply visualization options”, discussed in more detail in the Looker 4.16 Release Notes.

Userlevel 2

Thanks Morgan it is really helpful and we will do upgrade in orer to use this feature.