Convert MS Word 2003 table to MS Excel 2003
Thread poster: Antoinette-M. Sixt Ruth

Antoinette-M. Sixt Ruth  Identity Verified
Local time: 09:50
English to German
+ ...
Sep 4, 2005

Could somebody provide a quick fix for me for the conversion of Word 2003 tables to Excel 2003?
Thanks.
Antoinette


 

xxxtlmurray
Local time: 10:50
English
Try a plain copy-paste Sep 4, 2005

Generally, a copy and paste works pretty well. Have you tried that?

 

Ken Cox  Identity Verified
Local time: 16:50
German to English
+ ...
copy/paste or... Sep 4, 2005

Copy/paste works well if the table is simple (no merged cells) and the cells do not contain any manual end-of-line characters or paragraph (Return) characters.

Another option that might be more convenient for a large table (to save you the trouble of counting cells) is:

1. If necessary, select the table in the the Word document and then copy and paste it into an empty document.

2. Select the table, then select 'Convert table to text' in the Table menu. In the 'Convert Table to Text' window, select 'separate text with commas'.

3. Save the word document as an ASCII file (.txt format).

4. Change the file extension of the saved file to 'csv' (the 'native' format of Excel documents).

5. Open the .csv document and then save it as an Excel document.

The above procedure will also only work with 'simple' tables whose cells do not contain manual end-of-line or Return characters.

Maybe Word 2003 has an option to export a table to Excel (I use 2000, so I wouldn't know).


 


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

Moderator(s) of this forum
Fernanda Rocha[Call to this topic]

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

Convert MS Word 2003 table to MS Excel 2003

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
TM-Town
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.

More info »



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