Identify what your error messages mean.
Firstly, you may see this generic error message if there are any miscellaneous formatting issues in your file:
Please copy and paste your data into a brand new Excel file 'as values only' and attempt to re-upload. This should remove any unwanted formatting in your file and allow the file to be added to the platform.
If you are getting a more specific error message please take a look through the below:
1.
Error Message: Column [Number] header is empty. Please add a header or delete the column.
This error message means an invisible value exists in the last column of your data. To prevent this, you can either copy all of your values and paste them in to a new document, or you can highlight the last 5 columns in your data (where there appears to be no values) and delete the full columns.
2.
Error Message: Data map has been created, but something went wrong with file upload and we received this error: Column name mismatch. Source column [Field Name]. Destination column [Field Name].
This error message means there is an issue with the headers in your excel file. To prevent this, check that there are no paragraph spaces in the text boxes. Use the below as an example.
3.
Error Message: There was a problem with the provided file: Invalid password.
Your file may be password-protected. Please remove this and try again.
4.
Error Message: When dragging and dropping in your file, the screen quickly flashes but does nothing.
Check that your file is not password protected. The system will not be able to extract the information within your file until the password has been removed.
Alternatively, is the file 30MB or over? If so, split the file in to 2 or more files and then upload.
5.
Error Message: Sheet name contains invalid characters. Accepted only: [a-z][A-Z][0-9][_][-]. Example: Test Sheet-Name_01
Please remove any special characters from the Sheet name in your Excel file, and this will allow the file to upload correctly.
Please note that your sheet name appears at the bottom of the page within your Excel file, and is not the same as the file name.
If you have any questions, feel free to reach out to us through the live chat function available bottom right in your Force24 Platform. Our team is ready to assist you and provide support whenever you need it!