Spreedsheet / CSV upload Geocoding Tutorial

You can upload spreadsheets or CSV files in your account dashboard for us to geocode row by row.

Let's start

1. Sign up for an OpenCage Geocoding API key, or if you already have one log in.
2. Format your file correctly.

   Ideally put the entire address (including the country name) in a column named address.

   Please see our detailed guide to formatting your file.

   

3. Make sure you understand the file size limits.
   • Free trial accounts can geocode spreadsheets of up to 100 rows.
   • Subscription customers can geocode spreadsheets up to 10,000 rows.
   • One-time customers can geocode spreadsheets up to the number of requests they have remaining or 10,000 rows.
   • We will stop geocoding once you hit your limit.
   If you need more please purchase the appropriate plan.
4. In your account dashboard upload your file.

   We support the following file types: .csv, .ods, .tsv, .txt, .xls, .xlsx

   

5. Answering the settings questions.

   Help us understand your file and what information you need from us.

   

   At the end we will ask you to preview your file to make sure we can geocode it and that it has the fields you need.

   

   Click on "Load Preview"

   

6. We geocode your file.

   We will email you when your file is ready.

   

7. Download your file.

   Uploaded spreadsheets or CSV files are automatically deleted after:

   • 7 days for free trial users
   • 90 days for paying customers

   You can also delete your files manually whenever you like.