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
![](https://d3kchveacp7yrb.cloudfront.net/2022/06/dsBBxcS6-image-41-1024x461.png)
Click Save and Ok and then when the spreadsheet opens click Refresh Data from the top left.
![](https://d3kchveacp7yrb.cloudfront.net/2022/06/zF2Ym5ZH-image-42-1024x493.png)
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
![](https://d3kchveacp7yrb.cloudfront.net/2023/06/eWz4dlgV-image.png)
With the Configured Sheet highlighted click on Add
![](https://d3kchveacp7yrb.cloudfront.net/2023/06/xAKX9uWl-image.png)
We’ve then chosen the Date of Birth column and the = for EQUALS and then typed in 2001-04-05
![](https://d3kchveacp7yrb.cloudfront.net/2023/06/IVBRGb8W-image.png)
Click OK
Click Save
Then we need to refresh the data from Add Ins – Refresh Data
![](https://d3kchveacp7yrb.cloudfront.net/2023/06/ZJXKfqoe-image.png)
Now the spreadsheet has refreshed to just show the Date of Birth selected
![](https://d3kchveacp7yrb.cloudfront.net/2023/06/8DaoDWqI-image.png)