Convert Excel or CSV to XML

[outoorwest]

Does anyone know of an easy and preferably free way or tool to convert a spreadsheet of columns and data to XML?

[cmarshall]

Not offhand, but it's darn easy to do.

Simply save the data as TSV (Tab-Separated Values), and do a search-and-replace on the file in a text editor. This could also be easily done automagically in a programming language.

Excel and Word also give the ability to save as (messy) XML.

[outoorwest]

I was able to get this done with find & replace. I added columns before, between, and after each column of data so I had something to search for & replace with the xml tags. Not sure if that is what you had in mind, but it worked. Thanks.

[Realbrisk]

I think Corel Quattro Pro can, its preloaded on all Dell pcs

[outoorwest]

Ah, but I'm a Mac snob. Thanks for the tip though. I got it figured out, but I'll remember that for the future.

[cmarshall]

but I'm a Mac snob.

mi2