To import Excel data into Google Earth, save the worksheet as a CSV file, then open it in Google Earth Pro and match its location columns in the import wizard. Google Earth Pro can plot rows from latitude and longitude or, when available, address fields. It does not reliably import an Excel workbook directly. The steps below cover the desktop app; Google Earth for the web generally needs a KML file rather than an Excel sheet.
What You’ll Need
- Microsoft Excel and a workbook with one location per row.
- Google Earth Pro for Windows or Mac, installed on your computer.
- Either latitude and longitude columns or address details that identify each place.
- A folder where you can save the CSV and, if desired, the finished KML or KMZ file.
Step-by-Step
- Choose the worksheet and tidy the location data. Put the records you want to map on one sheet, with a single header row at the top and one place per row beneath it. Remove blank rows above the headings, merged cells, subtotal lines, and notes that are not part of the dataset. Keep useful descriptive columns, such as Place Name or Category, because they can appear in the map’s place details. If the workbook has multiple sheets, plan to export the relevant sheet separately; a CSV file contains only the active worksheet.
- Check how each row will be located. Coordinates are usually the most reliable option. Use separate columns with clear headings such as Latitude and Longitude. Latitude must be between -90 and 90; longitude must be between -180 and 180. A positive latitude is north of the equator and a negative latitude is south; positive longitude is east of the prime meridian and negative longitude is west. For example, a row with latitude 37.4220 and longitude -122.0841 is in the Mountain View, California area. Do not put the two values in one cell unless you know the importer can separate that format.
- Use complete addresses if you do not have coordinates. Separate street address, city, state or region, and country into columns when possible. Include the country, especially for places outside your own country, and use consistent spellings. A partial or ambiguous address may match the wrong place or fail to resolve. Postal codes can help distinguish locations with similar street names. If the workbook has both coordinates and addresses, use the coordinates as the location source and retain the address as descriptive information.
- Save a copy as CSV. In Excel for Microsoft 365 on Windows, select the worksheet you want, then choose File > Save As > Browse. In the Save as type list, select CSV UTF-8 (Comma delimited) (*.csv), choose a location, and save. Excel may warn that CSV does not support multiple sheets or some workbook features. Confirm that you want to use the CSV format for this export; your original Excel workbook remains the version to use for formulas, formatting, and other sheets. On a Mac, use File > Save As and choose CSV UTF-8 or CSV as the file format if that option is available. Menu wording can vary slightly by Excel version.
- Check the exported file before importing. Reopen the CSV in Excel or a text editor and verify that the headings and records are present, the columns have not shifted, and the coordinate values still look correct. CSV stores plain text values rather than Excel formulas, formatting, or multiple tabs. If a value contains commas, Excel normally quotes it in the CSV; do not remove those quotation marks in a text editor. If your decimal separator is a comma because of regional settings, check the file carefully: comma-separated values can become ambiguous. Use an export that separates columns correctly, or adjust the regional/export settings before proceeding.
- Open Google Earth Pro and start the import. Launch the desktop Google Earth Pro application, not just the Google Earth website. Choose File > Import, browse to the CSV you saved, select it, and choose Open. If the file picker does not show the CSV, change its file-type filter to show CSV or all supported files. On Windows and Mac, the menu path is generally File > Import, though the operating system’s file picker looks different.
- Set the import options. In the data import wizard, check the preview and confirm that the fields line up under the correct headings. Choose the comma as the delimiter if it is not detected automatically. Select the option to use latitude and longitude fields when your file has coordinates, then assign the correct latitude and longitude columns. Do not reverse them: the order is latitude first, longitude second. If you are using addresses instead, choose the address or location fields option and identify the relevant street, city, region, postal code, and country columns that the wizard offers. Set the name field to a useful column, such as Place Name, so the items are easier to identify in the Places panel. Wizard wording and options can differ slightly by release.
- Complete the import and review the map. Finish the wizard and wait for Google Earth Pro to plot the records. Zoom to the imported points or expand the new item in the Places panel. Click several points and compare their names and positions with the source sheet. Check points from different parts of the dataset, not just the first record. For address-based imports, allow time for locations to resolve and look for any warning or failed-record message. If points appear on the wrong continent or in a straight line, stop and check the field assignments before saving.
- Save the imported places if you want to keep or share them. Imported data may appear under Temporary Places, so save it before closing Google Earth Pro. In the Places panel, right-click the imported item or its folder and choose Save Place As. Choose KML to retain a shareable map file, or KMZ for a typically smaller file that can bundle supporting images. Choose a clear filename and location. To view the result in Google Earth for the web, open a project and import the saved KML or KMZ file; the web version is designed for KML/KMZ project data rather than direct Excel workbook import.
Common Mistakes
Reversing latitude and longitude: This is one of the most frequent causes of misplaced points. Latitude is the north-south value and longitude is east-west. Confirm that the wizard assigns the correct column to each field, even if your spreadsheet’s headings are abbreviated or ordered differently.
Exporting the wrong sheet: A CSV export represents one worksheet, not the entire workbook. Select the intended sheet before saving, then check the exported record count and a few identifying rows.
Using formatted coordinates as text: Extra symbols, degree marks, compass letters, or a combined coordinate string can prevent recognition. For a straightforward import, use decimal degrees in two numeric columns. Avoid thousands separators in coordinate values.
Expecting Excel formatting to transfer: A CSV does not preserve cell colors, formulas, charts, or multiple worksheets. Keep the workbook as your editable source and treat the CSV as an import copy.
Assuming an address is unique: A street name without a city or country can point somewhere unexpected. Add enough address fields to identify the intended place, and verify the plotted results rather than assuming every match is correct.
Tips
- Use simple, descriptive column headings such as Name, Latitude, Longitude, City, and Country. Clear headings make the wizard easier to navigate and the imported records easier to understand.
- Keep a stable ID column if you will update the map later. For example, a site code can help you compare the imported rows with the source workbook even if names change.
- Test a small CSV with a few known locations before exporting hundreds or thousands of rows. This catches swapped columns, delimiter issues, and address problems early.
- Make a copy of the workbook before cleaning or exporting. Save the CSV under a different name so you do not accidentally replace the original Excel file.
- If you need to share the map with someone who does not use Google Earth Pro, send the saved KML or KMZ as well as a note explaining what the placemarks represent. Avoid sending sensitive location data unless the recipient is authorized to see it.
- For repeated updates, keep the same column layout and export process each time. Consistent headings and formats reduce the chance of selecting the wrong field in the import wizard.
Troubleshooting
The CSV will not open or does not appear in the file picker: Confirm that the filename ends in .csv and that you are using Google Earth Pro’s File > Import command. If the picker filters out the file, choose a CSV or all-files filter. If Excel saved a different format, export the worksheet again as CSV UTF-8.
The wizard shows data in the wrong columns: The delimiter may not match the file. Return to the wizard and choose comma if the CSV uses commas. If the preview still looks incorrect, inspect the CSV for semicolons, unexpected line breaks, or commas used as decimal separators. Re-export with a consistent delimiter rather than trying to repair a large file by hand.
No points appear: Check that you selected location fields and that the latitude and longitude columns contain numeric values, not blank cells or text with extra symbols. Confirm that each coordinate is within its valid range. For address imports, add missing city or country information and try again. A row without a usable location cannot be plotted.
Points appear in the wrong place: Verify the latitude/longitude assignment, signs, and decimal values. A missing minus sign can move a point to the other side of the equator or prime meridian. Also check that Excel has not changed long coordinate values or interpreted them as dates. Compare a plotted point with a known location before reimporting the complete dataset.
Only some addresses match: Make the addresses more specific, standardize abbreviations, and include country or region details. Some addresses cannot be uniquely resolved. Where precision matters, replace uncertain address matches with verified latitude and longitude values, then import again.
The imported layer disappears after closing Earth Pro: It may have remained in Temporary Places. Reopen the source CSV and import again if needed, then right-click the imported folder in Places and use Save Place As to create a KML or KMZ file in a known folder.
Frequently Asked Questions
Can Google Earth import an .xlsx file directly?
For a dependable spreadsheet workflow, export the worksheet from Excel as CSV and import that file in Google Earth Pro. The workbook format may not be accepted by the importer, and CSV also makes it easier to check the location columns.
Can I import an Excel sheet into Google Earth in a browser?
Google Earth for the web is not the same as Google Earth Pro’s CSV import workflow. Convert the spreadsheet to CSV and import it in Pro, then save the places as KML or KMZ. Open a web project and import that KML or KMZ file.
Do I need coordinates, or can I use addresses?
You can use coordinates or address fields when the importer can identify them. Coordinates in decimal degrees are generally more predictable. Addresses need enough detail to identify a single location and should be checked on the map after import.
Does the import include every worksheet in my workbook?
No. A CSV file contains one worksheet at a time and does not retain workbook formulas, formatting, charts, or other sheets. Export each sheet separately if you need to import more than one set of records.
What is the difference between KML and KMZ?
KML is a map-data file, while KMZ is a compressed KML package that can also include related assets. Either can preserve the placemarks for sharing or opening in Google Earth, provided the file contains the imported places.
Related
- Find Links to Other Workbooks in Excel
- How to Find Links in an Excel Spreadsheet
- How to Find Interquartile Range in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Create an Outlook Email Template: Step-by-StepTo create a reusable email template in classic Outlook for Windows, compose a message, then choose File >…
- Delete Row in Excel: Methods and Keyboard ShortcutsTo delete a row in Excel for Microsoft 365 on Windows, click its numbered row heading, right-click, and…
- Excel Slicer Drop-Down: Options and Alternatives ExplainedNo—Excel for Microsoft 365 on Windows does not have a built-in setting to turn a slicer into a…
- How to Freeze X and Y Axes in Excel at the Same TimeTo keep a worksheet’s top row and leftmost column visible while you scroll, select cell B2, then choose…
- Switch Excel Workbooks: Keyboard Shortcuts and TipsIn Excel for Microsoft 365 on Windows, press Ctrl+F6 to switch to the next open workbook window, or…
- How to Cancel a Mail Merge in Word Without SendingTo stop a mail merge in Word, press Esc or choose Cancel if a progress window offers that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.