How to convert your Triple-S XML metadata to an Excel format
Overview
The Triple-S XML metadata can be converted into a reasonably structured spreadsheet-like file, which helps you considerably with transferring lists of information about variables into your code that modifies variables in Crunch.
It also eliminates the need to read the XML into R Code, which is one less step to take.
Converting your Triple-S XML to Excel format
To convert a file:
- Navigate to https://www.coolutils.com/online/XML-to-XLS.
- Upload your .xml file and convert it to an xls file.
- Download the file.
When finished, open the spreadsheet and view how the information is separated across the different variables.