-3

I am unable to export the table using "Conversion tool : table to excel". It shows error

"Error 001530 : Input table exceeds the 256 columnlimit of the .xls file format"

I tried all solutions but no help.

  • 2
    It sounds like an Excel limit for column width, see support.office.com/en-us/article/… . Excel cells must contain strings less than 255 characters with a null terminator. What is your goal here? Excel just isn't going to work, perhaps if you can reveal more of your workflow we could suggest alternative workflows. – Michael Stimson May 23 '17 at 23:31
  • @MichaelMiles-Stimson I want to perform join operation between a layer with geospatial data and a table. The output of that join operation is a table that I need to export in excel format. Is there a way I can know which value is causing this error? – aditya May 23 '17 at 23:35
  • You will need to truncate your string fields. Are you sure you need excel? Microsoft (JET) Access databases can store a HUGE amount of data in a cell support.office.com/en-us/article/… . A good workflow would be to join and export to personal geodatabase then use Microsoft Access to export to excel which should truncate the fields for you; if you want to do this automatically you will need to script in python or ArcObjects. – Michael Stimson May 23 '17 at 23:40
  • 1
    If you want to trim down your fields use a field mapping object resources.arcgis.com/en/help/main/10.2/index.html#//… to hide some fields before trying to export. – Michael Stimson May 24 '17 at 0:50
  • 1
    The error message doesn't mention character limits, it says column limit. @aditya, how many columns are in the Excel worksheet you are trying to access? If the answer is greater than 256, there's your answer. – Bjorn May 24 '17 at 3:15
3

001530: Input table exceeds the 256 columns limit of the .xls file format

This error is quite clear. You are trying to export to Excel a table that has more than 256 columns. Excel .xls format can only take a maximum of 256 columns (fields).

001530: Input table exceeds the 256 columns limit of the .xls file format.

Description

The Microsoft Excel 97–2003 Workbook (.xls) format has a limit of 256 columns.

Solution

If not all fields are necessary, a subset of fields can be made unavailable in an intermediate table view or feature layer by using the Field Info control's visible property in the Make Table View or Make Feature Layer tools.

From Error 001530 Help page

Alternatively, export to a different table format that doesn't have this limitation.

Not the answer you're looking for? Browse other questions tagged or ask your own question.