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

Antoinette-M. Sixt Ruth  Identity Verified
Local time: 16:47
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: 17:47
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: 23:47
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






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 »
LSP.expert
You’re a freelance translator? LSP.expert helps you manage your daily translation jobs. It’s easy, fast and secure.

How about you start tracking translation jobs and sending invoices in minutes? You can also manage your clients and generate reports about your business activities. So you always keep a clear view on your planning, AND you get a free 30 day trial period!

More info »



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