For the import of users to work you need to upload a comma-separated values file (CSV). It's important that the file is UTF-8 encoded, otherwise import might fail. Comma-separated values file can be created and managed with most spreadsheet programs.
How to save the CSV file as UTF-8 using Google spreadsheet
Google Spreadsheet correctly exports UTF-8 encoded CSV files by default. From the File menu, choose 'Download As' and select 'Comma-separated values'. The downloaded file will be UTF-8 encoded.
How to save the CSV file as UTF-8 in Microsoft Excel
Make sure you use the 'Save As' dialog to export the CSV file and explicitly select the ‘CSV UTF-8 (Comma-delimited)’ option when saving the file. Other options will not result in an UTF-8 encoded CSV file and will result in an error when uploaded to the Clipsource platform.
Follow these steps:
- Navigate to the File menu option and click 'Save As'.
- Click Browse to select a location to save the file.
- The 'Save As' window appears. Select .CSV (Comma delimited) (*.csv) as the file type (shown below) and enter the name of your file.
- Save your file
How to save the CSV file as UTF-8 in Apple Numbers
Apple Numbers allows you to select Unicode UTF-8 when exporting a CSV file, but it uses semicolons instead of commas as value delimiters. Therefore, you need to change all semicolons to commas before you can upload the file.
Follow these steps:
- Navigate to Archive > Export To > CSV.
- Under Advanced Options, select 'Unicode (UTF-8)' option for 'Text Encoding';
- Click Next. Enter the name of the file and click Export to save your file with the UTF-8 encoding.
- Open the file with TextEdit. Change all semicolons to commas and save the file.
Comments
0 comments
Please sign in to leave a comment.