How to Plot Addresses on Google Maps from a Spreadsheet (Free, No Coding)

If you have a list of addresses in a spreadsheet and want to see them on a map, there are three common paths: export a CSV and import it into Google My Maps, build something with the Google Maps API, or use a Google Sheets add-on that does it directly. The first is slow and breaks above 200 rows. The second requires code. The third takes under 5 minutes.

This guide covers how to plot addresses on Google Maps from a spreadsheet. Google Sheets or an Excel file, without uploading CSV files, without a Google Maps API key, and without touching any code.

Method 1: Google Sheets Add-On (Fastest — Under 5 Minutes)

This is the method most people end up using after trying the others. You stay inside Google Sheets the entire time, no file exports, no external tools.

1. Open Google Sheets and paste your address data. Each address should be in its own row. Columns can be split (Street, City, State, ZIP) or combined in a single field, either works.

2. Rename the sheet tab so it starts with 'layer_', for example 'layer_Customers' or 'layer_Locations'. This tells InstaMaps which tabs contain map data.

3. Install the InstaMaps add-on from Google Workspace Marketplace (free, one-time install).

4. Open the add-on from the Extensions menu and click Load Map. AI scans your column headers and detects the address fields automatically.

5. Your addresses appear as map markers on Google Maps inside the add-on panel. Filter by any column, zoom into a region, or click a marker to see the full row data.

Method 2: Google My Maps (Free But Limited)

Google My Maps lets you import a CSV or spreadsheet and plot the rows as map pins. It works for small datasets and is built into Google's ecosystem, but it has hard limits that make it impractical for most business use.

The import cap is 2,000 rows per layer and 10 layers per map, so effectively 20,000 pins maximum, but in practice performance degrades noticeably above 500 rows. There is no live filtering: to show only accounts in a specific region or owned by a specific rep, you have to create separate CSV files per segment and import them as separate layers manually.

For a one-time visualization of a small list, under 200 addresses. Google My Maps is fine. For anything that needs to update regularly or needs column-based filtering, it becomes a manual maintenance problem quickly.

Method 3: Google Maps JavaScript API (Flexible But Requires Code)

The Google Maps JavaScript API lets you geocode addresses and plot markers programmatically. You have full control over styling, clustering, info windows, and interactivity. It is the right choice for building a customer-facing map product or an internal tool with specific UX requirements.

The cost: you need a Google Cloud account, a billing-enabled project, and an API key. The Maps JavaScript API and Geocoding API are both billed per request. Geocoding costs $5 per 1,000 requests, a dataset of 10,000 addresses costs $50 to geocode. You also need to write JavaScript to read your spreadsheet data, geocode each address, and render markers.

If you can code and need a custom solution, this is the right path. If you want your addresses on a map without writing code, it is significant overhead for what is essentially a visualization task.

What Address Formats Work

InstaMaps AI address detection handles the most common spreadsheet address structures without any manual column mapping.

1. Split columns: separate Street, City, State, and ZIP columns, the most common Salesforce export format

2. Billing address columns: Billing Street, Billing City, Billing State, Billing Postal Code, detected automatically from Salesforce report headers

3. Single combined column: a full address in one cell (e.g. '123 Main St, Boston, MA 02101')

4. Lat/lng columns: if your spreadsheet already has latitude and longitude, those are used directly and geocoding is skipped entirely

5. City and state only: works for broad territory visualization when full street addresses are not available

If Your Data Is in Salesforce

Salesforce users can skip the copy-paste step entirely. Any Salesforce report with account addresses can be exported directly to Google Sheets, no CSV file involved.

In the Salesforce report view, click the Export button in the toolbar and select 'Google Sheets' as the destination. The report opens directly in Google Drive as a live sheet. Rename the data tab to start with 'layer_', open InstaMaps, and your Salesforce accounts appear on a map in the same session. The full report is preserved, every column is available as a filter.

This workflow replaces Salesforce Maps for the territory visualization use case. The same map you'd build in Salesforce Maps for $75/user/month is ready in 5 minutes for free.

If Your Data Is in Excel

Excel files need one extra step since InstaMaps works inside Google Sheets. Upload your Excel file to Google Drive and open it with Google Sheets. Drive converts it automatically, preserving all columns and data. From there, rename the tab and follow the same steps as any Google Sheets file.

Alternatively, copy the data range from Excel and paste it directly into a new Google Sheet. Either approach takes under a minute and the rest of the workflow is identical.

Common Questions