Select to view content in your preferred language

Table to Excel Row Limitation

1119
2
Jump to solution
08-20-2024 08:09 AM
MariusVerdes
Frequent Contributor

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

0 Kudos
2 Solutions

Accepted Solutions
Brian_McLeer
Frequent Contributor

@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. 

 

Brian_McLeer_0-1724168707957.png

The output folder shows that it supports XLS or XLSX

Brian_McLeer_1-1724168745002.png

 

Brian

View solution in original post

ChrisUnderwood
Esri Regular Contributor

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."

View solution in original post

2 Replies
Brian_McLeer
Frequent Contributor

@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. 

 

Brian_McLeer_0-1724168707957.png

The output folder shows that it supports XLS or XLSX

Brian_McLeer_1-1724168745002.png

 

Brian
ChrisUnderwood
Esri Regular Contributor

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."