Need help exporting to XML

I have a website form that I exported as XML that I'd like to do a large number of changes that involve duplicating some (not all) content. If I open the XML with MS Excel, it opens in Table view which is perfect for me to dump data into the columns from a CSV and duplicate the other cells in the row.

The problem is that I wish to save it in the original XML format (so I can import back into my website as a form), but I get the error message "Cannot save or export XML data. The XML Maps in this workbook are not exportable".

How can I overcome this problem?
gravityforms-export-2013-09-22.xml
Book1---Copy.xlsx
LVL 8
Reece DoddsAsked:
Who is Participating?
I wear a lot of hats...

"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.

Reece DoddsAuthor Commented:
I've thoroughly read that prior to asking this question and it DOES NOT offer any explanation or, more importantly, solution to the reasons I can't export.

I am opening the XML with Excel, adding a heap of data to one or two columns, and duplicating the data down the rows for all other columns...

I'm not starting from scratch or compiling an XML using imports etc.

When I click the Verify Map for Export link in the Source section, I get the following error, which the article you linked addresses, but does not offer a resolution for.
verify map for export
I attached the files I've been working with so people could understand what I'm trying to do...  so have a play with them and see if there is a better suggestion you could offer.

I'm not a data format professional by any name and my knowledge of XML is really limited.
0
jkpieterseCommented:
Excel cannot export to XML structures which have more than one level of nesting.
Period.
You will have to write VBA code to do the export to XML yourself.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sybeCommented:
Is there a special reason why you do not use a HTML-editor when editing a webpage? Because that seems the proper way to do it.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
XML

From novice to tech pro — start learning today.