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.

    example of how to format your spreadsheet

  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.

    example of uploading your spreadsheet

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

    example of the email we send you once your file is geocoded

Start your free trial

2,500 geocoding API requests per day.

No credit card required.