Excel to ArcGIS

[AzaN]

Hi,

I have imported and added data from Excel spreadsheet to ArcGIS 10. But when I right click on the data, attribute table  is blank. It shows that there exits 22223 records but doesn't show them (as below screen shot shows). Can anyone help me with that please? By the way, I have tried to replace all spaces with underscore, but nothing changed.

Thanks, Azadeh

[AdrianWelsh · Accepted solution]

Hi Aza,

A couple of questions. Which ArcGIS 10 are you using? Is it 10.0? Or higher? Also, how did you import this excel sheet? Did you do it through the Add Data button? Was it a drag and drop? Or did you use the Excel to Table tool? Excel To Table—Help | ArcGIS for Desktop

In any case, here is an article on using Excel in ArcGIS:

Understanding how to use Microsoft Excel files in ArcGIS—Help | ArcGIS for Desktop

[AzaN]

Hi Adrian,

Thanks for your help. It worked for me. I use ArcGIS 10.3.1 and I had used Add Data button. As you recommended, I tried Excel to Table tool and it worked very well.

Thanks again,

Aza

[AdrianWelsh]

Great! I am glad this helped!

[DanPatterson_Retired]

Adrian has good examples of where things can go wrong.

fix the spreadsheet first

ensure that each column in the spreadsheet contains one and only one type of data

do not use blanks as null values...be more clever

those column headings are ridiculous, make them simpler and document your workflow if you need to keep track

no space in the filename, the fields, the paths to the data etc.

lastly... don't use a spreadsheet as a database program unless you are forced to

[RonFisher]

Try saving it as a Excel 97-2003 Workbook (*.xls) and import that.