I'm sure others can pitch in with more details, but the general idea is to import the file as plain text, then use tagging/regex in order to exlude the non-translatable parts.

The instructions above were a good hint/start, but didn’t work instantly. After fiddling a bit around I had it set up rather quickly in memoQ.

You can download the exported filter rule for memoQ from our server. Just unzip the file and import it in the Resource Manager thingy. (If you don’t trust random files from strangers, just open it with a text editor, it’s really just a text file.)

This setup will also keep the comments out of your translation as they felt a bit too generic to really help IMO. Note this isn’t a filter chain, so you’ll still have to escape both linebreaks as \n and ANSI double quotes as \" to avoid script errors.

Alternative for those with just Office and similar programs:

• In a text editor like VS Code or Notepad++, that supports Search & Replace with regular expressions, look for the pattern ^(t\[\d+]\s+=)\s+(".*")\s+(--) and replace it with $1\t$2\t$3.
• Delete all lines at the start of the file that start with -- (i.e. all the comment lines).
• Open/import the file in your favorite spreadsheet editor (like Excel) and use Tab Separated Values (TSV) or TSV File as the file format.
• You should see the translation in the second column.
• No need to convert anything back, the file should run just fine.

Note this might screw with quotes in your text, so you should double-check them in a regular text editor once you’re done.

For Trados users, I created a new file type based on regex-delimited text with these regex patterns:
Opening pattern: .*=\s"
Closing pattern: "\s.*$
(I didn't manage to include the comments as tags.)