What your asking is certainly possible in Google Earth, but you might
want to read the License terms first to make sure you would be in
compliance:
http://earth.google.com/intl/en-US/license.html
If you would be in compliance, you might want to check out Google
Earth Plus, which would allow you to import spreadsheets directly.
ManoM
I don't know if OpenOffice allows macros, and I haven't seen any that
create
Phil
If you're using Google Earth Plus or Pro, you can simple open the file
from Google Earth. Once it is open, you can copy or save it out to
KML.
ManoM