When to Use Export to CSV

For the “out of memory” issue, which can happen when exporting large amounts of data with the Export to Excel option, it’s a factor of the amount of memory your computer has.

Try using the Export to CSV option, just below the export to Excel, instead for large data exports. It’s a much more efficient export, and still opens in Excel.