Importing XML into excel : semicolon character was expected

[Nyanko]

Hi,

I'm trying to import an XML file into excel to format for a colleague unfortunately excel is unable to open the file stating :

XML Parse Error
Reason : A semi colon character was expected
Line : 313
Column : 94
File Offset : 13226

This XML file is generated each month via google analytics so will re generate this problem every time. I'm only looking to extract and format the text of the file so hoped there was a way I can do this.

Is there a way to do this via excel or can I use excel to open the file via notepad and then copy the text ?

Any advise or suggestions would be appreciated as I've never worked with XML before and am not sure where to start !

 

[Andrew Poulsom]

An XML file is only a text file, so try changing the extension to txt and opening it in Excel.

 

[Nyanko]

An XML file is only a text file, so try changing the extension to txt and opening it in Excel.

I never knew that. Genuis. Thank you for your quick assistance

Merry Christmas

 

[Nyanko]

Just to finish on this subject I used the following code to capture the file and re-name it to an xls file on the fly :

Sub ImportXML()
        'Open a dialogue box to find the file to import
    ChDrive "C:\"
    WkbImportFile = Application.GetOpenFilename(Title:="Please choose an XML file to import")

    WkbTXTImportFile = Left(WkbImportFile, Len(WkbImportFile) - 3)
    WkbTXTImportFile = WkbTXTImportFile & "xls"
    
    Name WkbImportFile As WkbTXTImportFile
        Workbooks.Open Filename:=WkbTXTImportFile
End Sub