nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Pro: Not all my fields in Excel sheet are showing up

KatherinePadilla

Hello,

I am trying to create a point feature class with an Excel spreadsheet in ArcGIS Pro. The trouble is it is only carrying over 255 of my fields where I have 522. How can I have ArcGIS Pro recognize all of my fields? When I right click on the sheet in the catalog, the field list only shows the first 255. So it is not the geoproccessing tools.

Find more posts tagged with

Accepted answers

GarrettSeay1

Did you use the Excel to Table tool? Excel To Table—Conversion toolbox | ArcGIS Desktop

Then just plot the points after it is in table format.

I used the Excel to Table and it looked like it pulled in all the columns from your sheet.

All comments

KatherinePadilla

Thank you Garrett! This worked well.

KatherinePadilla

This website states:

"If you have an .xlsx file you want to use in ArcGIS but do not have Excel 2007 installed, you will need to install the 2007 Office System Driver. It can be downloaded from the Microsoft Download Center. If you have Microsoft Excel 2010 or no version of Microsoft Excel installed, you must install the 2007 driver before you can use either .xls or .xlsx files."

This may be the issue for me I have Windows 10 using Excel 2016.

GarrettSeay1

Did you use the Excel to Table tool? Excel To Table—Conversion toolbox | ArcGIS Desktop

Then just plot the points after it is in table format.

I used the Excel to Table and it looked like it pulled in all the columns from your sheet.

KatherinePadilla

It is an .xlsx interesting since the documentation reads:

"ArcGIS supports both Excel 2003 and earlier .xls files and Excel 2007 .xlsx files. One advantage of Excel 2007 is that it allows much larger worksheets (1,048,576 rows by 16,384 columns) than you can have in Excel 2003 (65,536 rows by 256 columns)."

The behavior I am seeing is that of an .xls file.

I did a file save as and made sure it was an .xlsx file and tried again. Failed again.

There are 522 columns and 908 rows. See attached sheet.

CoastalDataUpload191105a.xlsx

GarrettSeay1

This may help as well: Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS Desktop

This discussing things to keep in mind when using excel in ArcGIS.

DanPatterson_Retired

what version of excel file?

Work with Microsoft Excel files in ArcGIS Pro—Excel | ArcGIS Desktop

.xls or .xlsx?

There are differ limits based on excel type

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.