My goal is to use this method of using google sheets with ArcGIS online to update my web map automatically with new points which are added to the google sheet csv.

My problem is according to this document, coordinates have to be in decimal degrees. The points I want to bring in are surveyed in state plane northing and easting. It would defeat the purpose of updating it automatically if I have to create a shapefile out of the csv first in order to get decimal degrees fields.


I would try to find a formula to calculate decimal coordinates in google sheet idea

I am not sure if it works but you can try

| improve this answer | |
  • I'm having a hard time finding formulas, do you know of any resources? – Chris Jan 10 '17 at 15:49
  • 1
    there is some recource about this subject with spread sheet added: uwgb.edu/dutchs/UsefulData/UTMFormulas.HTM It is not that simple as I showed in the picture :) – ArisA Jan 10 '17 at 15:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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