If you have addresses in a spreadsheet or database client, you can skip the file export step entirely. The Geocodio upload tool accepts tab-separated data directly from the clipboard. Select your rows, copy, and paste them in.

Where does copy & paste work?

When you select and copy rows from most spreadsheet and database tools, the data is placed on your clipboard as tab-separated text. This is exactly what the Geocodio upload tool expects. Copy & paste works with:

• Microsoft Excel

• Google Sheets

• Apple Numbers

• Database clients such as TablePlus, pgAdmin, DBeaver, and DataGrip

• Any other tool that copies tabular data as tab-separated values

How to copy & paste your data

1. In your spreadsheet or database client, select the rows you want to geocode. Make sure to include the header row.

2. Copy your selection (Ctrl+C on Windows, Cmd+C on Mac).

3. Go to geocod.io/upload and click "Copy & Paste a List".

4. Give your list a name (this is how it will appear in your Geocodio dashboard).

5. Click inside the text area and paste (Ctrl+V on Windows, Cmd+V on Mac).

6. Check the "My first row contains headers" checkbox.

7. Click Continue to proceed to column mapping, where you tell Geocodio which columns contain your address data.

Example: Copying from Google Sheets or Excel

Say you have a spreadsheet with a list of store locations:

Select all the rows including the header, copy, and paste them into the Geocodio upload tool. The tab characters between each column are preserved automatically, so no extra formatting is needed.

Example: Copying from a database client

Most database clients let you select rows from a query result and copy them. For example, after running a query like:

SELECT name, street, city, state, zip FROM locations LIMIT 100;

Select the result rows (including column headers), copy, and paste directly into the Geocodio upload tool. Tools like TablePlus, pgAdmin, DBeaver, and DataGrip all copy results as tab-separated data by default.

Formatting tips

• Always include a header row. The header tells Geocodio what each column contains. You can name the columns anything you like. During the next step, you will map them to address fields.

• The same formatting rules as file uploads apply. See the Spreadsheet formatting guide for details on single-column vs. multiple-column formats, accepted address combinations, and country handling.

• Extra columns are preserved. Geocodio only adds columns to your data and never removes them. If your data includes columns like "name" or "type", they will be included in the results.