Excel to GoogleEarth KML - Include Image in the balloons

This post is a follow up to my previous post Excel to GoogleEarth KML. The Excel macro in the previous post would export points and their attribute table to Google Earth.

In this updated version, you can also attach an image at each of selected points along with the image description if available. This version does not have any limitations on number of points and number of attributes you can export (the previous version would not let you have more than 10 attributes). But make sure you do not freeze your computer using 100s of points and attributes :-)

Get file names from a folder using Excel VBA

Get name of the files in a folder

This is an Excel 2007 or later macro that can fetch the name of all the files in a folder.

1. Download the file and open in Excel 2007 or later. If the macro security is not set to Low, you will be asked to Enable macros. Go ahead and enable the Macros.
2. Click the button labelled "Get File Names from a folder"
3. A warning message will pop up saying that the existing data in sheet 1 will be deleted. Click OK
4. A dialog will open allowing you to browse the folder where your files are.
5. Click OK and there you go!!

Excel to GoogleEarth KML

I remember a Facebook post I read sometimes ago "Google Earth lets you explore the whole world, but you go and try to locate your own little house".

Well! that was true for the first few times but not any more for me. I work with a lot of Geo-spatial data processing and visualization and exporting my data to Google Earth is often one of the choices. I had to struggle a lot to view my MS Excel data in Google Earth.

Toggle Series on/off - Excel Chart

What is this tool about

This tool adds a functionality to your MS Excel where you can toggle certain series on/off on a plot.

Why is this tool needed

I work with MS Excel almost every day and a lot of my task involves plotting and analyzing data. I have encountered situations when I need to plot several data series in a single plot but they become un-intuitive to visually interpret them. See the following common examples: