shapefile data to excel possible?

Question

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?

GISPRTSCR.gif

FilipKrál · Answer

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‌.

AlicePence · Answer

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.

IanMurray · Answer

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.