How do I batch upload multiple users who have symbols in their names?
Learn how to batch upload multiple users who have symbols in their names.
Uploading CSV files with special symbols in them can sometimes be tricky to do in any system.
Here is our step-by-step guide to doing a batch upload of multiple users who have symbols in their names.
Step 1: Download the CSV template and fill in
Download the CSV template on the Batch upload page.
Fill this in with all the correct information.
Step 2:
Open up a blank Excel document.
Select Data > Get external data > Import text file.
Select your original file that you saved above.
Step 3:
Change file origin from Macintosh to UTF 8.
Step 4:
Uncheck Tab and instead check Comma.
Step 5:
Keep data format as general.
Step 6:
Select Finish.
Step 7:
Bring the data into the current sheet.
Step 8:
File > Save as.
Format: CSV UTF-8.
Step 9:
Check that your Text symbol as remained by going to Open with > Text edit.
You will be able to check if the special symbols have remained.
Step 10:
Now go back into the Learn Amp platform to the Bulk import page and select your file.
Next, go to Review Data.
Step 11:
On this page, double check any information.
Step 12:
Then go to Settings.
Choose the appropriate settings for you.
Select import.
Step 13:
You can then go through the Individuals Page to make sure that special symbols have been retained.