Answer:
Your MCR submission requires a set number of columns in the .csv file to ensure that we have the required data. When you use the MCR template to produce the file or we send you an MCR error file that you download, it’s important that this isn’t opened at any point in excel and saved. If it is, excel will perform changes to the file which will corrupt the data.
Where possible, always use the MCR template and its import function to update files.
When you produce an output, make sure you that you don’t open this in excel after producing it.
When you download a file from the Employer Portal, make sure to use the 'save as' option rather than opening the file and saving it that way. Once this is saved it can be imported into the MCR template.
No MCR file should need to be opened in excel at any point, please always use the MCR template and its import function.