# Spreadsheet / CSV upload Geocoding Tutorial

## OpenCage Geocoding API Spreadsheet / CSV upload Tutorial

Tutorial for using the OpenCage Geocoding API in Spreadsheet / CSV upload - An API for reverse and forward geocoding using open geo data

You can upload spreadsheets or CSV files in [your account dashboard](https://opencagedata.com/dashboard#uploads) for us to geocode row by row.

#### Video Tutorial

Note: we also have [a video tutorial over on YouTube](https://www.youtube.com/watch?v=dxbPXHMWIlo) if you prefer.

Let's start

1. [Sign up for an OpenCage Geocoding API key](https://opencagedata.com/users/sign_up), or if you already have one [log in](https://opencagedata.com/users/sign_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](https://opencagedata.com/guides/how-to-prepare-your-spreadsheet-for-geocoding).

! [example of how to format your spreadsheet](https://assets.opencagedata.com/assets/uploads_ex1a-c05a50f01315631c9c05450dc959a82d81d39bb9b52daebcfe246be7ff6d6305.png)

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](https://opencagedata.com/pricing#geocoding-onetime).
4. 
**In your account dashboard upload your file.**

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

! [upload your spreadsheet](https://assets.opencagedata.com/assets/uploads_ex1b-5fa9d5a2700f17b70231fa25324e99890facc64505e376be7a4a8e11d42cda7f.png)

5. 
**Answering the settings questions.**

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

! [spreadsheet geocoding settings](https://assets.opencagedata.com/assets/uploads_ex2a-a5ff1994a1a26ed53b171af89d3c038e665f76c728cf8738f26c8c6aa86068ec.png)

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.

! [load preview](https://assets.opencagedata.com/assets/uploads_ex2b-e4427d7917150c8945f25405fe2bbfb03af22e7be43f0d6e2859c1a01e698106.png)

Click on "Load Preview"

! [preview loaded](https://assets.opencagedata.com/assets/uploads_ex2c-6f0b6609074518f787ae261cfa9a457f9ae950f4ef92d09deee7accb55e2ba36.png)

6. 
**We geocode your file.**

We will email you when your file is ready. Files for paying customers are given priority and processed more quickly than free trial accounts.

! [File has been geocoded](https://assets.opencagedata.com/assets/uploads_ex3a-7e5ea19f752c325936de29a2cd9c4317a5870cb8f398ef6da796f1d3e38b5b8d.png)

7. 
**Download your file.**

Uploaded spreadsheets or CSV files are automatically deleted after:

  - 3 days for free trial users
  - 30 days for paying customers

You can also delete your files manually whenever you like.

### Further Reading

- [OpenCage geocoding API Reference](https://opencagedata.com/api)
- [Comparing geocoding services](https://opencagedata.com/guides/how-to-compare-and-test-geocoding-services)
- [Cleaning / formatting your forward geocoding query](https://opencagedata.com/guides/how-to-format-your-geocoding-query)
- [Geocoding more quickly](https://opencagedata.com/guides/how-to-geocode-more-quickly)
- [Geocoding large datasets](https://opencagedata.com/guides/how-to-geocode-large-datasets)
- [Geocoding and preserving privacy](https://opencagedata.com/guides/how-to-preserve-privacy-by-showing-only-an-imprecise-location)
- [Sample address and coordinate lists for testing](https://opencagedata.com/tools/address-lists)