Convert a Word file with figures to Excel

Posted on 2011-03-02
Medium Priority
Last Modified: 2012-05-11
Dear All

Is there a piece of software that easily converts a word file with lots of figures to Excel please?

Question by:lloydabberton
  • 4
LVL 10

Expert Comment

by:Christian de Bellefeuille
ID: 35016771
Have you tried to only select all your pages (CTRL-A), and do a copy paste into excel?

Because with Office 2010, everything seems to be copied...  and between 2007 and 2010 there must not be so much difference.  Give it a try
LVL 10

Expert Comment

by:Christian de Bellefeuille
ID: 35016805
There's also a program named "File Conversion Wizard for Word and Excel" who claim to do what you are asking for, but i've never tried it.

Here's a link to download it
LVL 33

Expert Comment

by:Paul Sauvé
ID: 35021119
Hi Lloyd,

When you CUT & PASTE from Word to Excel, it works if your Word data is in a table, otherwise you get one cell of Excel for each line in Word.

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 77

Expert Comment

ID: 35021516
It would help if you were to post a sample document.
LVL 10

Expert Comment

by:Christian de Bellefeuille
ID: 35021689
@Paul: Wrong.  With Word & Excel 2010, you can copy data from Word and paste it in Excel 2010, and your data is not placed all in a single cell as you say.

I write: "Hello" ... then 2 lines bellow "World".  I copy everything to the clip board, do a paste into excel and on line 1 i got "Hello", and line 3 "World".
LVL 10

Accepted Solution

Christian de Bellefeuille earned 1000 total points
ID: 35021705
Well, maybe not wrong...   since he posted that in Word 2007.  Sorry for that.   But it work perfectly in 2010.

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

What to do if a split doesn't fit? Or a bunch of invoice lines must be rounded while the sum must match a total? It takes a little, but - when done - it is extremely easy to implement.
As a person who answers a lot of questions, I often see code that could be simplified, made easier to read, and perhaps most importantly made easier to maintain if the code was modified to use the Select Case statement. This article explains how to…
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question