Put HTML into KML display

Create a blank new folder for this.  Once you have this folder, you should not move any of the files from it, or you risk breaking links to the images.  The folder will evantually will have the following in it:

  • The word processor document.
  • An HTML file saved from the word processor (or Google Docs), and a folder with all the images.  These must stay together, and cannot be renamed after you save them in the word processor unless you really know what you are doing and are very careful.
  • A bitmap for the icon.
  • A CSV file created in Excel, and a DBF file created from it by MICRODEM.  It must have the location to display the symbol on the map, the name of the symbol's bitmap, and the HTML file.

Create an HTML file with text, graphics, and other standard features such as a reference list, with very simple formatting.  Fancy formatting that does not export is a waste of time and leads to a poor product. 

Create a point database with the LAT/LONG location where you want the introduction to appear.  Use the field names (the top row) exactly as shown to the left.
  • The NAME field will be used to label the push pin (or use the ICON field entry for a more attractive option).
  • The ICON will be placed on the screen.  It must either be in the directory with the other files, or in c:\mapdata\icons.
  • The TEXT field should have the name of the HTML file, which must be in the same directory as your database.  The images must be correctly located (they are probably in a subdirectory from the location of the HTML file, but you should let this happen automatically by not changing anything). Insure that the correct extension (.HTM or .HTML) matches the file.
  • The database can contain multiple records, and each will appear at a different location on the map.

Create the file in Excel, save as a CSV file (File, Save As, and pick the file type), and import into MICRODEM.

Export the database to KML, from the Report button's popup menu, and Google Earth (or a comparable program you have selected to open KML files) will automatically open it.  The quick option will work.  If the export hangs up, it is likely that your Word document is not very KISSABLE.  Three finger salute, and then fix the Word document (start with the figures).

Clean up KML exports

The icon or a push pin will appear at the specified location.  A red X for broken link means the icon file was not in the correct location.

In this case "F.A.T.A" is the label from the database (in the NAME field), and "Landi Kotal" is Google's text from the "Borders and Labels" layer, which happens to display at the chosen location,  which you can turn off if desired in the GE table of contents.

Clicking on the icon or push pin brings up the HTML page, with graphics and links.

You can also bring up the page by clicking on the link for the record in the Google Earth table of  contents in the "Places" panel.


Save the resulting KML/KMZ files by right clicking on the entry in the Google Earth list of layers, and picking "Save Place As".  Select KMZ, as it will give you a single zipped file with all the graphics included.  You may want to rename it first, and adjust the folder layout used (Clean up KML exports).  This file is buried in a directory, but since the directory only has one entry, access to your file will be easier if you highlight and save the lower entry as highlighted above.


Troubleshoot problems:

Last revision 12/6/2021