The majority of screens in Opex allow you to download the data displayed into excel. 


To download data click on the Actions button then click Download Items in CSV format.





Alternatively there may be buttons that refer to 'Download to spreadsheet' or 'Download Stocktake' etc.




After you have clicked a Download button a pop up box will appear. Depending on the internet browser that you are using, the box will either be in the middle of the screen or at the bottom of the screen if you are using IE.




Click the drop down to the right of Save and select Save as




Save the CSV file to a folder on your local drive or shared drive. You can change the name of the file at this point.


Open up Excel and go to File > Open


Go to the folder where you saved the file. You will see all of the .xls files. To find the csv file click the file type drop down then select All files.




You will then see the csv file.