Export Data in Planning Tables with Expanded Volume Limits

Export data from tables with as many as 1 million rows and 4,000 columns, subject to a maximum of 2 million cells. The Export Data in Format Specified in a Planning Table feature introduced in the 24A update is now enhanced to support increased volume limits. In addition, you can now export using either Microsoft Excel file format or CSV file format.

Export Data in Table Format page

Export Data in Table Format Page

Previously, the Export Data in Table Format function supported exporting tables with up to 65,536 rows and 256 columns. These limits have been extended to 1 million rows and 4,000 columns with a maximum of 2 million cells. For example, you can now export a table with any of the following combinations (all of which equate to 2 million cells.)

  • 1 million rows and 2 columns
  • 500,000 rows and 4 columns
  • 100,000 rows and 20 columns

This function has also been enhanced to support exporting in CSV (comma-separate values) format in addition to XLS (Microsoft Excel) format.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Microsoft XLS format has a limit of 256 columns and 65,536 rows per sheet. When exporting in XLS format:

  • The number of columns will be limited to 256.
  • If the table selected for export has more than 65,536 rows (but less than 1 million rows), then the output will be split into multiple sheets within the same Excel workbook with each sheet having 65,536 rows or less.
  • The resulting XLS file will include a macro that automatically runs the first time the file is opened. This macro will merge the multiple sheets into a single sheet and convert the file from an XLS format to an XLXS format.  Microsoft XLXS format has a limit of 1 million rows.

Key Resources

  • Export Data in Format Specified in a Planning Table (update 24A)

Access Requirements

There are no new roles or security privileges needed to access this feature.

  • Users who currently have access to open planning tables will automatically be able to use this feature.

Users who are assigned a configured job role that contains one or both of these privileges can access this feature:

  • Maintain Planning Tables (MSC_MAINTAIN_PLANNING_TABLES_PRIV)
  • View Planning Tables (MSC_VIEW_PLANNING_TABLES_PRIV)

These privileges were available prior to this update.