If you encounter the following error message while attempting to bulk upload a user list to your account via CSV, there is likely a minor formatting issue within your spreadsheet:
"INVALID_EMAIL"
This error usually occurs when one or more of the email addresses in your CSV file contain an accidental blank space either before or after the text within the cell. The system cannot process an email address if it detects hidden spaces.
How to resolve
To successfully upload your user list, you must clean the formatting in your file:
Check the Email Column: Open your CSV file and review the cells containing the email addresses.
Remove Blank Spaces: Delete any leading or trailing spaces around the text.
Save and Retry: Once the hidden spaces are removed, save the file (ensuring it remains in .csv format) and attempt the upload again.
đź’ˇ Tip: If you have hundreds of users on your list, use the Find and Replace tool in your spreadsheet software to search for a single blank space and replace it with nothing, or use the TRIM function to automatically strip out hidden spaces in bulk.