Is it possible to convert Word tables in Excel tables?
Thread poster: Martine Etienne

Martine Etienne  Identity Verified
Belgium
Local time: 05:48
Member (2003)
English to French
+ ...
Oct 2, 2003

I am wondering whether it is possible to transform a word table (glossary) into an excel one. Excel is (for me) easier to use in this case and I have a rather long glossary in word.
If it is possible, could you explain it as for a six years old child, because that is what I am when I need to use my PC in an unusual way.
Thanks a lot


 

Ralf Lemster  Identity Verified
Germany
Local time: 05:48
English to German
+ ...
Copy & paste Oct 2, 2003

Hi Martine,
Have you tried to highlight the entire table, copy the contents into the clipboard and paste it into the Excel file?

Just tried it - works for me; it does depend on the table structure, though.

Good luck, Ralf


 

Cicero
United Kingdom
Local time: 04:48
Member (2008)
Japanese to English
+ ...
Copy and Paste Oct 2, 2003

Hi

Ralf is quite right. Copy and pasting will work. Prior to doing so, it is important to make sure that there are no paragraph breaks or tab breaks within the text in a table since this can alter the cell format in Excel. For example some cells can become merged or in some cases one column can be longer than another.

Best wishes

Didier


 

Martine Etienne  Identity Verified
Belgium
Local time: 05:48
Member (2003)
English to French
+ ...
TOPIC STARTER
saved... Oct 2, 2003

I had told that I was as a six years old chilg. I was trying to insert my word table in an excel file. Never thought to copy and paste. But it works...
Second times you save me...
Thanksicon_smile.gificon_smile.gificon_smile.gif


 

Alan Johnson  Identity Verified
Germany
Local time: 05:48
German to English
Yes. Oct 3, 2003

Although I'm not sure how well this works for complex tables (and as my Word is German, I'm only guessing the menu items in English).

Mark your table in Word. Go to Table, Convert, Table in Text. Select Tabstops in the dialogue box. Save the document as txt (Text only). Go to Excel, select File, Open, Text files. Select the file. In the conversion window select Separated (first choice), Continue, Tabstops, Continue. That should be it. Try it.

Alan


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Is it possible to convert Word tables in Excel tables?

Advanced search






SDL Trados Studio 2019 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2019 has evolved to bring translators a brand new experience. Designed with user experience at its core, Studio 2019 transforms how new users get up and running and helps experienced users make the most of the powerful features.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search