It is important to save your list in the formatting suitable for upload. Your file must be in .csv formatting, comma delimited and UTF-8 text encoding. Please refer to the following steps when converting your list from Excel to .csv (Mac OS 10.11.6).
1. Click File, the third drop-down option, on the menu bar. Then click Save As.
2. Change the File Format to ‘CSV UTF-8 (Comma delimited) (.csv)’ then choose Save.
3. Check your delimiter settings.
Be sure to check your delimiter settings as well. Sometimes, the delimiter could be set to semi-colon rather than comma. First, close your Excel File (save any changes first). Click the ‘Apple icon’ in the menu bar, then click ‘System Preferences’. Choose ‘Language & Religion’, then ‘Advanced Settings’.
Be sure grouping is set to comma (,) and the Decimal separator to a full stop (.) Reopen your file and proceed back to step 1.
4. Remove any trailing Spaces.
Does your email column contain trailing Spaces? Remove any spaces before uploading your list for validation.
To remove any spaces within the sheet, click ‘Edit’ at the top menu bar, Find and then Replace.
The ‘Find & Replace’ menu will appear. In the box that says, ‘Find What:’ enter only one space. Leave the ‘Replace with’ box empty. Click ‘Replace All’ to remove all spaces within the sheet.
After clicking ‘Replace All’, a pop-up will appear showing the number of spaces removed from the sheet. Click ‘close’ to return to the sheet. Your data should no longer contain any spaces. Now, click File, the third drop-down option on the menu bar. Then click Save As, change the ‘File Format’ to ‘CSV UTF-8 (Comma delimited) (.csv)’, then click Save.
© 2017 DataValidation. All rights reserved.
