convert from excel to xml

Hello experts,

I would like to know if there is a way to copy the data from an excel row to be placed inside an xml tag attribute. To see what Im talking about please take a look at the attached image.

So, I would like to grab a row from the excel file and place each cell on its corresponding xml attribute as shown in the image. I don't do this manually because there are hundreds of data and that would take me days to finish up. Any suggestion I would greatly appreciate it.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

You could simply use formulas to generate the tags from a table like in this spreadsheet. When you have your complete table filled in you can select all the rows and columns containing the XML and do a copy and paste into Notepad. Remember to SAVE AS UTF-8 and not ANSI...