To import a file into BenchmarkONE, it needs to be UTF-8 encoded. If you get the following message during import, your file will need to be converted before importing.
Here are instructions for converting your file to UTF-8 encoding:
Microsoft Excel:
- Open your file in Excel
- File > Save As
- Save as type: CSV UTF-8 (Comma delimited) (*.csv)
- Save the file
- Proceed with importing the new file
Google Sheets:
*By default, Google Sheets saves in UTF-8
- Open your file in Google Drive
- File > Download as > Comma-separated values (.csv) OR Microsoft Excel (.xlsx)
- Proceed with importing the saved file
Apple Numbers:
- Open your file in Apple Numbers
- File > Export to > .CSV
- Select the Advanced Options dropdown and choose Unicode (UTF-8) under the Text Encoding dropdown
- Select Next, then select Export
- Proceed with importing your file