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

Martine Etienne  Identity Verified
Belgium
Local time: 16:39
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


Direct link Reply with quote
 

Ralf Lemster  Identity Verified
Germany
Local time: 16:39
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


Direct link Reply with quote
 

Cicero
United Kingdom
Local time: 15:39
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


Direct link Reply with quote
 

Martine Etienne  Identity Verified
Belgium
Local time: 16:39
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...
Thanks


Direct link Reply with quote
 

Alan Johnson  Identity Verified
Germany
Local time: 16:39
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


Direct link Reply with quote
 


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






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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