Encoding your CSV files using the UTF-8 Format

OpenScholar is unable to import CSV files containing non-English or special characters such as ASCII characters. Encoding your CSV files in the UTF-8 format will ensure that OpenScholar is able to import contents of your CSV files.

How to Encode your CSV Files

Microsoft Excel 2016

Windows
 

1. Open your CSV excel file
2. Click FILE in the upper left-hand corner
3. Select SAVE AS on the left-hand side
4. In the file type drop-down menu, select CSV UTF-8 (Comma Deliminated) (*.CSV)
5. Save the file
6. Import file into OpenScholar

MAC
 

1. Open your CSV excel file
2. Click FILE in the menu bar
3. Select SAVE AS
4. In the file format drop-down menu, select CSV UTF 8 (Comma Deliminated) (*.CSV)

5. Save the file
6. Import file into OpenScholar

Google Sheets
 

1. Open your CSV file in Google Sheets
2. Click FILE in the upper left-hand corner
3. Select DOWNLOAD AS in the file menu
4. Select Comma-separated values (.csv, current sheet)

5. Save the file
6. Import file into OpenScholar