Useful Tools to work on Translations

Last modified by WisdOMbooks on Wed, December 12, 2007 23:53
Source|Old Revisions  |  Back To Group

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.

Electronic spreadsheet editors

Most of the spreadsheet editors can import, export CSV files and are able to edit them.

OpenOffice Calc

Calc is an electronic spreadsheet editor that is a part of 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 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).

Microsoft Office Excel

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: FIXME

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


Magento 2 GitHub Repository

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs