在线时间:8:00-16:00
迪恩网络APP
随时随地掌握行业动态
扫描二维码
关注迪恩网络微信公众号
开源软件名称(OpenSource Name):nuket/google-sheets-geocoding-macro开源软件地址(OpenSource Url):https://github.com/nuket/google-sheets-geocoding-macro开源编程语言(OpenSource Language):JavaScript 100.0%开源软件介绍(OpenSource Introduction):Google Sheets Geocoding MacroGeocode from addresses to latitude / longitude, and vice versa using Google Sheets. Test SheetTry the script out on a Test Sheet with sample address data. You can enter your own address data and geocode it in the rows below. You must be logged into a Google Account before the Geocode menu will appear. Any data you enter will be automatically deleted every Sunday at 4AM CEST, this isn't for long term storage. Multicolumn Addresses → Latitude, LongitudeNow it supports geocoding using address data spread across multiple columns. The way this works is: You select a set of columns containing the data, and the geocoding process puts the latitude, longitude data in the rightmost two columns. It will overwrite any data in those two columns. Some care is needed, as it will concatenate all columns except the rightmost two columns to create the address string. Latitude, Longitude → Nearest AddressIt also supports reverse geocoding. Simply select the latitude, longitude columns and it will place the nearest address data in the rightmost column. It will overwrite any data in that column. Less care is needed, as it will automatically use the leftmost two columns as the latitude, longitude pair. Latitude, Longitude → Address ComponentsIt now supports reverse geocoding and splitting the address components into different columns. See the Reverse To Components tab in the Test Sheet. Map CellsIt now supports mapping the Latitude, Longitude pairs in the Mapping tab. Adding It To Your Own SheetStep 1. Create or Open a Google Sheet and add addresses to it. Step 2. Tools -> Script Editor Step 3. Copy this script code into the Code.gs editor, replacing everything. Step 4. Save Step 5. Reload Sheet Step 6. Run Geocode, Click Through Warnings That's it. Troubleshooting
|
2023-10-27
2022-08-15
2022-08-17
2022-09-23
2022-08-13
请发表评论