How do I export a collection into an Excel file?

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
How do I export a collection view to an Excel* spreadsheet?

Answer

1. Open up the NS console.
2. Go to Collections > Computer Collections > All Computers.
3. In the right-hand pane after it’s been populated, click on the copy option. This will put all the info in this report into the Microsoft clipboard.
4. Open up Notepad.
5. Paste the contents into Notepad.
6. Use the replace option to change the column delimiter to a  comma ( , ) instead of a tab value.
7. Once all the values have been replaced, use the Save As option and save the file as a .CSV file.
8. You will now be able to open this file as a native Excel spreadsheet.