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 the 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, answering our various settings questions.

   

5. We will email you when your file is ready.

   

6. 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.