Useful Tools to work on Translations
This is an old revision of the document!
Each Magento translation consists of a number of CSV files. Here you can find a few useful tools that might help you to work on them easily.
Please feel free to update this page and add the tools that can help community members to translate Magento in multiple languages.
Most of the spreadsheet editors can import, export CSV files and are able to edit them.
Calc is an electronic spreadsheet editor that is a part of OpenOffice.org office suite. Openoffice is a multiplatform and multilingual open-source office suite. The product is free to download and use. You can find and download a binary or package for your operating system on the OpenOffice.org project official site.
When you will try to open CSV files in Calc it will show you a dialog, where you will be able to select/modify CSV import settings. The required settings to work with Magento CSV files are encoding (Unicode UTF-8), fields separator (comma) and text separator(double quotes).
Excel is a part of Microsoft Office software suite. You can find more information on it on the Microsoft Office Excel official homepage. Excel CSV-import and export setting depend on system wide regional options. In order to be able to work with CSV in Excel you have to modify them in the following way:
If you are a geek and you really know the CSV format specification, you may use any text editor that supports Unicode to edit CSV-files directly.
I don’t know any custom tools for editing CSV files at the moment.
I hope that someone might know more
May I suggest a wonderful FREE program
(actually CardWare, meaning you have to send a postcard to the SW author)
called CSVed, capable of ‘massaging’ CSV files anyway you want.