Enrichments /
No-Code Enrichment with
How To Use the Geocode.xyz API for Forward Geocoding an Address into Latitude and Longitude Coordinates
Sign Up Free

Use Geocode.xyz API for Forward Geocoding

Geocode.xyz API can help with Geocoding, Reverse Geocoding, and Geoparsing. The geocoding, or forward geocoding API accepts an address as an input and returns a set of latitude and longitude coordinates. This frictionless access to accurate geographic data allows you to bring more understanding to your data in Gigasheet. 

geocode.xyz api

Provider Website: https://geocode.xyz/api

Provider Enrichment Docs: https://geocode.xyz/api

Endpoint: curl 'https://geocode.xyz/Hauptstr.,+57632+Berzhausen?json=1&auth=your_api_key'

Token / Registration Required: Yes

How To Enrich A Spreadsheet With Geocode.xyz API for Forward Geocoding:

For this example, my data looks like this. It is a list of restaurant locations with address information.

Data for orgeocode.xyz api for forward geocoding

Step 1. In Gigasheet, head to the Enrichments function and select Custom Enrichment. First we paste in the HTTP request for forward geocoding from geocode.xyz..

geocode.xyz api for forward geocoding cURL request

Step 2. On the next screen we’ll insert the column variable from our Gigasheet sheet for the prompt. In this case, we highlight the address, “Hauptstr.,+57632+Berzhausen”, in the input, and then select our Address column and click +Insert Column Reference. We also need to highlight the “your_api_key” and paste our real key from Geocode.xyz API. Then click Next.

Customizing the request for geocode.xyz api for forward geocoding

Ready to run the geocode.xyz api for forward geocoding in Gigasheet

Step 3. In this screen we see a preview of the results. Gigasheet makes requests for the first three rows and shows the geocode.xyz response. At this point select the fields you want to be inserted into your sheet. We recommend hitting Select All since you can easily delete columns in Gigasheet.

Preview results for geocode.xyz api for forward geocoding

Step 4. Finally, confirm the number of requests is to your liking, and when ready click Run to kickoff the custom enrichment process. It’s ok to leave or close the sheet; the custom enrichment will keep running and you’ll receive an email once the job has been completed. You can monitor the progress of your enrichment, or cancel the job at the top of the sheet. 

Confirm execution of geocode.xyz api for forward geocoding

Step 5. Once completed, Gigasheet will send a completion toast and refresh the page. The result will show generation of new columns based on the Geocode.xyz API for Forward Geocodinging. A latitude and longitude has been added for each address in the sheet.. 

Enriched data from geocode.xyz api for forward geocoding

Try it Out

The ease of a spreadsheet with the power of a data warehouse.

No Code
No Database
No Training
Sign Up, Free Forever