You can apply your data visualization's settings to data deliveries in the Format options section of the schedule or send dialog box.
Select Apply visualization options for your data delivery to appear similar to a table chart. Any of the following settings in the Plot, Series, and Formatting menus that are configured for the visualization will be applied:
- Show Row Numbers
- Hide Totals
- Hide Row Totals
- Limit Displayed Rows to a maximum of 500 rows shown or hidden
- Show Full Field Name
- Custom labels for each column (the JSON — Detail, Inline format always uses raw field names, not the field label — see the Change in JSON formatting Community post for more information about how Looker renders fields in JSON format)
- Conditional Formatting for deliveries of table chart visualizations in Excel format
Conditional formatting displays in Excel deliveries of Looks and Explores with table chart visualizations only if the Along a scale rule is applied.
Unselect Apply visualization options for Looker to send the data as it appears in the Data section of the Look or a dashboard tile's Explore from Here window. JSON — Label uses the field label, even if Apply visualization options is unselected.