topic Re: Excel to ArcGIS in Training in GIS Questions

Excel to ArcGIS

AzaN — Thu, 07 Apr 2016 18:49:22 GMT

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

Re: Excel to ArcGIS

AdrianWelsh — Thu, 07 Apr 2016 19:34:22 GMT

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

Re: Excel to ArcGIS

DanPatterson_Retired — Thu, 07 Apr 2016 19:42:57 GMT

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

Re: Excel to ArcGIS

RonFisher — Thu, 07 Apr 2016 20:06:37 GMT

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

Re: Excel to ArcGIS

AzaN — Fri, 08 Apr 2016 14:48:44 GMT

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

Re: Excel to ArcGIS

AdrianWelsh — Fri, 08 Apr 2016 14:52:54 GMT

Great! I am glad this helped!