0

I have a large XML file (11MB) which I need to open in Excel for processing. I have MS Excel for Mac 2011 and when I try to open the XML file, it just opens it as plain text (seems that this is a feature not supported by Excel for Mac 2011).

I was expecting to see the XML item data split to rows and columns, just like Excel for windows does.

Is there another way to convert it? I have looked at online converters, but haven't found one that can process large files...

  • 1
    XML is plain text. What did you expect to see? – Tetsujin Oct 31 '14 at 17:08
  • 1
    @Tetsujin Excel for Windows knows how to parse some formats of XML files into a table – Mark Oct 31 '14 at 17:24
  • Have you tried OpenOffice or libreoffice? – Deesbek Nov 1 '14 at 1:25
  • Managed to process the file on excel for windows. Too bad there's no easy way to do this on a Mac :( – Bogdan Nov 1 '14 at 11:48
  • Could be a feature to bring to Microsoft's attention for future versions. – bjbk Jun 4 '15 at 22:10

You must log in to answer this question.

Browse other questions tagged .