How to troubleshoot or fix load files

  Heads up

This applies to Extended Format Uploads, PO/Supplier Invoice uploads and all bulk data uploads processed through Admin Operations.

How To

How do I troubleshoot an excel file that fails to upload? 

Follow these steps

If your upload is failing and you've confirmed all headers and data values are in the accepted format, it's likely the failure is stemming from unintentional whitespace or unaccepted formatting. This can usually be corrected by copying your data out of the current workbook, and pasting the values into a new one. This removes formatting errors like additional rows/white space, hidden columns, merged cells, etc., without having to find them in your original sheet. Follow these steps.

1. Open the file in Excel.
2. Select only the areas of the sheet where there is content.
   
3. Select Edit > Copy. Remember to copy only the cells that have content, additional white space from blank cells may cause your import to fail.
   

4. Open a new Excel workbook.

5. Select cell A1.
6. Select Edit > Paste Special.
   

7. Select Values under paste, then select OK.
   

8. Select File > Save As and give it a new name.

9. Re-upload the new file.