Warning: Your browser has javascript disabled. Without javascript some functions will not work, including question submission via the form.

Q. Converting XML Files to Excel, R, or Stata

Answered By: Bobray Bordelon

Last Updated: Nov 26, 2024 Views: 4944

To convert an XML file to Excel: https://support.microsoft.com/en-us/office/import-xml-data-6eca3906-d6c9-4f0d-b911-c736da817fa4

For those using R, use the function xmlParse(). Then, load data is stored in a list. An XML file can also be read in the form of a data frame by using the xmlToDataFrame() method.

For those using Stata, see https://www.stata.com/manuals13/dxmlsave.pdf

Contact Us

Chat with a Librarian

Text a Librarian

Text (609) 277-3245 to get live help on your mobile phone (available the same hours as the Chat service)

Email a Librarian

You can email your research questions to refdesk@princeton.edu or you can request an individual appointment with a subject specialist.

Call a Librarian

Call (609) 258-5964 to speak to a reference librarian during most open hours of the Libraries.