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

The maximum amount of data you can import to Excel is approximately:

• Licensed activity:  10,000,000 rows spread across ten worksheets. 

• Unlicensed activity: 1,000,000 rows on a single worksheet.

  (Approximately, because the maximum size per sheet is actually based on number of cells, not rows.)

*If you are being limited to fewer than your maximum, check Preferences -> Import to see if your settings are set for a lower threshhold. 

If you are trying to access more than the 1,000,000 or 10,000,000 rows limit, 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.