What is the maximum amount of data I can import to Excel?

The maximum amount of data you can import to Excel is approximately 5,000,000 rows spread across five worksheets.  (Approximately, because the maximum size per sheet is actually based on number of cells, not rows.)

If you are trying to access more than 5,000,000 rows, you cannot import them all at once into Excel.  Instead, you can download your data directly to a data file, bypassing Excel.  You can save to csv or .BIG formats.  The benefits of saving to .BIG are:

• .BIG files can be opened, no matter how large, directly in the free Exponam Explorer (or with any other Exponam .BIG technologies – APIs, CLIs, JDBC)
• .BIG files are highly compressed, may be secured, are immutable, and contain detailed provenance information
• .BIG files are an excellent option for securely storing and distributing data sets to people both within and outside of your organization.