I will be describing things in MS Office Excel 2013, but it also applies to other similar apps. I was in need to create XML Data to be used on a website. The easiest way to type-in information is in app with tables, of course, but the conversion to XML Data has proven rather difficult. It required that I enable Developer tab in Options, create XML Map, than link Map to Column, check that my table has headings, and than export. After one hour of finding how to do this, the results were still not good, and I decided to rather try something else.
Ok, so how to get this type of structure with Excel 2013, where title, artist, country, company, price and year are table headers? I had table like this:
- First do “Save As”, and save as CSV (MS-DOS), that is Comma Separated Values separated only with commas.
- Go to http://xmlgrid.net/csvToXml.html
- Click on Open file, chose your CSV file, and click on OK.
- Chose that your table has headings.
- Select the code and do copy/paste to notepad,
- Save As in notepad, chose instead “Text documents” “All files”, enter file name with extension .xml, and OK.
- That’s it! Place the html that reads that XML with .xml file in the same directory, and it will work.
- If you like, you can open .xml now into Excel and work with it from there. Now it will work just fine.
You can see the result from HERE.