•Spreadsheet Validation - The data entry forms validate the data using lists of values, date formats, field lengths and some other field level validation. The spreadsheet program does some checking on the content of date and number cells. If you have removed or renamed a compulsory column you will be informed.
•Upload Validation - The upload process will perform the spreadsheet validation above as well as the validation within the API.
Data keyed directly into the worksheet (not via the data entry forms) will be validated when it is uploaded.If you wish to check anything before it is uploaded, simply open the form. Any incorrect data will appear in red on the form and will also change the offending cell on the spreadsheet to red.
