When opening any file, Microsoft Excel is trying to find the proper encoding automatically. However, CSV files usually have no such information as they are just plain text. Therefore you need to help Excel choose the correct encoding to open the CSV file. To view the hidden characters, modify your settings in Microsoft Excel:
- Export the translation from Etranslate.
- Open the saved file in Microsoft Excel.
- Click the Data tab.
- Click From Text.
- Select your translation export file.
- Select Delimited, then make the following changes:
Start Import at Row "1" File Origin: "65001: Unicode (UTF-8)"
- Click Next.
- In 'Delimiters', select Comma.
- Click Finish.
☞ For more details
Can not work? 2 further solutions are below.**
Use Excel 2019 to edit the CSV file.
If you are using an older version, kindly change the default editing language to the target one.
Not satisfied with this page? please contact us for more customizations!