How can I fix the UTF-8 error when bulk uploading users?

How do I fix the UTF-8 error when I bulk upload users? This error occurs when your uploaded file isn't in UTF-8 format. UTF-8 is the main character code on the Internet. Your import file might use another format, such as ISO-8859, instead of UTF-8. Use one of these options to convert your file to UTF-8. Select the method you use to bulk import users:

Expand all tabs



document.addEventListener('DOMContentLoaded', function () {
const toggleBtn = document.getElementById('master-toggle');

toggleBtn.addEventListener('click', function () {
const action = this.getAttribute('data-action');
const headers = document.querySelectorAll('.accordion');

headers.forEach(header => {
const isActive = header.classList.contains('active');
const panel = header.nextElementSibling; // Grabs the corresponding .panel container

if (action === 'expand' && !isActive) {
// Open it by simulating a standard click
header.click();
} else if (action === 'collapse' && isActive) {
// Close it by simulating a standard click
header.click();
}
});

// Flip button text and states
if (action === 'expand') {
this.setAttribute('data-action', 'collapse');
this.textContent = 'Collapse all tabs';
} else {
this.setAttribute('data-action', 'expand');
this.textContent = 'Expand all tabs';
}
});
});
If you have a Gmail account or use Google Drive:

Open Google Drive
Create a new Google Sheets document
Import your CSV file
Select File > Download As > Comma-Separated Values to save the file to your computer

The file downloads in UTF-8, and the upload succeeds.
If you use Microsoft Excel:
Open your CSV file in Microsoft Excel, then select File > Save As

Enter a name for the file, and select CSV UTF-8 (comma delimited) (*.csv) as your file format
Select Save

If you use Microsoft Excel and can't save as UTF-8 CSV, and you have Notepad:

Open the .xlsx file in Microsoft Excel, then select File > Save As (Other Formats)

Enter any name for the file, then select Unicode Text (.txt) for Save as type

Select Save

Open the Unicode text file in Microsoft Notepad. Some characters may appear as boxes because Notepad can't display some Unicode characters. Ignore these for now.
Replace tabs → with commas , so the file uses proper comma-separated values (CSV) format
Drag between two column headers to select a tab character, then press Ctrl+C
Use the Replace function to replace all tab characters with commas
In Notepad, select Save As

Enter a filename and change Encoding to UTF-8

Add .csv at the end of the file name to change the extension from .txt to .csv

Select Save. The file icon changes to Microsoft Excel.
Open the CSV file in Excel and check the data. If you find a problem, don't save in Excel. That can cause the UTF-8 issue again. Only use Excel to check the data. If you see a data problem, fix the original spreadsheet and repeat the steps. You can also edit the file in the Notepad app. Make sure to save the file in UTF-8 format.

You can now use this CSV file to import users.
