0

I'm trying to input this data into ArcGIS and plot coordinates like this:

00⁰06.743 031⁰36.970 (coordinates south / coordinates east)

but I've failed so far and I was wondering if someone could tell me how to do this

I've tried to convert these coordinates with http://geoinfo.sdsu.edu/hightech/LM3/dd1.php or GPSvisualizer.com but they only allow you to convert 1 by 1 (I've got about 700 to convert, all saved into Excel spreadsheets)

So I'm hoping for a conversion tool where you can enter a complete spreadsheet at once and get it converted

3
  • Welcome to GIS SE! Would you be able to edit your question to clarify whether you mean ArcGIS for Desktop or ArcGIS Online when you say ArcGIS, please? Also, what do your spreadsheet rows look like e.g. do you include the degree symbols?
    – PolyGeo
    Mar 12, 2015 at 8:31
  • A small sample from your spreadsheet for us to download would help about 1000% here.
    – Spacedman
    Mar 12, 2015 at 9:45
  • Also asked on GeoNet. Stuart had a better answer then I did--was there something unclear about this directions?
    – mkennedy
    Mar 12, 2015 at 16:03

1 Answer 1

1

In your spreadsheet, you should first convert your coordinates into decimal degrees

degree + minutes / 60 (+ second/3600, but you don't have seconds)

from the text string(assuming excel recognize your dot as a decimal separator), it would be

=LEFT(A1;SEARCH("°";A1)-1)+ RIGHT(A1;LEN(A1)-SEARCH("°";A1))/60

Because you are South and East, you also need to change the sign (negative values needed)

Then you can add your spreadsheet in ArcMap, create an XY event and it will be projected on the fly in the coordinate system of the dataframe. (just check if you need to specify the transformation in case your datum are different).

Finally, if you need the coordinates, you can use the calculate geometry tool.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.