Free Batch Geocoding: How to Geocode a CSV File in 5 Minutes
You have a spreadsheet full of addresses and you need latitude and longitude coordinates for each one. Maybe you are working on a logistics project, mapping customer locations, or preparing data for a GIS analysis. Whatever the reason, converting hundreds or thousands of addresses one by one is not practical. That is where batch geocoding comes in.
In this guide, I will show you exactly how to batch geocode a CSV file for free using CSV2GEO. The entire process takes less than five minutes, regardless of how many addresses you have.
What is Batch Geocoding?
Batch geocoding is the process of converting multiple street addresses into geographic coordinates (latitude and longitude) in a single operation. Instead of typing addresses one at a time into Google Maps and writing down coordinates, you upload a file with all your addresses and get back the same file enriched with lat/long columns.
The output preserves all your original data. We add columns for latitude, longitude, and a relevance score so you know how accurate each match is. A score of 1.0 means rooftop accuracy, which is the highest possible quality.
Why Geocode a CSV File?
CSV and Excel files are the most common format for storing address data. Whether your data comes from a CRM export, a government database, or a simple spreadsheet you built yourself, chances are it is in CSV or Excel format. Here are the most common use cases we see:
- Real estate professionals mapping property listings across a region
- Logistics companies optimizing delivery routes from customer addresses
- Marketing teams segmenting customers by geographic location
- Researchers analyzing spatial patterns in survey data
- Insurance companies assessing risk by property coordinates
- Government agencies mapping public infrastructure and services
All of these start with the same step: take a list of addresses and convert them to coordinates.
How to Batch Geocode a CSV File for Free (Step by Step)
Here is the complete process using CSV2GEO. You can geocode up to 100 addresses per day completely free, no credit card required.
Step 1: Prepare Your CSV File
Your file should have address data separated into columns. The more structured your data, the better the results. Here is an example of a well-formatted input:
Name, Street Number, Street, City, State, Zip, Country
Metropolitan Museum of Art, 1000, 5th Ave, New York, NY, 10028, US
Art Institute of Chicago, 111, S Michigan Ave, Chicago, IL, 60603, US
National WWII Museum, 945, Magazine St, New Orleans, LA, 70130, US
Pro tip: If your addresses are all in one column (like "1000 5th Ave, New York, NY 10028"), that works too. CSV2GEO is smart enough to parse combined address strings. However, splitting them into separate columns gives you the best accuracy.
Step 2: Upload Your File
Go to csv2geo.com and drag your CSV or Excel file onto the upload area. You can also click to browse and select the file from your computer. The system accepts .csv, .xlsx, and .tsv file formats.
Step 3: Map Your Columns
After uploading, CSV2GEO displays the first ten rows of your data in a grid. The system uses an AI module to automatically detect which columns contain street numbers, street names, cities, states, zip codes, and country information.
Review the auto-detected mappings. If a column is not detected correctly, click on the column header and select the correct address token from the dropdown. You can assign multiple columns to a single address component, or leave columns unmapped if they contain non-address data.
Important: If your first row contains headers (column names), make sure the "First row is header" checkbox is checked. This prevents the system from trying to geocode your column names as an address.
Step 4: Preview the First Ten Rows
Click the Process Data button. The system geocodes only the first ten rows and shows you a preview of the results. This is your chance to verify everything looks correct before processing the entire file.
In the preview, you will see your original data plus new columns for latitude, longitude, and the structured address components. Check that the coordinates make sense. A relevance score of 1.0 means rooftop-level match. Anything above 0.8 is generally very good.
You will also see a map with markers for each geocoded address. This gives you a quick visual check that the coordinates land where you expect them.
Step 5: Process All Data and Download
If the preview looks good, click Get All Data. For files with 100 rows or fewer, processing is free. The system will process all your addresses and notify you by email when the results are ready.
Your geocoded file is available for download in your My Tasks area. Click the download button to get a CSV file with all your original data plus the geocoded coordinates.
What You Get in the Output File
The output file preserves every column from your original input. After your last column, CSV2GEO appends:
- Latitude — decimal degrees (WGS84 standard)
- Longitude — decimal degrees (WGS84 standard)
- Input Address — the address string that was sent for geocoding
- House Number — parsed street number
- Street — parsed street name
- City — parsed city
- State — parsed state/province
- Postcode — parsed zip/postal code
- Country — parsed country
- Formatted Address — full structured address, comma separated
- Relevance — match quality score from 0 to 1.0 (1.0 = rooftop accuracy)
One useful feature: even if your original data does not include zip codes, the system returns them. When you pass an address to get lat and long back, you get the full parsed address structure as a bonus.
Batch Geocoding vs Single Address Lookup
If you only need coordinates for one or two addresses, you can use our free single address geocoder or even Google Maps. But the moment you have more than five addresses, batch geocoding saves massive amounts of time.
Here is the comparison:
Single address geocoding: Type one address, get one result. Repeat for every address. Works for 1-5 addresses.
Batch geocoding: Upload a file with 10, 1,000, or 100,000+ addresses. Get all results at once in a single download. Works for any volume.
CSV2GEO handles files with hundreds of thousands of rows. For very large files (100K+ addresses), the processing happens in the background and you receive an email when your data is ready.
Free vs Paid Batch Geocoding
CSV2GEO gives you 100 free geocoded rows per day. No account setup, no credit card. Just upload and geocode. For larger volumes, we offer pay-as-you-go and monthly subscription plans that bring the per-row cost down significantly.
Here is how it breaks down:
- Free tier: Up to 100 rows per day, no cost
- Pay-as-you-go: For one-time larger jobs, pay per row
- Monthly subscription: Best rate for recurring geocoding needs
- API access: For developers who want to integrate geocoding into their applications
You can check all plan details on our batch geocoding page.
Tips for the Best Geocoding Results
- Use UTF-8 encoding for your CSV files to ensure special characters are handled correctly
- Separate address components into individual columns when possible (street, city, state, zip)
- Always include the country, especially if your addresses span multiple countries
- Check the first ten rows preview before processing the full file
- If your data comes from a CRM export, verify that all rows have the same number of columns
For more detailed tips, read our guide on 5+1 Tips for Quick and Easy Geocoding.
Frequently Asked Questions
What file formats does CSV2GEO accept?
CSV2GEO accepts .csv, .xlsx (Excel), and .tsv files. For CSV files, the system automatically detects your delimiter (comma, semicolon, tab).
How many addresses can I geocode for free?
You can geocode up to 100 addresses per day for free. There is no credit card required and no account needed to start.
How accurate is the geocoding?
CSV2GEO uses rooftop-level geocoding for maximum accuracy. The relevance score in the output tells you the match quality. A score of 1.0 means the coordinates point to the exact building. We cover over 461 million addresses across 39 countries.
Can I geocode addresses from any country?
Yes. CSV2GEO covers 39 countries worldwide, including the United States, Canada, United Kingdom, Germany, France, Brazil, Australia, and many more. The top coverage areas are USA (121M addresses), Brazil (90M), Mexico (30M), France (26M), and Italy (26M).
What is the difference between forward and reverse geocoding?
Forward geocoding converts addresses to coordinates (lat/long). Reverse geocoding converts coordinates to addresses. CSV2GEO supports both. This article covers forward geocoding. For reverse geocoding, see our reverse geocoding tool.
Do I need an account to use CSV2GEO?
You can start uploading and previewing results without an account. To download the full geocoded file, you will need to create a free account.
Start Geocoding Your Data Now
Ready to convert your addresses to coordinates? Upload your CSV file now and get started in seconds. The first 100 rows are free every day.
If you have questions or need help with your data, visit our Help page or contact us directly. You can also use the chat on any page of the CSV2GEO website.
I.A.
CSV2GEO Creator
Use our batch geocoding tool to convert thousands of addresses to coordinates in minutes. Start with 100 free addresses.
Try Batch Geocoding Free →