Downloading 2 million rows in excel format

Looker Q&A Looker
, ,
1

I’m trying to download all the data in Excel format, but the dataset has more than 2 million rows.

The issue is that when I attempt to download, our server hangs, and the browser keeps scrolling, indicating that the data is being prepared. As far as I know, Excel has a row limit of 1,048,576, so why is Looker continuously processing and keeping the server busy?

Is there an option to halt the process if the number of exported rows exceeds the row limit supported by the destination format?

2

I’m pretty sure there’s no option for that, but that’s a reasonable feature request! I think that the Excel download option is just not that sophisticated. (After all, it still exports as a csv format rather than a native excel format.)