This is a small presentation of a Static Translations Bundle I wrote for Symfony that made my hand hurt less.
If you ever created a Multilingual website with Symfony, you know that for every language you can create an xml file for hard coded strings. In every language file, there is a same
trans-unit element for every string that needs translation where the
target is the only different thing based on language.
<trans-unit id="post"> <source>Post</source> <target>Post</target> </trans-unit>
<trans-unit id="post"> <source>Post</source> <target>Enviar</target> </trans-unit>
Instead of copying every translation for every word in every language (that is a lot of
Ctrl+V) you create a simple google sheet that looks like this and forward it to whoever is in charge of providing translations. After you get filled excel you use the command that bundle provided:
php app/console generate:static:translations /path/to/excel/file languages
For more info about the bundle and more detailed instructions check here.