To export P45 file to Excel, follow the steps below:
Click Payroll then click Admin Payslips.
Select the Data File tab.
This lists all imported P60 and P45 data files.
To view the data in a file, select View File,
This opens a new tab showing all the data.
Select all the data, copy it, and import it into Excel; the data is delimited by pipes.