How do I export a collection into an Excel file?

book

Article ID: 180353

calendar_today

Updated On:

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.