How to extract text snippets from Microsoft Word to Excel?

In Microsoft Word, I’ve got this template laid out like this: first name and last name (line 1), address (line 2), then phone number and email (line 3)
Followed by a blank line, and then the next entry begins.

Is there any way to automatically pull all this data and sort it neatly into Excel columns—specifically, one column for the full name, another for the address, a third for the phone, and a fourth for the email?

Thanks in advance

Ryan Watson43 said:I have a template set up in Microsoft Word: first name and last name on the first line, address on the second, and phone number and email on the third.
Then add a line break, followed by the next entry.

Is there a way to automatically extract data and organize it properly into Excel columns? I'm looking to have one column for full names, another for addresses, a third for phone numbers, and a fourth for email addresses.

Thanks in advance.

If you need to move data from a Microsoft Office Word table over to Microsoft Office Excel, there’s no need to retype everything manually. You can simply copy the data directly from Word and paste it into an Excel spreadsheet. When you do this, each cell from your Word table should land neatly in its own individual cell on the Excel sheet. Keep in mind, however, that you might need to do a little cleanup once the data lands. To actually use Excel's calculation features, the data needs to be formatted correctly. You’ll often run into small headaches like stray spaces, numbers that Excel treats as text instead of numeric values, or dates that aren't displaying properly. A quick scrub of the data usually fixes these issues so you can get to work.
In your Microsoft Office Word document, simply highlight the rows and columns of the table you want to move over to an Excel spreadsheet.
To copy your selection, just hit CTRL+C.
In your Excel spreadsheet, start by selecting the top-left cell of the area where you want to paste that Word table.
Before you paste anything, make sure your target range is completely empty. Any data coming from those Microsoft Office Word tables will overwrite whatever is currently sitting in the cells within your selected area. It might be a good idea to double-check the dimensions of your Microsoft Office Word table first just to be safe.
On the Paste tab within the Clipboard group, click Paste.
To adjust the formatting, click the Paste Options icon next to the data you just pasted, then follow these steps:
To apply the formatting from your current cells to a new area, just click "Use Destination Theme."
To use the table formatting from Microsoft Office Word, just click Keep Source Formatting.
When you paste content from a Microsoft Office Word table into Excel, it automatically places the contents of each cell into its own individual cell. Once you've finished pasting the data, if you need to split information up further—like separating first and last names into different columns—you can easily do that using the Text to Columns feature found under the Data tab in the Data Tools group.

Alternatively, if you're working with a spreadsheet, just select everything, hit copy, then use Paste Special -> Values to paste it.

Keith Jackson3 said:—or if you're working with a table, just select all, hit copy, then go to Paste Special -> Values...

Well, there are five distinct points there... except the guy isn't even asking the question being posed. 🙂

First off, take that Microsoft Office Word document content and paste it directly into Column A of an Excel spreadsheet. Assuming everything is laid out exactly how you described, your names should fall into rows 1, 4, 7, 10, and so on; addresses would be in 2, 5, 8, 11; and the phone numbers/emails would land in 3, 6, 9, 12. It’s a pattern, I suppose.

It's just a few steps, really.

1. To start things off, go into cells E1, F1, and G1 and enter these formulas respectively:

=INDIRECT(ADDRESS(4*ROW()-3;1))
=INDIRECT(ADDRESS(4*ROW()-2;1))
=INDIRECT(ADDRESS(4*ROW()-1;1))

Then, just drag those formulas down as far as necessary to cover the entire range of your data.

2. Highlight columns E, F, and G, click Copy, move over to cell J1, and select Paste Special -> Values. This converts those formulas into actual static data.

3. All that's left is splitting the phone number from the email address: highlight column L, head to the Data tab, select Text to Columns, choose Delimited, pick Space, and hit Finish (this assumes, of course, that there is a space separating the two).

That should do the trick. Once you're done, you can just copy these columns wherever they need to go—or, if you want to keep things clean, delete all the columns to the left since they aren't needed anymore.

Byron, absolutely brilliant!
Even though I neglected to mention that I’m working with Apache OpenOffice rather than Microsoft Office—which necessitated an extra little detour involving copying and pasting everything into a .txt file first—I managed to pull off exactly what you suggested... everything worked perfectly.

Thanks a million!