[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

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
0
MARSPATH
Asked:
MARSPATH
  • 2
  • 2
1 Solution
 
GrahamSkanCommented:
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.
0
 
MARSPATHAuthor Commented:
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
0
 
GrahamSkanCommented:
If the Layout or Table tools tabs don't appear when the cursor is in the structure, then there may not be. However it looks like a table with double borders - there are even like cell delimiters: ยค at the end of the text in each 'cell'.
0
 
MARSPATHAuthor Commented:
Solved by exporting to delimited text file.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now