Importing Users: Encoding a CSV File

In this part of the user import process, you'll encode the CSV file. 

Encoding a CSV file ensures the data in your file can be properly processed by SmarterU. Depending on how a file is encoded, accented or non-Roman characters may be stripped or simplified during the saving process.

You may encode your file using either of the following:

• Excel
• Google Drive
• Notepad

Encoding a File Using Excel

To encode a CSV file using Excel:

1. Locate your CSV file.
2. Right-click the file.
3. Select Open With, then select Excel. 
4. From Excel's File menu, select Save As. 
5. From the Save As panel's list of file types, select CSV UTF-8.

6. Click Save.

NEXT STEP: Upload the CSV File to SmarterU 

Encoding a File Using Google Drive

To encode a CSV file using Google Drive:

1. From Google Drive, create a new spreadsheet.
2. Copy your data from the original Excel file and paste it to the new spreadsheet.
3. From the File menu, select Download As.
4. From the Download As menu, select Comma-separated values (.csv, current sheet). 

The Save As window displays.

5. From the Save As window, navigate to the location where you would like to save your file.
6. Click Save.

NEXT STEP: Upload the CSV File to SmarterU 

Encoding a File Using Notepad

To encode a CSV file using Notepad:

1. Locate your CSV file.
2. Right-click the file.
3. Select Open With, then select Notepad.

4. From Notepad's File menu, select Save As. The Save window displays. 
5. In the Save window's Encoding list, select UTF-8.

6. Click Save.

NEXT STEP: Upload the CSV File to SmarterU