TOOL: XLSX to TRS

[ryu]

I created a small web tool for the AGS community that takes translations from an Excel spreadsheet (in XLSX format) and injects them into an existing Adventure Game Studio TRS file.

It runs directly in your browser. No files are uploaded to any server, and all processing happens locally. Here is the link:

https://tools.rubenlopez.eu/en/xlsx2trs/

By default, it does not overwrite existing translations. If you want to do that (for example, for a proofreading pass), there is a checkbox you can tick. In any case, remember to make backups and only overwrite your previous TRS file once you have reviewed the results.

Although I am not a very active AGS user myself, I occasionally help friends who are, and that is how I ended up making this tool as well. I reused some code from my own engine, which has a web-based editor. That is why this tool runs in the browser.

The tool is not open source, because at the moment it reuses a lot of infrastructure from my website which I don't want to open source, but if I find the time to disentangle it, I'll open-source the converter and maybe host it directly on github.

As a side note, maybe it would be a good idea to have something like this directly in the AGS editor. The TRS file format is not very convenient for i18n teams to work with.

[Crimson Wizard]

As a side note, maybe it would be a good idea to have something like this directly in the AGS editor. The TRS file format is not very convenient for i18n teams to work with.

AGS 4.0 works with PO format now:
https://www.adventuregamestudio.co.uk/forums/ags-engine-editor-releases/ags-4-0-early-alpha-for-public-test/

[Laura Hunt]

I helped test this tool with my game's own translation and I have to say that it's an absolute godsend. I was having nightmares, cold sweats and panic attacks just thinking about having to move all the translated text from my Google Sheets file back to the .trs file and this does it in a single click!

It also has super useful stats that show up once the conversion is applied, and it helped me find so many little mistakes that were breaking my translation, such as extra blank spaces, or a comma here, a missing full stop here. So thank you once again @ryu for one of the biggest QOL improvements to AGS that I (and I'm sure many others) could have wished for <3

[Postmodern Adventures]

I remember spending countless hours copying and pasting lines from the translation Excel file of An English Haunting into the .trs file. I was a tester of this tool too, just like Laura and it only took a second for all the translated lines from the Excel file of The Dark Rites of Arkham Demo to be imported into the .trs file.
Witchcraft!

[Chomba]

It is incredibly useful for those of us who are thinking of translating our games, as well as simple and fast . Thank you very much ryu! 

[Danvzare]

That's a pretty awesome tool you've made. 

I hope you do eventually disentangle it from your website, because it'd be brilliant to have an offline version.
Still, this is great. Thanks for sharing it.