03.08.2017

Word and Excel are two programs from the package Microsoft Office. Sometimes it becomes necessary to transfer a table to an Excel workbook from a Word document, because Excel is designed for processing tabular information.

How to copy a table from a Word document to an Excel workbook

There are two ways to transfer a table to Excel. The first is to simply copy it - in the same way you would transfer, for example, a picture or a line of text. The second method is more “advanced”: you save the table in a special file and import it from this file into Excel.

Method 1: Simple Copy

The applications included in the Microsoft Office suite are interconnected. This allows you to work efficiently. If there is a need to process information in Excel from a table saved in a document with the DOC or DOCX extension, the table can be quickly copied without losing formatting. To do this, follow these steps.

Method 2: Copy by importing data

Data can be imported into an Excel table from various sources, for example, from an Access database or from a web page. One possible source could be text file. Let's save the table in a text file and import it.

Using this method will not preserve table formatting.

1. If there is anything other than a table in your Word document, first copy the table into a new, blank document. To do this, select it (a description of this process is given in step 2 of the first method), click Ctrl+C, then “File” - “Create” - “New Document”. Insert table using keyboard shortcut Ctrl+V.



2. Select the table. Click the "Convert to Text" button, which is located in the ribbon tab "Working with tables - Layout" in the group "Data".



3. In the dialog box that opens, select a separator character. Be sure to remember your choice! Click "OK".
4. Save the file in TXT format. Click "File" - "Save As". Select and remember the file location and name. Be sure to install "Plain text (*.txt)" as a file type! Click "Save".



5. In the window "File Conversion" make sure text encoding is selected Windows (default), and press "OK".



6. The table is now saved in text document, and it's time to import it into your Excel workbook. In Excel, go to the tab "Data" and press the button "From the text" in the group "Receiving external data".



7. In the file selection window, find the saved text document. Click on it and press "Import"(or just double click on it). Will start working Text Master.
8. During the first step of the Wizard, make sure that the first few rows of the table are displayed correctly in the “Preview” field (cells may be “glued” together). If necessary, check the box "My data contains headers." Click "Next >".



9. In the second step, mark the delimiter that you set when saving the text document. In the field "Sample of data parsing" Vertical stripes should appear delimiting the columns. Click "Next >".



10. In the third step, click on each of the columns one by one (the column will be highlighted in black) and set the type of data that is stored in it. This can be text or a date. Otherwise (column with monetary amounts, numbers, etc.) select "General". You can skip unnecessary columns. When you set the type of each column, click the “Finish” button.



11. In the window "Data Import" select "Existing Sheet" to place the table on one of the sheets already present in the workbook, or "New Leaf". If you are placing the table on an existing worksheet, click the cell where you want the top-left cell of the table you are inserting to appear in, or enter the code for that cell in the correct format in the appropriate field. Click "OK"



12. Table inserted! You can now customize table cell size and formatting. To correctly process the table, it is recommended to perform the seventh step of the first method with it.

Conclusion

Inserting a table from Word into Excel is no more difficult than inserting text or a picture. After such an insertion, formatting is not lost. A more reliable method will take more time, but the data types in the columns will be configured correctly.

Each cell in the source table occupies one worksheet cell. In Excel, you can process and visualize data from a table in a variety of ways.

The modern, dynamically developing company Microsoft regularly supplies the world market with many useful, high-quality products; applications created about twenty years ago are still relevant today, due to their ability to satisfy any consumer needs that lie in the creation and formatting of electronic documents. For example, editors such as Word and Excel are equipped with many tools that help carry out various manipulations directly with text and tables. It is important to note that both products can integrate data with each other; in particular, the user can copy a table from Excel to Word. In fact, the Word text editor does not have powerful tools that allow you to perform complex calculations; due to this circumstance, Excel assumes such functions.

Let's start an article about Excel

There are several very simple and convenient ways to transfer a table from Excel to Word. There is no need to engage in a time-consuming process, copying data from one program to another in order to manually “interrupt” the information. You can transfer data from an application that works with tables to a text editor program in just a few minutes, without even resorting to preliminary conversion.

Step-by-step algorithm of actions

Before you begin to describe the transfer method step by step, it is worth noting that the selected sequence of actions in no way depends on Office versions installed on the user's computer. The user can, according to his personal preference, choose the 2003, 2007 or 2010 version of the program.

So, in order to transfer a table from Excel to Word, you must first create or open the desired table, which is located in the Excel storage. It doesn’t matter what is in the table itself and how much data it contains, to begin with the user can create the simplest report, which would consist of three columns, in the first two of them, for example, there could be prime numbers, and in the third, using the entered formula, their amount was calculated.

Selection is performed using standard Windows methods

You can insert a table from Excel into Word by selecting all the cells present in the table space. After clicking on the selected area of ​​the document, a small context menu will appear on the monitor screen, which will offer a choice of several possible actions. In this case, the user needs a subcategory that is responsible for copying data. The same task can be performed using the Ctrl+C key combination, which allows you to copy data.

An example of copying via the context menu is shown

To finally transfer the data, you need to open the Word text editor, position the cursor in the place where, according to the user’s plans, the copied table will subsequently be located. Then call the context menu, click on the “Paste” command, or by pressing the Ctrl+V buttons together, transfer data from one editor to another.

As practice shows, even a novice user who does not have extensive knowledge of the computer environment can insert a table from Excel into Word. Thanks to just two steps, you can insert a table in the place where the cursor was previously placed. Particularly noteworthy is the fact that with such copying, the data will be able to retain the same design, font used, color scheme and framing.

Further actions no longer require skills to help insert a table into Word; the user will be able to completely change and format the transferred data without touching Excel. The only thing that needs to be taken into account is the feature by which all numbers that are calculated in the spreadsheet editor using formulas will be transferred to Word as simple text or symbol.

To paste, use the toolbar, context menu or Ctrl+V combination

Most often, the user is so busy thinking about how to correctly insert a table from Excel into Word that, before transferring, he completely forgets to set a frame that would frame what was transferred to Word. In the case where the information does not have the necessary border lines, you can turn on the border a little later in text editor Word. To give a more complete look, click on any cell and select the “Borders and Fill...” item from the drop-down menu.

Design mode helps you design your table

You can set borders in Word using the “Margins” category; the user only has to mark the required type of framing on the left side. It is possible to install joint internal and external edges. Along with all of the above, you should specify the type of lines (most often solid is used) and confirm your intentions with the “OK” button. As a result, the table will take on an attractive appearance; the data will be displayed in separate windows, as is presented in Excel.

Conclusion

Spreadsheet and text editors from Microsoft interact perfectly with each other; the user can use the ability to copy a table from Excel to Word without unnecessary worries.

Perhaps I will not describe all the delights and advantages of data processing in Excel tables. And, probably, all users know that tables in the Word text editor are inferior to Excel tables in a whole bunch of possibilities. I probably won’t be wrong if I say that many have dreamed of being able to manage data in the Word editor in the same way as in Excel, but, alas...

On the one hand, this is true, but on the other, not everything is as sad as it seems. It turns out that you can work in an Excel spreadsheet without leaving the Word editor.

Let's see what needs to be done to implement or create Excel spreadsheet in Word:

1. Opening Word document. A new document or an existing one is not so important.
2. Go to the tab Insert editor menu ribbons.
3. In the area Tables find a team TableExcel and click on it.
4. At the same time in a special frame An area will open in which it will be placed.

Please note that opening the area with the Excel table led to changes in the toolbar. Excel editor tools are now also available on the command ribbon! That is, you can use the full-length table editor. 🙂

Let's now see what we have gained and what opportunities have opened up for us. Pay attention to the frame that frames our table. It is quite wide and has diagonal stripes. This means that the table is inserted as a separate object, which is currently open for editing. Its frame also has markers with which we can zoom in available size tables, that is, the number of rows and columns. Well, if we have opened a small fragment of the table, which is not enough for work.

After the frame is stretched to the width of the sheet, we can fill our plate with data. There are two ways to do this:

1. Enter data manually.
2. Copy tabular data from somewhere where it was previously typed. By the way, you can use the capabilities of the tool.

To illustrate, I will copy a certain prepared plate with information about employees onto a sheet of paper stretched out to the width of the sheet.

It can be seen that the data did not occupy the entire volume of the open area. If we now click outside this area (on Word sheet), then we will simply exit the Excel table editing mode. And our table will go into view mode.

What do we see? We see extra rows and columns that remained visible when the object was closed. Not in order. By double-clicking on the plate, we again enter the editing mode and, using the mouse, grab the markers and compress the boundaries of the area until no empty lines are visible.

After that, by clicking on the Word sheet, we exit the editing mode and see that the plate is clearly visible along its borders. Just what we needed.

So, we have created an Excel table in Word and now you can control the position of the table on the sheet (alignment) like a regular picture.

If you need to make any adjustments, for example, to change data in the table, recalculate, correct formulas, etc., just go to the editing mode of this area. And when printing a document or translating it into , the information will be displayed as from a regular Word table.

If you need to implement a table block in Word, it is better to create it in Excel and transfer it to a text file. There are two ways to do this - simple insertion and import of data with the establishment of connections. However, it is worth considering that in order to insert a table into Word from Excel, you need to carefully read the procedure.

Copy and paste

If the table is small in size and contains the final version of its contents, the most optimal way to move it is by copying and simple pasting. The algorithm of actions is as follows:

combination Shift+Insert or Ctrl+V – the original design is preserved;

“Home” tab, “Insert” tool, click on the icon for the parameters required in a particular case;

Context menu:

– using the “Use final formatting styles” option – the contents of the inserted range will automatically be formatted in the same style as the text block, cell values ​​can be changed;

– by selecting the “Picture” option, the original design will be preserved, but the ability to make adjustments to the cell area is lost.

Import table

If you need to transfer tabular data with the ability to make changes in the original file and update values ​​in Word, use another method:

1. In Excel, the desired range is selected and copied.
2. The copied object is pasted into Word:

Context menu using the parameter:

– “Link and use final styles” – the table design style is adapted to the last paragraph of the document; when changes are made in the source code, the values ​​in Word also change;

“Home” tab, select the “Insert” icon, then click “Paste Special”, in the “How” field indicate “Sheet Microsoft Excel(object)".

Word is not very suitable for carrying out complex calculations, so they are all carried out in Excel. Subsequently, it becomes necessary to transfer Excel tables to Word. Unknowingly, some users may simply start "interrupt» all the data into a created table in a text document, turning a simple task into a chore, but in fact, inserting an Excel table into Word is very simple. To do this, you don’t even need to convert the Excel table into Word in any way.

The easiest way to insert an Excel table into Word is to select the entire table in Excel, copy it to the clipboard using the keyboard shortcut "CTRL+C" or through the menu, place the cursor in the required place on the Word sheet, and insert a table from the buffer using a key combination "CTRL+V" or through the menu. By default, a regular table with all the copied data will be inserted, but a special icon will appear in the lower right corner of the table, by clicking on which you can select various paste options. By moving the cursor from one type of insertion to another, you can immediately observe the result on the sheet, which allows you to most accurately select the required insertion parameter, if necessary.

As a rule, with complex calculations and a large amount of data, various adjustments are possible, which lead to changes in the data in the Excel table. Transferring an Excel table to Word every time after each such change is not an option, especially if there are several such tables. Fortunately, you can insert an Excel table into Word in such a way that there is a constant connection between them even with changes in Excel file, the data changed and in Word table. This is done using the menu "Insert Special", which can be found on the tab "Home" in the menu "Insert".

Before selecting this menu item, you must copy the table into Excel. After selecting the item "Insert Special" a window appears in which you need to select "Link" and in the column "How:" choose "Microsoft Excel Sheet (Object)". As a result, when changing data in Excel data will change in Word too. When you double click on such a table, we will be taken to this table in the Excel file. If necessary, you can force update the data in the Word table through the menu. To do this, right-click on the table and select "Update connection".