How to redo the document from Excel in Word. Instructions for transfer of tabular data Excel to Word

EXEL spreadsheets are considered a very convenient tool and presenting various tabular information. But when organizing work documentation, it is sometimes necessary to show information in the "Word" format. How to translate "Excel" in "Word"? Often the need to translate not only the information itself, but also insert document formatting. There are different ways.

How to insert information from the document "Excel" in "Word"?

The example shown is one of the best for the preparation of working documents, but does not allow to manage formulas, which will significantly complicate the subsequent recalculation.

If there is a need to translate in the form of a JPEG file, you will need to deploy the window to the entire screen and maximize the graph for a better view. By pressing the "PRINT SCREEN" key, save the image snapshot in JPEG format, open the Paint program on the computer, insert a snapshot into it and save "JPEG format". Open the Word document and on the Insert tab, in the group "Illustration" click "Figure". Select the file saved in the Paint and click "Paste".

Merge tool

Effectively binding Excel data from Word using the Merge tool

An example of the operation of the "Merge" tool: there is a group of contracts that must be signed, and every time you prepare a new treaty in it have to change some parts, such as room, surname, company name, amounts. To quickly edit and replace the data, the Merge tool is used, which is located in Word on the "Mailing" tab, in the "Start Merge" section. This section selects the "Step-by-Step Merge Wizard" command.

After selecting the command, a special field will open on the right side of the document, it will be asked to pass 6 steps. Select "Letters", "Current Document", "Using a list" - a list of data that is in the Excel file. We find this file, click on it twice, and in the "Merge Recipients" window will display all cells captured on this sheet. In this window, you can enable or disable cells. When you click on "OK", the connection between Excel will be created. After that, it will be necessary to configure those places in which cells from Excel will be inserted. To do this, use the "Insert Field of the Merge" command, select the necessary items: "FULL NAME", "Treaty", "End", "Amount". After that, in the selected items of the contract, the data in the Excel table occurs. This method simplifies and speeds up the workflow to create contracts.

As a conclusion

To date, there are several ways to insert how to translate Excel in Word.

It is possible to convert Excel information in its source format or convert to the Word. Also Excel can be exported in RTF format, keeping the size of columns and lines. Information in Excel can be saved as a drawing, and then import to Word. You can use the "Merge" tool.

When it becomes necessary to quickly create any table, it is better to use the Microsoft Excel program. It is originally designed to work with them. It is easy and easy to do what I want. But sometimes you need to save the table in the Vordovsky file. Here we will look at how to transfer the table from Excel in Word.

Insert the Excel table in Word is quite simple, but there are a number of features. Often the sign is not included on the sheet or simply floats abroad fields.

There are two main ways to transfer table from Excel to Word:

Simple copy source (via Ctrl + C) and ordinary insertion via Ctrl + V.
Insert Tables as an object through a special insert.

First method

If the table is small, then it is easy to transfer from Excel in Word simple copying. To do this, it must be highlighted and using the Copy button in the menu or Ctrl + C keys to put in the clipboard. After that, in the Word, just press the insert button or Ctrl + V.

At the same time, the insert parameters icon appears in the lower right corner, which allows you to view how you can convert data. The following methods are offered:

Save the original format.
Use the style of the end table.
Insert like a draw
Save only text.
Save the original formatting and associate with Excel.
Use the style of the end table and connect with Excel.

If, with normal insertion, the nameplate looks incorrectly, you need to use the proposed options and choose the appropriate. With the usual copying, the obvious disadvantage is the insertion of the insertion of the original: so intervals, fonts, borders may differ from the source.

If the label has been not formatted in the exile, then you can enjoy beauty in the Word. To do this, using the right mouse button to find the right action. For example, set the border or change the fill.

Second way

You can transfer a sign from Excel to Word as an object. This makes it possible to get an accurate coincidence with the source. To do this should be used Special insertwhich also offers different options. Choose the first - sheet Microsoft Office Excel (object). Here is the ability to choose: just insert an object or tie it with the source. In the first case, it is possible to edit the data as in the Excel sheet, the second method is mainly used if the connection between the programs is needed. That is, when changing data in Excel, they were updated in Word.

Troubleshooting when transferring a table from Excel to Word

The most frequent problem is the transfer of a large table. It can be very long or very wide.

Insert a long table

A long table is more convenient to insert as an object. But when selecting a Microsoft Office Excel sheet (object), data circumcision occurs. Rather, only those data that entered one page is displayed on the screen. And Word works only with what sees. Therefore, to eliminate this unpleasant situation, it is necessary to use a special insert with the parameter RTF text. In this case, the plate is visible all, located on several pages, while possesses with all the features: it is edited, moves and you can connect to the source file.

Insert a wide table

To insert a wide table in the Word program, you need to reconfigure the orientation of the page with the books on the landscape and set the minimum fields (0.5 cm). After that, you can use a special insert, pre-copy the source code. If the data is not in width, then you have to manipulate the scale. When you press the right mouse button on the inserted object, the context menu opens, the scale is on the path: the object format is the size. It is necessary to place the data on the sheet so that they are in width.

Insert from Word.

There is another method of inserting an exesel plate. In the Word program, you need to select the insert - the object - text from the file. Select the file name and insert.

In earlier versions of the Word program, the path for this procedure will be the following:

The contents of the list1 of the Exeline file is inserted into the Word program, so it is necessary that the desired information needs on the source sheet.

The impact of the versions of the programs on the transfer of tables

Of course, the software interface differs significantly from the version to the version, so there are nuances in each implementation. But the methods of transferring the table from Excel in Word remain the same.

In early versions of programs in normal copying and inserting you can not see the icon Insert parameters. It appeared already in the 2007 version, so you will not work in the conversion options in 2003.

However, in any version of the programs, you can find an acceptable option to work with the tables, for this it costs a little experiment. After all, it is not for nothing that the proverb says: "without difficulty caught and fish out of the pond."

Sometimes, the user needs to be transferred not only to the text from another file to the Vordovsky document, but also a graphic object. It can be a graph, an image or even a table. That is why in our article we will examine several ways to transfer the table from Excel in Word.

What are the difficulties in transferring the table? The first complexity is to change the formatting of the table when transferred. Simply put, when copying an object, columns and lines shift, because of which the table loses its appearance and it brings the user a lot of inconvenience.

How to transfer a table from Excel in Word: Method number 1

We will analyze an example in which we have a table with three columns and five rows, with the established boundaries.

To begin with, we highlight a graphic object. To do this, the user must click the "Copy" button on the toolbar in the main menu. Either use the CTRL + C key combination. You can copy the object and other ways: just click on the allocated table with the right mouse button, and then click "Copy".

After that, we open the Vordvian document where it is necessary to put an exesel table. Then, on the toolbar, choose the section called "Box". The user must select the "Special Insert" item. The user needs to specify its parameters. "Tie" - "Microsoft Office Excel sheet". At the end, press the OK button.

However, despite its simplicity, this version of work carries several drawbacks. First, the table will be inserted into a document as a graphic object, so the user cannot edit it. Secondly, if the table has a wide format, it can go beyond the fields of the Vordsk page.

Method number 2.

To begin with, the user must highlight the table located in MS Excel. It must be copied. How exactly - we have already written above. Next, open the Vordvian document and click the "Paste" item. Insert the table is possible using the simultaneous pressing of the two "SHIFT + INS" keys.

Using this method of moving the table, the user can edit the table, change its values, borders and font. It has such a method and disadvantage: wide format tables can go beyond the List of the Vordovsky Document.

How to transfer a table from Excel in Word: Method number 3

In order to use the third way to move the table, the user needs to perform the following actions algorithm:

The table that will appear in the Vordvian document will be presented as a graphic object. It will be impossible to edit it.

Insert the table in the Word 2010

First you need to select a table in Excel, which you want to place a WORD document. It must be highlighted: or using a mouse, or using the key combination (Ctrl + C). Next, the user needs to go to the Words document where the table is required. Install the cursor, and then select the "File" section on the toolbar, then "insert". After that, in the "insert parameters", you need to select "Tie and use the final styles". After that, in the Word Document to accommodate the table.

Insert the table in the Word 2007

The first steps in this method are also concluded in copying the Exeleian table. After that, you need to go to Word document. Next, go to the toolbar: the item "Home", then "insert", after choosing the "Special Insert" item. Then, in the window that appears, the user will have to set the switch to the item called "Tie". In the "How" window will need to select the object of the EXEL sheet. Finish the job by pressing the OK button. In the Word of 2003 we go to the "Edit" and choose the item "Paste". The table will be inserted into the Vordvian document.

To begin with, you need to understand how the application converts the document. When you import a document in Excel, the program determines which information fragment will be placed in a separate cell of the table using specific characters in the text. By formatting data in a document before importing, you can monitor the appearance of the final table and minimize the need to format the document manually. This method is convenient if you need to import a large list from Word document to Excel Table.

This method is especially effective if you import a list of multiple elements of the same format (list of addresses, phone numbers, email addresses, and so on).

Check the document for formatting errors. Before starting the conversion process, make sure that all the list items have the same formatting. If necessary, correct possible punctuation errors or stop elements that do not match the rest. This will ensure proper data transfer.

Turn on the display of formatting signs in Word. Displaying hidden formatting signs will help select the optimal way to split the list items. To display formatting signs, click the "Display All Signs" button in the Home tab, or click CTRL + Key Combination ⇧ SHIFT + *

In most lists will stand or one paragraph sign at the end of each row, or one at the end of the line and one in an empty string between the elements. You will use these characters to insert the characters that the Excel application uses to distribute data on the table cells.

Remove the marks of the paragraph between the elements to get rid of empty lines. An Excel application uses empty strings between the list elements to identify individual lines with data, but now they need to be removed so that the formatting process passed correctly. Do not worry, a little later you add them again. This method is appropriate in cases where one paragraph sign stands at the end of the list item and one - in an empty line between items (two in the row).

Enter in the search field ^ p ^ p. This code designation of the two paragraph characters in the row. If each list item consists of one solid string, and there are no empty strings between the elements, use the ^ P command.
In the Replace field, enter the split sign. This sign should not be repeated anywhere else in this document. For example, you can use a sign ~.
Click the Replace All button. You will notice that all the list elements merged with each other, but should not worry, because dividers (after each element) are placed in the appropriate places.

Highlight each item in a separate field. Now that the list items are divided so that they are displayed in serial lines, we need to designate which data will be displayed in each field. For example, if the first line of each element shows the name, in the second address, and in the third - region and the zip code, you can

Press Ctrl + H To open the Find and Replace Window.
Remove one of the signs ^ P in the Find field.
Change the sign in the field to replace the comma.
Press the Replace All button. The remaining signs of paragraphs will be replaced by commas, which will allocate each line in a separate field.

Replace separators to complete the formatting process. When you follow the two above-described search and replacement steps, your list will no longer look like a list. All information will be represented by one continuous string, and its fragments will be separated by commas. The latter search and replacement operation will return to your type of list, while individual fragments will be divided by commas.

Press Ctrl + H To open the Find and Replace Window.
In the Find field, enter the symbol ~ (or another character you selected earlier).
In the Replace field, enter ^ p.
Click the Replace All button. All items of your list will be broken into separate groups separated by commas.

Save the document as a simple text file. Now that formatting is complete, you can save a document as a text file. This will allow the Excel application to read and analyze the data and place each fragment in the appropriate field.

Go to the File tab and select "Save As".
Open the "File Type" drop-down menu and select "Normal Text".
Enter your file name and click the Save button.
If the File Conversion window appears, simply click OK.

Open the file using the Excel application. Now that you saved the file in the form of ordinary text, you can open it using the Excel application.

Go to the File tab and select Open.
Open the "All Excel Files" drop-down menu and select "Text Files".
In the Text Wizard (Import) window, click Next\u003e.
In the Dividers list, select "comma". In the preview window you will see how the items of your list will be divided into the table. Click Next\u003e.
Select the data format for each column and click Finish.

Word is a very powerful editor to work with the text. But sometimes we have to use two programs at once - create tables in Excel, and continue working into a Word. In this article, we will look at how to convert Excel in Word. It is worth noting that the excel cannot save a book in DOCX format. Even if you try to do it through exports - you still will not work. But there are many other working methods. Consider the most basic ones.

In Excel editor, there are several options for copying information. Consider them in more detail.

Using the context menu

In order to use this method, you need to perform the following steps.

Select the entire amount of data.

Make the right mouse click on the dedicated area. In the menu that appears, select "Copy".

As a result, the table is highlighted by a dotted line.

Go to Word.

Press the keyboard to the hot keys Ctrl + V. The result will be the following.

As you can see, everything was copied very well. But during the transfer there was a loss of the original lines. More precisely, the column width remained the same, but the text did not fit. The fact is that indents are added in the Word, which in Excele did not have. That is why it is not recommended to do so that the text is as pressed as much as much as possible to the edges, because everything can move.

Return to Excel and slightly increase the size of the speaker with "FULL NAME".

Now again repeat the steps described earlier. This time everything should look much better.

Hotkeys

Copy the desired range of cells can also be in a different way. At the same time, it is much faster.

Highlight the table.

Click on the hot keys Ctrl + C. As a result, the dotted frame should appear around the table, which will move clockwise. This is a sign of what you did everything right.

Go to Word. Press the Ctrl + V button combination. As a result, there will be exactly the same transformation.

No matter how you copied cells. When you click on Ctrl + V, you will always receive the same result.

Please note: In both cases, you can edit the data that is in the table.

Using the toolbar

If you cannot remember the key combination or you are uncomfortable to constantly call the context menu, you can always use the buttons on the main panel.

Click on the "Copy" icon. As a result, two options will appear. When choosing the first one, everything will happen as the same as mentioned above.

But if you click on "Copy as a drawing", you will see a completely different result.

Consider these parameters in more detail.

If you select this item, then during the insert you will see all cell lines. Even those that did not have borders. In a small scale, they are noticeable immediately. Especially if there are very few such cells. Therefore, we will show in an enlarged form.

If you use this copy method, you will not see anything like that. In this case, you will not be able to select the "image format".

After inserting you will see the following.

Empty cells have disappeared contours. But at the same time the table itself became not very beautiful.

Note: In both cases, data editing is now impossible, as it is a picture, not a table.

Therefore, before converting the data and move them to the Vordvian document, think several times, in which format it is to do. Try to use those of them in which in the future you can make some change.

Import data in Word

In all cases described above, a combination of keys Ctrl + V was used during the insertion of the table. But this is not the only way. In order to see other options, you need to make a few simple actions.

Select the desired range of cells. Copy the table with the CTRL + C hotkeys.

Go to Word Editor and click on the "Insert" icon. It is located on the Home tab.

It will happen the same as if you were pressed on Ctrl + V.

Now click on the little triangle under the "Paste" icon. As a result, you will see a large list of different insert parameters.

When you hover on each icon, you will see a preliminary option.

You will need to click then when you decide on the choice.

The number of icons depends on what is in the clipboard. Such a large set is possible only if the table is there. If just a picture, then there will be about the following.

In order to call this window, you need to perform the following steps.

Click the Home tab. Click on the "Paste" icon. Select the appropriate menu item. Or press the Ctrl + Alt + V key combination.

Immediately after that, the "Special Insert" window opens. In this case, the number of different options also depends on the content in the exchange buffer.

After you decide on the choice, you will need to click on the "OK" button.

The difference of versions of Word Editor

The instructions described above are suitable only for the modern Word (2007, 2010, 2013 and 2016). In the old version 2003, the possibilities are much smaller, but it cannot be discounted.

If you press the Ctrl + V key combination (after copying the table to the clipboard), you will see the following result.

The table turned out very beautiful, but at the same time we were displayed the boundaries of empty cells. By default, the table includes a mesh display. In order to disable it, you need to perform the following steps.

Click on the top menu "Table". Select "Hide the grid".

After that, all unnecessary borders will instantly be invisible.

As a result, the result was even better.

In the outdated version there are no different icons for insertion in various formats. Nevertheless, this item is already present, but it is in the "Edit" section.

The list is almost exactly the same as in Word

Online services

If you do not have a modern Word editor, or it is not possible to take advantage of its capabilities, in this case various online portals come to the rescue that specialize in this area.

If you open the search engine and enter the "Excel Converter in Word" request, you will see the following result.

Consider some of them. Keep in mind that not everyone can cope with its task. Especially if your file has a complex structure. For example, several combined cells or the use of text transfer. Such a conversion will be able to only single sites. If the converter gives an error or an empty page in the final file, then such a service will not suit you.

You can download the file in several ways:

from a computer;
with the "Drop Box" or "Google Drive" cloud;
specify a link to the document.

We will use the first way.

Click on the "FROM COMPUTER" link. In the window that appears, select the book you need. Then click on the "Open" button.

Immediately after that, this document will be displayed in the list (you can work simultaneously with several instances). Click on the drop-down list around the word "to".

Select the category "Document". Then the "doc" or "docx" item.

After that, click on the "Convert" button.

Wait until the translation is over to the desired format.

As soon as "FINISHED" appears, the file can be transferred to your computer. To do this, click on the link "Download".

In order to export the file, you must specify the desired directory and the desired document name. Then click on "Save".

As a result of this operation, you will receive the following.

As you can see, the contents of the book moved correctly. But the borders were completely different. Please note that the left of the table turned out to be empty cells. The fact is that all cells from 1 to the latter are converted during conversion (where your information ends), and not from there, where the filled cells begin.

Finally, consider the English-language Zamzar portal. It looks also quite simple. And it is not difficult to understand here even a novice user. The main thing is to understand the basic words in English.

This service is good because it is free and at the same time can convert almost any formats. Including in the Vordvian document.

In order to take advantage of its capabilities, you need to do the following operations.

Click on the "Choose Files" button.

Select the desired document.

Immediately after that, the "Files to Convert" section will appear. That is, you can simultaneously work with multiple files.

Another error is also possible.

Additional by

On the Internet you can find a large number of different applications that can cope with this task. At the same time, most of them are either paid or work incorrectly. And some do not work with modern formats at all.

As an example, consider the Total Excel Converter program. You can download it from the official site of the developer.

This default utility opens the contents of the desktop. Also appears a catalog tree.

Using this software is very simple. It is enough to put a tick near the desired item and select the final format.

Immediately after that, a window appears in which you can specify the name of the file and its location. To continue, click on the "Start" button.

In this case, part of the data did not fit the width of the page. In this case, you have to manually reduce the width of the columns. You also have to remove empty cells that were in the original book to the table.

Conclusion

In this article, we are step by step reviewed how data is converted from Excel editor to Word. At the same time, the possibilities of both the Word himself and third-party applications were demonstrated, including online services.

If something does not work, most likely, you miss sightseeing. For example, you allocate not those cells. Or do not allocate anything at all. Try to repeat the actions described above again, but now more carefully.

Video instruction

If for some reason you still have nothing happened, then you should not immediately despair. Not all is lost. The video is applied below, in which the methods described are considered with additional comments.