Scenario:
When generating a report in the Fixed Assets Management module, users may find that the report is only available in XML and PDF formats.
To convert this to excel, follow these steps:
- Click on the XML hyperlink for the report you wish to open in Excel. The XML file will be downloaded and will be available in File Explorer.
- Navigate to the File Explorer window where the downloaded file is located.
- In the File Explorer window, go to the View tab (Layout and view options) at the top.
- Ensure that the File name extensions checkbox is checked. This will allow you to see the file extension next to the report name.
- Right-click on the report file and select Rename.
- Change the file extension from “.xml” to “.xls”.
- Press Enter to save the change.
You can now open the renamed file in Excel, allowing you to view and edit the report as needed.