This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Transforming a Wordfast TM (txt) into an excel file
Thread poster: Doris Wolf
Doris Wolf Germany Member (2010) French to German + ...
Nov 18, 2015
Hello,
I am asked to put the content of my Wordfast TM into an excel file. Has somebody an idea how I can proceed without spending hours? Thank you in advance!
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Tony M France Local time: 10:27 Member French to English + ...
NORMALLY speaking...
Nov 18, 2015
You should be able to do this quickly and simply:
1) Open the TM's .txt file in something like Notepad++ or other text editor.
2) Ctrl-A to select all and Ctrl-C to copy it
3) (with Excel already running with a blank, new spreadsheet) Ctrl-V to paste the contents of the clipboard into the blank spreadsheet
4) If necessary, delete the 'empty' columns that represent the various attributes fields etc. that you may not even have used in your TM.
5) Delete the TM header row.
6) Save the .xls file with the name of you choice.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Doris Wolf Germany Member (2010) French to German + ...
TOPIC STARTER
Many thanks!
Nov 18, 2015
Hello,
Thanks a lot for your answer. This has worked much more easy than I have thought. To be honest, it already had worked yesterday in the afternoon when I tried but I didn't realize because the text only started in line 934 of the excel file while the lines above were empty
Thank you again!
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
B D Finch France Local time: 10:27 Member (2006) French to English + ...
Even easier
Nov 18, 2015
All you need to do is open the .txt file directly in Excel (right click on the file in File Explorer and select Open With and then Excel) and then save it as an Excel file.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Adrien Esparron Local time: 10:27 Member (2007) German to French + ...
Agree with B D Finch's suggestion
Nov 18, 2015
Then delete the first row and the colums A,B,C,D and F if you need only the source and the target. E is the source and G the target. Save this new file.
Regards
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
In that post, I use Heartsome to convert from Excel to TMX.
If you want to open your Wordfast TM directlty in Excel, you would probably want to make sure the source and target columns are explicitly imported as text. Otherwise Excel may attempt to interpret some segments of the TM as formulas, based on their content, and you will end up with errors. If you are not doing a round-trip, this probably doesn’t matter much.
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime.
Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device.
Find the right word anywhere, anytime - online or offline.