Public: LocationIQ Batch geocoding sheet v1.2.1 (20230713)

	A	E	H
1
2		Step 1: Follow these steps to get 'Edit' access to the sheet	1. Go to the 'File' menu at the top left corner of the screen.
3			2. Select 'Make a copy' from the dropdown menu. (Functions won't work if you download it)
4			3. A Pop-Up box will notify that Apps Script file will be copied. This is required for the sheet to work
5			4. A copy of the template will be created in your Google Drive.
6			5. You can now edit and input coordinates/ addresses to your copy of the sheet
7	This sheet provides access to LocationIQ's forward and reverse geocoding API functions without the need for integration
8		Step 2: Follow these steps to activate the LocationIQ plugin	1. Make sure you have 'Edit' access to the sheet via Step 1
9			2. Select the "LocationIQ" tab from the top Menu - it takes a few seconds to show up and will appear after "Help".
10	Reverse Geocoding API		3. Select 'Settings' from the Drop-down
11	- Converts coordinates to addresses		4. Google sheets will ask for Authorization via a Pop-up. Select 'Continue'
12			5. Sign-in with your Google account and allow access. If there's a warning that "Google hasn’t verified this app", click 'Advanced' and "Go to LocationIQ (unsafe)"
13	Forward Geocoding API		6. Signup for an account with LocationIQ at www.locationiq.com & get your Access Token
14	- Converts an address string to coordinates		7. On the sheet, select 'Settings' from the Drop-down
15			8. Input your access token beside the 'API Key:' box
16
17	Important Links	Reverse Geocoding API	1. Switch to the sheet named 'Reverse Geocoding'
18	LocationIQ Website	Reverse Geocoding API	2. Paste Latitude in Column A and Longitude in Column B
19	LocationIQ Dashboard	Converts coordinates to an address string	3. Select the 'LocationIQ' tab from the Drop-down and choose 'Reverse Geocode'
20	LocationIQ Documentation
21	Reach out: hello@locationiq.com	Forward Geocoding API	1. Switch to the sheet named 'Forward Geocoding'
22		Forward Geocoding API	2. Paste the entire address in Column A
23		Converts an address string to coordinates	3. Recommend address format is <house_number>, <street>, <neighbourhood>, <city>, <state>, <country>, <postcode>
24			4. Select the 'LocationIQ' tab from the Drop-down and choose 'Geocode'
25
26		Note:
27		1. Making a copy ensures you have your own version, and any changes you make won't affect the original document. Any updates to the original document won't make it to your copy.
28		2. Google sheets has a limitation on the number of requests that can be processed - usually around 300 requests an hour. Details here: https://developers.google.com/sheets/api/limits
29		3. If a row requires reprocessing, delete the 'ok' under status column and run the process again.
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100