You may open an XML file in Excel using two different methods – a) using the File menu and b) using the Data menu. Note: An XML file contains data that’s been arranged within tags.

To open the XML file, you can use a third-party custom application for XML editing, or you can use Windows. Chron Logo Hearst Newspapers Logo. Skip to main content. ... Excel or Notepad++.

To be able to import your data into Excel, you must export the PDF as an XML file using Adobe Acrobat 9 Pro Extended. Excel can open XML files and create fully functional spreadsheets out of them.