Link to home
Start Free TrialLog in
Avatar of Jim Lacey
Jim LaceyFlag for United States of America

asked on

Import Word Membership Report into Excel 2007

Import Word Membership Report into Excel 2007

Using the following 'Instructions', step 4 returns no data in Word file conversion window. Step 3 ['Click the "Advanced" tab...'] seems the cause of the problem. Attached 'Sample Membership Record.jpg' is a sample record (row) from MS Word 2007 table. If Step 3 is not done, output is available, but not delimited correctly.

As am trying to create a delimited [; - semicolon is delimiter] Excel 2007 input file, how do I proceed?


Instructions

1 Open a Word document you want to import.

2 Click the "Microsoft Office Button." Click "Word Options."

3 Click the "Advanced" tab. Under "Preserve Fidelity when Sharing this Document, click "Save Data as Delimited Text File." This feature will allow Excel to read the file you are going to import. Click "OK."

4 Click the "Microsoft Office Button." Choose "Save as." Under "Save as Type." Select "Plain Text." This will save the file as a .txt file. A file conversion window will appear. Click "OK."

5 Open Microsoft Excel.

6 Click the "Data" tab. In the "Get External Data," click "From Text."

7 Select the file you just saved in step 4. Click "Open." The Text Import Wizard will appear.

8 Select "Delimited" under "Original Data Type." Click "Next."

9 Select the delimiter you want to use. For instance, check "Comma" instead of "Tab" to see how it affects the conversion. Click "Next." Click "Finish."

10 Click in the first cell (A1) in Excel. Click "OK" to import the data.


URL: http://www.ehow.com/how_6455437_import-word-document-excel_.html#ixzz2Tw02jOhh
Sample-Membership-Record.jpg
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

The "Save Data as Delimited Text File" is actually labelled "Save form data as delimited text file". The missing word "form" is important because the process only saves the data that is in Form Fields. You haven't mentioned that your text is in form fields so I suppose that it isn't.

It does look as if the text might be in a table, but without seeing the document or a redacted sample part, we can't be sure.  It is possible to select a table in Word and to paste it into Excel.
Avatar of Jim Lacey

ASKER

How do I know if data is in table? Attempts to merge rows fails as there is no "Layout" tab or "Table Tools" in the Ribbon. I have tried several ways to select table, Ctrl-A, click upper left table corner, Select in Editing Menu - No Go
ASKER CERTIFIED SOLUTION
Avatar of GrahamSkan
GrahamSkan
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Solved by exporting to delimited text file.