SAGE Pension .csv file download for NEST with NI Numbers

Hi! 

I'm trying to find a way to create a .csv file for nest pension that shows employees by NI Number.

My payroll team has changed people several times in the last few years and how Employees were set up in Nest were either by payroll number or National Insurance number, so the problem now is that the Employee Reference that Nest is taking is either payroll number or NI number, this means half of my file's data is not loading.

Im a few weeks behind due to this issue, so any help will be greatly appreciated it!!

Thanks,

Betty