Large queries only export to CSV returning a non-usable format. | Community
Skip to main content

Large queries only export to CSV returning a non-usable format.

  • April 16, 2021
  • 2 replies
  • 0 views
J

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.

      2 replies

      E
      • Eugene13
      • April 21, 2021

      13085096527, 

      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:

       

      J
      • John79
      • Author
      • May 3, 2021

      Thanks, Eugene. That worked.

      Terms & ConditionsCookie settingsAccessibility statement