How to move a table from Excel into Word without error

Make calculations and draw up a table more conveniently in Excel if you want to work with numeric data. In fact the program is a table. Word for such work is not quite fit.

But sometimes you have to migrate from an Excel table to Word. Also you may need to convert filled data. Converting from one format to another is unproductive and takes too much time. There should be another way.



How to move a table from Excel to Word?

The first method.

  1. We have a table with three columns and five rows. The boundaries are set.
  2. The boundaries are set.
  3. Select the data range. Click Copy in the main menu. Alternatively use the key combination Ctrl + C. Also you may select table and click the right mouse button. Than choose and click «Copy».
  4. Copy.
  5. Open the Word List. In the main menu use «Paste» tool. Select the «Paste Special».
  6. Paste Special.
  7. We set the parameters of a special paste. «Paste Link» - «Microsoft Excel Worksheet Object». Check is the source for insert selected correctly. Click OK.
Paste Link.

The result of our work:

The result of our work.

This method has some drawbacks:

  • table inserted as a graphic object that is it cannot be edited.
  • border spreadsheets may extend beyond the sheet.

The second method.

  1. Select a table in MS Excel. Copy it to the clipboard.
  2. Open MS Word. Click «Paste» or use the key combination CTRL+V (Shift+Ins). The result is next:
The result is next.

We can edit the data, change borders, font values and format.

This method of insertion has one significant drawback. Table with a large amount of data goes beyond the sheet.

The third method.

  1. Go to the tab «INSERT» in In Word sheet. We need the menu «Text» and the tool «Object».
  2. Object.
  3. Select «Create from File» in the dialog box. Click «Browse» to find the text file Prodic1.txt.
  4. Create from File.
  5. In the «File name:» line will be its data when the desired object will be found. Click OK.
File name.

The inserted table is a graphical object. You cannot edit the values in the cells.

You should first remove borders to insert a range of data without boundaries.

In MS Excel:

In MS Excel.

Or use a combination of keys CTRL + SHIFT + (minus).

In MS Word:

In MS Word.

If you want to manipulate the boundaries must be inserted with the 1 and 2 method.



How to convert a table from Word to Excel?

We’ll perform a reverse transfer.

Method 1.

  1. Select a table in MS Word. Click «Copy» CTRL+C.
  2. CTRL+C.
  3. Open MS Excel. Put the mouse in the place where the table should appear. Click «Paste» after right click.
Paste.

We have a "neat" table. Therefore it inserted smoothly and accurately. If the data were filled ugly with a lot of extra characters (non-printable) so the row and column boundaries may shift. There are 2 outputs to escape from this situation:

  1. Clean the data manually. If there are a lot of recurring characters you can use AutoCorrect Options.
  2. Save the spreadsheet as text (in txt format). In this case all the extra characters will be deleted. And then insert the data from the txt to Excel.

Method 2.

  1. Select the table in Word. Menu «TABLE TOOL» - «LAYOUT» - the tool «Convert to Text». In the parameters of the transformation choose «Tabs».
  2. Convert to Text.
  3. Go to the main menu – «Save as» - «Save as type». Choose file type «Plain Text (*.txt)».
  4. Save as type.
  5. Open Excel. «DATA» tab. «Get External Data» - «From Text».
  6. From Text.
  7. Now find the saved file. Click «Open». And then the «Text Import Wizard» opens.
  8. Text Import Wizard.
  9. Set the desired conversion settings. Choose data format with delimiters. Separator character is a tab character. Done.
Done.

You can edit the data and draw border etc. This method of insertion removes the extra characters and prevents displacement of the cells.


en ru