Careers and job opportunities
Share:
Q

Download Application NoteHow do I export my database to an Excel spreadsheet?

A

To get the asset details into a file that can be opened in Excel.

Note:
This is not possible in PATGuard Lite.

  1. In PATGuard Software, using the right mouse button click on the client/site/location level name, a drop down menu will appear.

  2. In this menu you will find ‘Send To’ and at the right hand side of this line an arrow to indicate a further menu is available.

  3. The additional menu will list ‘File...’ and ‘Email..’.

  4. Select ‘File...’ and a new box will appear:

  5. Change the ‘Save as type’ using the drop down menu to ‘Spreadsheet (*.csv)’:

  6. Enter a name and save the document.

  7. This will save the document, which, when you use ‘Windows Explorer’ to find in ‘My Documents’ and clicked on will open into ‘Excel’.

  8. In the Excel Spreadsheet, click in the first cell.

  9. Hold down the ‘Shift’ and ‘Control’ Keys then press the ‘End’ key.

  10. This will highlight the whole database.

  11. On the toolbar select the sort icon ‘AZ’ with the down arrow.

  12. The database will be sorted numerically according to the ‘Asset ID’ in the first column.

 

View FAQs by product

 

If you are unable to find the answer to your question on our webiste, please email support@seaward.co.uk and we will get back to you as soon as we can.

Please note, our support opening times are 08:25 - 16:55 (GMT) Mon - Thurs, and 08:25 - 14:55 (GMT) on Fri.

 
Share:

Can't find the answer your are looking for? Why not as like minded professionals the question in one of the forums or groups below?

 
Stay up to date with the latest news from Seaward
 
When joining, you agree to Seaward contacting you via email about industry news, useful guides, webinars and workshops, and Seaward products which we feel will be of interest to you. Please refer to our privacy policy for more information on how we use your details.