How do I hide empty rows and columns in google sheets export?

Hi @cayleyb,

It works on my side when saving a view in a Table block using the “hide empty rows and columns” option.

Can you share some details on your source and Gsheet ?

@cayleyb Yes with the GSheet connector. It works when clicking “load view” .

Sorry to ask, but are you using a table and selecting the correct view ?

Hi @cayleyb,

I had this issue recently and logged a ticket to the support, @Maxim Kudashkin feel free to jump in if I forget something.

Unfortunately, if you’re using “Hide Empty Row” in a table and export to GSheet you will still see blank rows. This is because GSheet evaluates tables as a single object instead of doing the export metric by metric and thus hiding the rows.

To illustrate this behavior, here is a quick example, where I have 3 basic metrics by year:

• Metric A is populated for the 4 years
• Metric B is populated only for 2 years
• Metric C isn’t populated at all

In the table, I get the expected result with 6 rows. However, during the export I have all the possible combination even the blank ones. This is because of the way tables are evaluated during the export, in my example, because Metric A has data for FY25, Metric B and Metric C will still show up during the export.

Please note that this won’t happen if you export a metric.