$60 USD csv/xlsx to kml w/ custom icons in the kml

Looking for a VBA within or outside of Excel to convert a sheet to kml with custom icons depending on a fields data.

Sample data provided.
forum.ozgrid.com/index.php?attachment/60971/

The icons need to be as follows (I don't have custom ones made at the moment still working on that part on my end)
10+ Age = 10plus.jpg
20+ Age = 20plus.jpg
80+ Age = 80plus.jpg
90+ Age = 90plus.jpg
140+ Age = 140plus.jpg
150+ Age = 150plus.jpg

All of the data also needs to stay in the KML as a descripction.

Re: $60 USD csv/xlsx to kml w/ custom icons in the kml

Quote from Wigi;716398

Hello

Did you pay 10% to Ozgrid? 90% remains afterwards.

Yes $6 has been paid to Ozgrid I apologize if I've named the thread wrong, the total 90% would be $54.

Re: $60 USD csv/xlsx to kml w/ custom icons in the kml

Quote from Wigi;716400

Thanks!

Is this code for a one-off exercise, or do you need to convert Excel files regularly?

Regularly but the format will be the same each time, it's exported from a database in the same format each time, the output is CSV but I add the date and age fields manually from the formulas in the spreadsheet and usually save it as xlsx.

See OP for updated information.

Re: $60 USD csv/xlsx to kml w/ custom icons in the kml

Quote from Wigi;716403

Hi

Here's a website, including a file and VBA-code.
Probably this is what you need, but I don't know if custom icons are possible.
You might need to choose from an existing list.

I have almost no experience with the KML files so I'd suggest to first try this.

Theres no website attached :\