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.

  1. Using Excel, open a spreadsheet file via File > Open... (note: this can be a spreadsheet created using Excel or Calc)

  2. Save the file as a (csv) file via File > Save As > Browse

  3. Choose 'CSV (Comma delimited) (*.csv)' in 'Save as type:'

  4. At the bottom of the dialog, select tools > Web Options....

  5. 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.

  1. Using Calc, open a spreadsheet file via File > Open... (note: this can be a spreadsheet created using Calc or Excel).

  2. Save the file as a (csv) file via File > Save as... > Text CSV(.csv)

  3. 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).