Excel capabilities in the Advanced Database Editor (ADE)

In the Advanced Database Editor (ADE), you can export data to Excel and import data from Excel. ADE is compatible with both XLS and XLSX files; however, a maximum of 256 ADE columns can be exported into one XLS spreadsheet. The Multiple Table View feature can help with this limitation. The newer XLSX files do not have this restriction.

Notes: Throughout the documentation, the file extension .xlsx is used. Please note that .xls is also applicable.

The default option for Excel Export/Import is the XLSX format (supported by Microsoft Office 2007 and up). The XLS format is supported for backward compatibility.