Si tienes grados minutos segundos (GMS) y grados decimales en el mismo archivo:
=SI(ESNUMERO(B2); B2; CONVERTIR_GMS_A_DECIMAL(B2))
(Usa el complemento "Geográfico" de Excel)
df = pd.read_excel('your_file.xlsx')
| Method | Best for | KMZ output | |--------|----------|-------------| | Online converter (GPS Visualizer) | Quick, one-time | ✅ Direct | | QGIS | Large data, styling | ✅ Direct | | Python script | Automation, repeating | ✅ Direct | | Google Earth Pro | Simple, manual | ✅ Direct |
If you share a sample row of your Excel data (column headers + 1 row of values), I can give you the exact conversion steps.
Modern Methods for Converting Excel to KMZ (2026) Converting Excel data into KMZ files is a standard practice for professionals in logistics, environmental science, and urban planning who need to visualize spreadsheet data on geographic platforms like Google Earth
. A KMZ file is essentially a compressed (zipped) version of a KML (Keyhole Markup Language) file, making it more efficient for sharing datasets that include custom icons or large amounts of metadata. MyGeodata Converter 1. Preparing Your Excel Data
To ensure a successful conversion, your Excel file must be structured with specific geographic headers. Essential Headers : You must have columns clearly labeled as Coordinate Format : Coordinates should be in decimal degrees
(e.g., 40.7128, -74.0060) using the WGS 84 datum for maximum compatibility. Optional Metadata : You can include additional columns like Description to customize how placemarks appear on the map. File Format : While modern tools can often read directly, saving your file as a CSV (Comma Separated Values)
remains the most universally compatible method for older or specialized GIS software. 2. Primary Conversion Methods A. Native Import via Google Earth Pro (Desktop)
Google Earth Pro provides a built-in "Generic Text Import" feature that is highly reliable for converting spreadsheets. Google Earth Pro File > Import Select your CSV or Excel file. Import Wizard , choose "Delimited" and select "Comma". Map your latitude and longitude columns when prompted. convertir excel a kmz new
Once the points appear in your "Temporary Places," right-click the folder and select "Save Place As" , then choose from the dropdown menu. B. Direct Online Converters
For users without desktop GIS software, several web-based tools offer "one-click" conversions. MyGeodata Cloud : Allows you to upload
files, map your columns in the browser, and download the resulting KMZ. MapKmlTools
: A free utility focused on quick Excel-to-KML/KMZ transformations without requiring a user account.
: Useful for users needing to convert specific address data or complex GPS receiver formats directly into Google Earth files. C. Advanced Visualizations (Linked Photos)
Modern GIS needs often involve linking media to geographic points. Specialized workflows at MyGeodata Cloud Knowledge Base
allow you to upload a ZIP file containing both your Excel sheet and relevant photos. The converter automatically embeds these images into the KMZ pop-up balloons for interactive storytelling. MyGeodata Converter 3. Key Considerations for 2026
(field?) Problems converting from *.xls to *.kmz - Esri Community 25 Mar 2022 —
Converting Excel data into KMZ files is a game-changer for anyone needing to visualize geographic data in Google Earth. Whether you are mapping out delivery routes, tracking environmental data, or plotting real estate leads, this guide covers the most efficient ways to make the jump from a spreadsheet to a 3D map. The Foundation: Preparing Your Spreadsheet
Before you even think about conversion, your Excel file needs to be "map-ready." Google Earth can't guess where a point is unless you provide specific coordinates. Essential Columns: At a minimum, you need columns for (in decimal degrees) or a full (Street, City, State, ZIP). Si tienes grados minutos segundos (GMS) y grados
Include extra columns for "Name" and "Description." These will automatically become the labels and pop-up info boxes in Google Earth. Save your final spreadsheet as a CSV (Comma Separated Values)
file, as most conversion tools prefer this over the standard .xlsx format. Method 1: The Direct Import (Google Earth Pro)
The most reliable method is using the desktop version of Google Earth Pro, which is free and has built-in import tools. File > Import and select your CSV file.
A wizard will ask if you want to use addresses or coordinates. Choose the appropriate columns. Style Template:
You can create a "Style Template" to color-code your points based on specific data (e.g., making high-value leads green and low-value red). Save as KMZ:
Once the points appear, right-click the folder in the "Places" panel and select "Save Place As..." then choose Method 2: Web-Based Converters (Fast & Easy)
If you don't want to install software, several "New" web tools have streamlined the process: Earth Point:
A long-standing favorite that specifically handles Excel-to-KML/KMZ conversions with high precision.
Excellent for large datasets. You simply paste your Excel cells into their web interface, and it generates a map that you can export. My Maps (Google):
You can upload your Excel file directly to a custom Google Map, then use the "Export to KML/KMZ" feature in the menu. Why KMZ instead of KML? While KML (Keyhole Markup Language) is the standard code, (Usa el complemento "Geográfico" de Excel) df = pd
is the zipped version. It is superior for sharing because it bundles the map data along with any custom icons, images, or 3D models into a single, compact file. Conclusion
The transition from a flat Excel sheet to a dynamic KMZ file adds a vital spatial dimension to your data. By ensuring your coordinates are clean and choosing the right tool—whether it's the robust Google Earth Pro or a quick web converter—you can turn raw numbers into an impactful visual story. expand on the technical steps for a specific tool, or should we focus on customizing the visual styles of the pins?
Convertir tus datos de una hoja de cálculo a un formato geoespacial es esencial para visualizar proyectos en herramientas como Google Earth. Un archivo KMZ es simplemente una versión comprimida (zip) de un archivo KML que incluye datos geográficos, iconos e imágenes.
A continuación, te presentamos las mejores formas de realizar esta conversión en 2026, desde métodos nativos hasta herramientas online automatizadas. 1. Método Nativo: Google Earth Pro (Gratis)
Esta es la forma más profesional y personalizable de importar tus datos sin costo.
Preparación del archivo: Guarda tu Excel como un archivo CSV (delimitado por comas). Asegúrate de que las columnas tengan encabezados claros como "Latitud", "Longitud" y "Nombre".
Importación: En Google Earth Pro, ve a Archivo > Importar y selecciona tu archivo CSV.
Configuración: El asistente te pedirá confirmar qué columnas contienen las coordenadas. Una vez importados los puntos, aparecerán en el panel de "Lugares".
Exportar a KMZ: Haz clic derecho sobre la carpeta importada en el panel izquierdo y selecciona "Guardar lugar como...", eligiendo la extensión .kmz. 2. Herramientas Online (Rápidas y "New")
Si buscas una solución directa sin instalar software, estas plataformas han actualizado sus motores de conversión recientemente: Excel to KMZ Converter Online | MyGeodata Cloud