Creating and Editing Translation Content CSV Files
We have explored two tools for editing and creating translation content, Microsoft Office and Open Office Calc. Both tools are able to save UTF-8 encoded (csv) files.
Microsoft Excel (Office 365 Version)
Microsoft Excel is a popular spreadsheet software solution that is widely adopted in many industries.
Using Excel, open a spreadsheet file via > (note: this can be a spreadsheet created using Excel or Calc)
Save the file as a (csv) file via > >
Choose 'CSV (Comma delimited) (*.csv)' in 'Save as type:'
At the bottom of the dialog, select > .
Select the 'Encoding' tab and choose to save this document as: Unicode (UTF-8).
Open Office Calc
It is free and can be downloaded from www.openoffice.org.
Using Calc, open a spreadsheet file via > (note: this can be a spreadsheet created using Calc or Excel).
Save the file as a (csv) file via > >
When saving a (csv) file, Open Office Calc will ask which character encoding you wish to use for the file, be sure to choose Unicode(UTF-8).
