• Word, Excel, and PowerPoint combined in one app:. The most widely used tools for working with documents, spreadsheets, and presentations, all from a single app. Create, edit, and work together on Office documents with others in real-time. Use templates to easily get started with your resume, budget, presentations, and other documents.
• Open the Word document you want to Excel worksheet, click File Save As command, then click Browse to open Save As dialog, choose one destination to place the new file, and in the Save as type drop-down list, select Plain Text.

DOC is a native MS Word text format that supports markup and rich text styling. As opposite to TXT, together with texts DOC file can contain various formatting parameters, tables, images, other graphic elements and charts. Documents of such type are readable by MS Word, free Microsoft Word Viewer and many open source packages like LibreOffice.

Linking from Word to Excel

You can use Word's HYPERLINK field to link from a Word document to an Excel workbook.

To link to a specific place in the Excel file, specify an absolute address or a range name.

You can create a clickable hyperlink in a Word document that will open up an Excel file. Sometimes you just need to open the Excel workbook. Sometimes you want the link to go to a specific place in the Excel workbook. This page explains how.

How to create a link to an Excel workbook

In your Word document, do ctrl-F9. Within the braces that word gives you, type the following:
HYPERLINK 'C:My DocumentsMyExcelFile.xls'

So it looks like
{ HYPERLINK 'C:My DocumentsMyExcelFile.xls' }

But note that you can't type the { } braces by hand. You must use ctrl-F9 and type between the braces that Word gives you.

Obviously, you need to replace the text between the quote marks with your own folder and file name. Be sure to use double back slashes (') in your path name.

When you're finished, press F9, which toggles between displaying the field codes (that you just typed) and the field result (which is the hyperlink).

When you click the link, Excel will run and will open your Excel workbook.

Click, or ctrl-click to link?

By default, you need to do ctrl-click to follow a hyperlink from a Word document.

If you don't like that, you can change it. In Word 2003 and earlier versions, do Tools > Options. On the Edit tab, un-tick 'Use CTRL + click to follow hyperlink'. In Word 2007 and Word 2010 do File > Word Options or File > Options. On the Advanced tab, in the Editing Options section, un-tick 'Use CTRL + Click to follow hyperlink'.

How to create a link to a specific place in an Excel workbook

You have two choices here. You can choose to link to an absolute address. Or, you can link to a range name.

How to link to an absolute address in an Excel workbook

In your Word document, do ctrl-F9. Within the braces that Word gives you, type so that it looks like the following:

{ HYPERLINK 'C:My DocumentsMyExcelFile.xls#MySheet!A1' }

If your sheet name contains a space, then you need to enclose it in single quote marks, like this:

{ HYPERLINK 'C:My DocumentsMyExcelFile.xls#'My Sheet'!A1' }

Alternatively, you can use the l (that's a lower-case L) switch to identify the range name:

{ HYPERLINK 'C:MyDocumentsMyExcelFile2.xls' l 'Sheet 1'!A1' }

How to link to a range name in an Excel workbook

To create a hyperlink to a Worksheet range name, use use ctrl-F9 and type so it looks like the following:

{ HYPERLINK 'C:My DocumentsMyExcelFile2.xls#'Sheet 1'!RangeName' }

To create a hyperlink to a Workbook range name, use use ctrl-F9 and type so it looks like the following:

{ HYPERLINK 'C:My DocumentsMyExcelFile3.xls#RangeName' }

However…..

Word wouldn't be Word if it were always that straight-forward! Excel gets confused if you have both a Workbook range and a Worksheet range with the same name. It seems to link to the range randomly. So, if you use range names, make sure they're all sheet-specific or all workbook-wide. Or use an absolute address.

How to add a screen tip to a hyperlink

You can use the o switch (that's a lower-case O, not a zero) to create a tooltip, like this:

{ HYPERLINK 'C:My DocumentsMyExcelFile3.xls#RangeName' o 'Click here to open MyExcelFile3' }

Related subjects

Topic: Word and Excel

Interest: For users

Version: Word 2000Word 2002Word 2003Word 2007Word 2010

Created April 2006. Last updated 21 July 2010.

Need to shift or convert MS Word data into Excel Worksheet? At the same time looking for some easy fixes to import Word documents into Excel without any software?

Even I also think that the task of importing Word document into Excel is best. As it keep you aside from the headache of Excel file recreation from the beginning.

Suppose you need to make a spreadsheet from the list or form which you have already made in MS Word. In that case the method of copy –paste every pinch of information from doc to xls gets quiet hectic.

Isn’t it…!

For such cases it’s better to have an idea of importing data from word to excel. As, this method will transform such bulky task into a simple one.

So, today through this post you are going to get easy and quick idea on how to import word to Excel.

To learn more advanced Excel functions visit Become Excel Master.

How To Import Data from MS Word to Excel:

Here are some easy tricks to import word document into Excel.

1. Single Cell Import

2. Import Data Cell by Cell

3. Convert Word To Excel Using “From Text” Option

Let’s discuss them on by one.

Method 1. Single Cell Import

• Start the Microsoft Excel > open Excel spreadsheet you need importing the word data into.
• After that click Insert tab > on the ribbon click Object button
• Now on the object window click “Create from File” > browse MS Word document to import.
• Double-click the file name > click OK to close Object window. Now you are brought back to Excel spreadsheet with Word file merged into it.

Please Note:Below the ribbon the cell text box shows =EMBED (“Document”,””).

• Next double click within the Word document for opening it and making it editable. Here the users can perform entire word features, even in the Excel-like modifying or reformatting text.
• Click File tab > choose Save As > rename existing Excel spreadsheet in place of saving over it (doing this will keep the non-merged version accessible) > click Save button

Method 2. Import Data Cell by Cell

By importing the data cell by cell, follow the steps given below.

• Open MS Word > open document with data table to import into Excel
• No click the small hatch marks in the table > press Ctrl + C to copy table > close Word document.
• Now open Excel > click cursor into the first cell grid > hit Ctrl + V keys to paste the Word table’s contents. From Word into Excel with similar cell layout, the data is exported. (For instance: if the Word table has two rows with three columns, then the Excel spreadsheet will show two rows with three columns. )

Well, this is all about how to import data from Microsoft word to MS Excel

Method 3. Convert Word To Excel Using “From Text” Option

If you are an Excel 2016 user then importing word data to excel is really going to get easy for you. Excel 2016 application offers one very helpful feature i.e “from text” to import or convert Word to Excel.

• Open your MS Word application first of all. After then go to the File option from the menu bar and then to the Save As option;
• From the drop down list of output format select the “Plain Text” format.
• After that tap to the “Save” option for saving up your Word documents just like a new text file;

• Now run your MS Excel application. From the toolbar select the “Data” and tap to the “From Text” option for importing off the Word text;

• After that select the “Delimited” option from the Import Wizard.

• Make changes in the setting as per your need and then tap to the “Finish” option.

• Choose any of your new worksheet or already existing spreadsheet. For importing word document data to excel and tap to the OK

• At last save your Excel file.

Note:

Above solution is recommended only when your word document is not filled with too much of data or table. As, this may take a lot of your time to make formatting and adjustments.

Bonus Tips:

• The Microsoft Word document is pasted into the single Excel cell, in the single cell import process.
• And the Excel resizes the grid to fit the cell that might be larger and display the data within the grid.
• This process is best for importing the whole Word document like proposals and you don’t require opening the Word document for performing the particular task.
• Well, the cell by cell data import process goes best for tables within the Word document.
• You can even edit the table’s contents, after pasting into Excel application.

Final Verdict

These are some quick ways through which you can import data from Word to Excel. Implement the given steps and make your work easy and as well save your precious time. This is very helpful to maintain data and other data in cells and rows.

So, whenever you need to transfer data from Word document to Excel, follow the given steps and make your data more presentable and easily understandable.

Microsoft Office Free Download

Excel is an essential application and used in daily life, so it is recommended to handle the Excel file properly and follow best preventive steps to protect your Excel files from getting corrupted.

Despite it, always create a valid backup of your crucial Excel data and as well scan your system with good antivirus program for virus and malware infection.

If, in case you have any additional questions concerning the ones presented, do tell us in the comments section below.

Good Luck….!

Ms Word To Excel Converter

Ms Word To Excel Converter Online

Ms Word To Excel Converter Software

Margret

Ms Word To Excel Converter Free

Margret Arthur is an entrepreneur & content marketing expert. She writes tech blogs and expertise on MS Office, Excel, and other tech subjects. Her distinctive art of presenting tech information in easy to understand language is very impressive. When not writing, she loves unplanned travels.