How to import .csv file to excel?

​1. Open a new Excel document and navigate to the Data tab.

2. Click “From Text”.

3. Select the CSV file you wish to open.

4. From the newly-opened window, choose “Delimited”. And select the file origin as “UTF-8”. Then click “Next”.

5. Check the box next to “Comma”.

6. You could select the data format for each column. Please select Text for External ID, if not excel will change the PSID as it has exceeded 15 characters. Click “Finish”.

7. Select where you would like to put the data.

8. Able to display Chinese characters or PSID in Excel now.

• Related Articles

• How to import members to Stella?

  If you already have an existing member list from another source, you can import these members (in .csv format) to Stella. For more details, please refer to the guide here. Please save the file as CSV UTF-8 to display Chinese Characters. You could ...

• What can we do if there are many mojibake or corrupted data in the exported data file?

  You will need to use import the csv file to excel with UTF-8 if there is any Chinese character. It will be caused the mojibake or other error if you open the csv file directly. Please refer to the guide here on how to import the file to excel ...

• What can I do if I have error display on Chinese characters for the imported members?

  The error could be caused by you have saved Chinese characters directly in a csv file. Please save the csv file as CSV UTF-8 to display Chinese Characters and import the file to Stella again. You could also use Google sheet to export the .csv file in ...

• Why I cannot view the video sent by my customer in Zendesk? Is there any maximum file size?

  Yes, the current maximum file size that can be viewed in Zendesk is 6 MB. The following error will be displayed in Zendesk if the file has exceeded this limit, please view the file in the conversation history in Stella.

• What files can I use to upload to the Datasource?

  Currently we only support the .csv files for importing to the Datasource. Please click here for related documentation. Please save the file as CSV UTF-8 to display Chinese Characters. You could also use Google sheet to export the .csv file in UTF-8 ...