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:
Read the following guide to translating Magento using translation memory/CAT tool (free)
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.
Listed hereafter some custom tools for editing CSV files: A GOOD + FREE program (actually a CardWare, meaning you have to send a postcard to the SW author) is CSVed, capable of ‘massaging’ CSV files anyway you want. There you find also uniCSVed with UniCode capabilites, limited to Windows 2K & XP, only. Also there: a brief but very interesting CSV introduction & tutorial Feel free to add here any more CSV programs for authoring, editing, etc...