Large queries only export to CSV returning a non-usable format.
I'm only given the option to export a large query as CSV which combines all the data in my query into a single cell.
We'd need to be able to export to XLS to make the actual data usable.
Thank you for posting about this issue.
We don't have plans to include XLS as the export format for large queries. Creating Excel exports consumes much more computing power that's why extending the Excel export limit to 500K rows is not a sustainable option at this stage.
However, the problem that you are experiencing with the CSV files is probably because you are not using comma as the delimiter for the CSV files. Most of the spreadsheet tool use comma as the default delimiter.
You can update the delimiter in the Admin section of Explore:
Thanks, Eugene. That worked.
Please sign in to leave a comment.