Why is excel always corrupting my XML files

Asked By Edith J Tucker 80 points N/A Posted on - 12/26/2014

Why is Microsoft Excel always corrupting my XML file? My work required that I import a lot of XML files to Microsoft Excel for analysis, after the successful mapping of the XML file using excel, but when I tried to import the file, I got the message that the file is corrupt. When I check the XML file using XML editor, the files seem to the okay. What can I do to import this file to excel without it being corrupted?

• Status: Open
• Question Views: 715
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Clare Moui 0 points N/A #190277

Why is excel always corrupting my XML files

First of all, Make sure that the XML file has no syntax or any other error. File corruption error comes when you select more than one data file for importing to excel and it doesn’t find any matching XML map for any of the file. This means that for each and every XML data file there has to be matching XML map. An appropriate schema should be available for importing XML data file to excel. Before you start importing data file, Import an appropriate Schema first for all the required data files and then go for importing more than one XML data files.

About Clare Moui

Questions
0

Answers
100

Best Answers
9

• Vote Up 0 Vote Down

• Posted on - 01/29/2015
• Question Category: MS Excel