Translation - art & business » Off topic »
Convert MS Word 2003 table to MS Excel 2003
Thread poster: Antoinette-M. Sixt Ruth
Antoinette-M. Sixt Ruth
Antoinette-M. Sixt Ruth  Identity Verified
Local time: 23:30
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
 
tlmurray (X)
tlmurray (X)
Local time: 00:30
English
Try a plain copy-paste Sep 4, 2005

Generally, a copy and paste works pretty well. Have you tried that?
 
Ken Cox
Ken Cox  Identity Verified
Local time: 06:30
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 t... See more
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). ▲ Collapse
 


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






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

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 »