Cannot export xml opened with excel to xml

Question

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?

The exported XML original and updated XLSX file are uploaded into the following share: http://sdrv.ms/16kiBgH

Answer 1

I assume you have googled and found this how-to

Verify Map for Export gives:
forms_Map is not exportable because it contains:
- List of Lists
- Denormalized data
- A mapped element's relationship with other elements cannot be preserved