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

Antoinette-M. Sixt Ruth  Identity Verified
Local time: 05:46
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


Direct link Reply with quote
 
xxxtlmurray
Local time: 06:46
English
Try a plain copy-paste Sep 4, 2005

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

Direct link Reply with quote
 
Ken Cox  Identity Verified
Local time: 12:46
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).


Direct link Reply with quote
 


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






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
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 »



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