topic Re: shapefile data to excel possible? in Data Management Questions

shapefile data to excel possible?

AlinaMadita — Wed, 30 Jul 2014 16:09:54 GMT

Hello,

It is me again asking (Hopefully) an easy question.

I had 5 points from which I constructed a line. I deleted all of the initial points besides the first and last and constructed 46 points on this line.

I need the GPS data from these 48 points (which are one shapefile) preferaply in a format so that I can copy and paste it into an excel sheet.

I thought it might easily be possible by copy or save the attribute table, but this only shows 0 for the lat and long value for the constructed points (see attachment).

Is there an easy way around this?

Re: shapefile data to excel possible?

JoeBorgione — Wed, 30 Jul 2014 16:34:00 GMT

All those points that are valued 0 cross the board are in your feature class/shape file, right? If so right click on the field heading/name and select Calculate Geometry. Choose the appropriate units and you'll be good to go.

Re: shapefile data to excel possible?

JimCousins — Wed, 30 Jul 2014 18:36:11 GMT

If you open the ArcToolbox, and go to Conversion Tools >> Excel, you can use the tool "Table to Excel".

For adding xy, there is also a tool - Data Management Tools >> Features >> Add XY Coordinates

Regards,

Jim

Re: shapefile data to excel possible?

IanMurray — Wed, 30 Jul 2014 18:51:37 GMT

also, if you make a copy of the dbf file from your shapefile on your harddisk, excel should be able to open your attribute table as a table. If that doesn't work, you can always change the extension of the copy dbf you made to a .xls(old excel file format) and excel should be able to open it that way.

Re: shapefile data to excel possible?

AlicePence — Wed, 30 Jul 2014 19:46:12 GMT

Try the calculate geometry trick as mentioned earlier to get your lat/long's then to export the table >> open up the attribute table click on "table options" (the first one on the left at the top) >> go down to "Export" >>click on the folder symbol >> find a place to save it (I usually just do desktop or any folder really) >> click on the drop down box next to 'Save as Type' and pick Text file >> name the file >> Save >> Ok

Go to your desktop >> open up the text file and it should default opening it up to Excel. Or open excel and open the text file within Excel.

Re: shapefile data to excel possible?

FilipKrál — Mon, 08 Sep 2014 21:02:47 GMT

Yes, the way Alice Pence‌ described is one of the easiest. It sounds complicated but once you have done it couple of times it will become pretty natural.

Jim Cousins‌ has a great suggestion too, just remember that you can easily locate any tool if you use the search window‌.