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.

1 Answer 1


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

  • I'm having a hard time finding formulas, do you know of any resources?
    – Chris
    Jan 10, 2017 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, 2017 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.