Convert a Spreadsheet of Addresses to Coordinates

Select the address column in Excel or Google Sheets, copy it, and paste it straight into Batch Convert's text box. Spreadsheet software inserts a line break between cells automatically, so each address lands on its own line with no reformatting or column-mapping step. Run the conversion once, then use Download CSV to get a file with the original addresses plus a latitude and longitude column, ready to drop straight back into the same spreadsheet.

No API key, no account — just a 500-address limit per batch

There's nothing to sign up for and no API key to obtain first — paste the addresses and it runs. A franchise with 60 branches, a mailing list of a few hundred names, or a single test row of three addresses all work the same way. Each batch is capped at 500 addresses, shown as a running count while you type; a longer list just needs splitting into two or more batches, each exported and combined afterwards.

What "one per line" actually means

Each line in the box is treated as a single address to look up, so the safest paste is a single spreadsheet column with one full address per row — house number, street and town or postcode in the same cell works best. Splitting an address across several columns (number, street, city, postcode all separate) means combining them into one cell first, since Batch Convert reads each line as one complete address rather than reassembling several fields itself.