Use this guide to produce an Excel spreadsheet on selected data for example Single Central Record.

Also see: How-to-install-Excel-Add-In

In this example from the Source Domain dropdown Single Central Record – Teaching Staff has been selected

Click Save and Ok and then when the spreadsheet opens click Refresh Data from the top left.

Adding filters

In the example below we are going to add some filters to the excel spreadsheet

Date Filter: for any dates the format of the date cell is YYYY-MM–DD so if the date is 19th June 2023 then you would type in 2023-06-19

In the example below we have the Students Source Domain selected

With the Configured Sheet highlighted click on Add

We’ve then chosen the Date of Birth column and the = for EQUALS and then typed in 2001-04-05

Click OK

Click Save

Then we need to refresh the data from Add Ins – Refresh Data

Now the spreadsheet has refreshed to just show the Date of Birth selected