In Microsoft Excel
1. Open the *.xlsx file from Excel.
2. Click Menu | Save As (Other Formats).
3. Put any name for the file and choose “Unicode Text (*.txt)” for “Save as type :.”
4. Click Save.
5. Open the unicode text file using Microsoft Notepad.
– Some characters can look like a box, this is because Notepad can’t display some unicode characters, you can ignore this.
6. The file needs to be tab delimited, replace tabs with a comma (“,”).
– Select a tab character by dragging the character between two column headers and press ctrl+c.
– Replace all tab characters with comma using Replace function ctrl+H.
7. Click Save As.
8. Name the file, and change the Encoding: to UTF-8.
9. Change the file extension from “*.txt” to “*.csv”.
10. Click Save.
– The file icon should be changed to MS Excel now. If it is not changed, check Windows Folder options.
Back in Excel
11. Open the CSV file and verify if the data is okay.
– If you run into a problem in this step, don’t save the file in Excel, it’ll cause encoding issues. Just check the data only in Excel.
You can use this CSV file for importing through Import Wizard or Apex Dataloader. If you’re using the Import Wizard, make sure that you choose right encoding option “Unicode (UTF-8)” on “Upload the file” step.
If you’re still having encoding issues, you can try these steps:
1. Find the file.
2. Right click on the file | click Open With.
3. Click Notepad.
4. Click File | then Save As.
5. Navigate to the folder where you want to save your file.
6. Provide a name for your file.
7. Add .csv to the end of the file.
8. Make sure that the encoding is set to UTF-8.
9. Click Save.
10. Open the newly created file.
11. Make sure that everything is correct
You can make sure TextEdit saves files in Unicode (UTF-8) by going to TextEdit > Preferences… > Open and Save, and making sure the Save As setting is “Unicode (UTF-8)”.
Choose “Unicode (UTF-8)” for the Save As setting to ensure TextEdit saves documents in UTF-8