topic Table to Excel Row Limitation in ArcGIS Pro Questions

Table to Excel Row Limitation

MariusVerdes — Tue, 20 Aug 2024 15:09:57 GMT

Hi everyone,

I'm sorry if this question has already been answered but I didn't find anything on this topic.

Does anyone know if Esri is planning to move from xls to xlsx in the Table to Excel geoprocessing tool? The 65535 rows and 256 columns limit is annoying sometimes.

Also, on the Portal, you can export to xlsx format which offers bigger limits.

Thanks

Re: Table to Excel Row Limitation

Brian_McLeer — Wed, 21 Aug 2024 17:30:59 GMT

@MariusVerdes It looks like if you type the .xlsx extension at the end of the file name in the GP tool you can get the xlsx file format.

The output folder shows that it supports XLS or XLSX

Re: Table to Excel Row Limitation

ChrisUnderwood — Tue, 27 Aug 2024 16:26:31 GMT

And confirmation from the Help page for that tool.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/table-to-excel.htm

"The extension of the output file controls the output Excel format" and "Specify the format of the Excel file using the .xls or .xlsx file extension."