Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Open CSV files which have UTF-8 coding from Excel on Mac and Windows.
- Here are the steps:
- Excel on Mac: please refer to this official article:
- https://support.microsoft.com/en-us/office/import-data-from-a-csv-html-or-text-file-b62efe49-4d5b-4429-b788-e1211b5e90f6?ui=en-us&rs=en-us&ad=us
- Excel on Windows:
- 1. Open Excel, search "Get Data From Text" to open a wizard when you want to open a CSV file.
- 2. Go to the location of the CSV file, that you want to import.
- 3. Choose Delimited, set the character encoding to 65001: Unicode (UTF-8) from the dropdown list.
- 4. Check My data has headers. You have to use it because the first row of CSV file has column names.
- 5. Click next to display the second step of Text Import Wizard.
- 6. Because our data is separated by commas, set the delimiter to a comma.
- 7. Click next to move to the third step.
- 8. Select the General column and then Finish.
- 9. Keep the default values inside the Import Data window and click OK.
Advertisement
Add Comment
Please, Sign In to add comment