How to remake the excel file to the Word. Instructions for transfer of tabular data Excel to Word

Hello, friends.

Are you still copying data from Word document in Excel parts? I imagine how much time and strength takes this process. Actually developers Microsoft Office. For a long time they took care of us and simplified the task. In this article, you will learn how to translate the Word document to Excel quickly and easily. And we are talking not only about tables, but also lists and other information.

To qualitatively convert the Word to Excel, you first need to understand the principle of this action. When transferring information, the program itself determines which data should be placed in certain cells, rows and columns. Therefore, it is not always the way you would like.

List Transformation

First, we need to prepare the WORD document itself to the transfer. Do you want to spend time editing manually? Try to give the desired view of the future table before copying it. This is especially true when you need to move a large amount of data.

First of all, check the entire text to have the same formatting. If necessary, correct the signs of punctuation, fonts, etc. ready? Then go to the following steps.

Remove extra paragraphs

It must be done so that there is no empty cells and lines. Do not worry, your data is not mixed. Do you have a big document? Do not remove each paragraph separately - automate the process:

• Press CTRL + H combination. The "Find and Replace" window will appear.

• In the search field, enter the characters "^ p ^ P" (without quotes). They mean double paragraphs in the row. If the list is written in a row, instead, register "^ P".
• In the column "Replace" put a division sign. It may be "/". Does he already have in your document? Then choose another.
• Click on the "Replace All" button. Text united? So it should be. Note that now everywhere instead of paragraphs worth the symbol you specified.

Return list

What does your list look like a solid string? Do not worry on this stage So it should be. But now we will refund him a more accurate look. We work in the same window:

• In the "Find" section, enter the division sign chosen by you before;
• In the field "Replace" write "^ p";
• Press the final button.

Now the solid line crashed to the categories we need, in which the list elements are separated by commas.

Preservation

Formatting is over, now the last and most important moment. You need to properly save the document so that the exheel is easier to read it and convert. For this:

• In the main menu, go to the file - save as;
• Did the dialog box appear? Locate below the "File Type" string, click on the arrow and look for the "Normal Text" list.

Save.

Go to Excel

Go to Excel and open the stored document as follows:

• We go along the path file - open;
• In the "All Files" menu, specify textual;

• In the "Master of Text" window, click "Next";
• Among the separators, choose a comma and go further;
• Determine the format for each category of your list and click "Finish."

Well, everything, the text should stand in the table. Everything is simple ;-)

How to convert table?

We have just disassembled the list conversion into Excel format. And if we need to carry the table? It is even easier to do this.

• In the upper corner of the table, on the left, the plus appears when hovering on it the cursor. Click on it to highlight all the items.

• Copy the data.
• Insert them into the Excel document.

Editing

The resulting table has not a completely neat look? For example, the data that should be in different columns is located in one. Excel can independently divide them. For this:

• Highlight the desired area;
• Open the "Data" tab, then the Section "Text of Columns" and press "Next";
• In the "Separator Symbols", select the comma, space or other option.
• "Ready."

On this this topic By conversion from the format of Word to Excel, I close, so the lishka wrote :-). Are you too lazy to perform the actions described above? Translate data online.

Here for example a good online converter: https://convertio.co/ru/doc-xls/

I will not describe, I think you will figure it out, it can write about it somehow. As a rule, the algorithm of actions is: you need to select the format of the source and future file, copy the data, press the conversion button and download the resulting document.

Return to new publications.

Goodbye dear friends.

Word is not greatly adapted to carry out complex calculations, so they are all conducted in Excel. Subsequently, it becomes necessary to transfer the Excel table in Word. By ignorance, some users can start simply "interrupt»All data in the created table in the text document, turning simple task In the routine lesson, but actually insert the Excel table in Word is very simple. For this, there is even no need to transform the Excel table into Word.

The easiest way to insert the Excel table in Word is to highlight the entire table in Excel, copy it to the key combination clipboard "Ctrl + C" or through the menu, install the cursor in the required location on sheet Word., and insert a table from the buffer key combination "Ctrl + V" or through the menu. By default, a regular table with all copied data will be inserted, but at the same time a special icon appears in the lower right corner of the table by clicking on which you can select various insert parameters. By moving the cursor from one type of insert to another, you can immediately observe the result on the sheet, which allow the most accurate to choose the required insert parameter if necessary.

As a rule, with complex calculations and a large amount of data, various adjustments are possible, which lead to a change in data in the Excel table. To transfer each time an Excel table in Word after each such changes, this is not an output, especially if there are several such tables. Fortunately, you can insert the Excel table that in Word so that there is a permanent connection between them and when there are changes in excel fileThe data changed and in the Word table. This is done using the menu. "Special insert"which can be found on the tab "The main" on the menu "Paste".

Before choosing this menu item, you must copy the table in Excel. After selecting item "Special insert" A window appears in which you need to choose "To tie" And in the grade "How:" choose "Sheet Microsoft Excel. (an object)". As a result, when changing data in Excel Data will change in Word. With double click on such a table, we will fall on this table in the Excel file. If necessary, you can forcibly update the data in the Word table through the menu. To do this, press the right mouse button on the table and choose "Update Communication".

When copying tables from Excel to Word, as well as when transferring cell values \u200b\u200bfrom Excel tables to Word tables, various troubles may occur in the formats, sizes, and simply incorrect insertion of the copied data. For high-quality data transfer from Excel in Word, you need to know several points.

How to transfer a sheet from the bookExcel in DocumentWord?

To transfer to the Word document of the entire working sheet of the Excel working book, you must go to the "Insert" tab and in the "Text" buttons group click the Object button. On the "Creating File" tab, the Insert Object dialog box,

using the "Overview" button, you must find a workingbook with transfer data. It is worth noting that the list should be active in the workbook that contains data for transferring data to Word. At the same time, the inserting file data into the document is carried out so that they can be edited using the application in which they were created. In other words, B. document Word. The Excel application area appears, which is activated by double the left mouse button. At the same time, the Word tape is replaced with an Excel tape and in this area of \u200b\u200bWord document you can make changes using the Excel application tools.

If in the "Insert object" dialog box, check the box in the "Communication file" field, then in Word document will be displayed in automatic mode Changes made to the source file.

How to transfer a table or range of cells from Excel in Word?

To transfer the table or any arbitrary range of cells from the data from the Excel workbook to the Word document, you need to copy the cell range in the Excel application, go to the Word application and on the "Home" tab in the clip buffer button to disclose the "Paste" button and Choose one of available options Inserts, such as maintaining source formatting, use the styles of the final fragment, save as a pattern, save only text and some others.

In addition to the above options, the "Special Insert" item is available, with which you can insert a copied table or range as an object, as well as select other insertion options.

How to quickly transfer tables from Excel to Word Documents?

Tables can be transferred from Excel to Word using an add-in for an Excel application. If all the tables you need to insert into the Word document assign names (create named ranges), and in the Word text document, create bookmarks in those text positions in which the tables should appear and all this data will be recorded in the working sheet cells,

then to quickly transfer tables can be used software solution. At the same time, the tables can be on different sheets of the Excel working book, and the names of the sheets must be spelled out in the range of cells with source data.

How to selectively transfer data fromExcel B.Word (automatically)?

In some cases, when there is a need to fill in the individual lines / columns of the table in the Word document from Excel, from the execution of the multiple action "Copy / Paste" will help leave the add-in for Word to automatically fill the Word data tables from Excel.

For example, when filling out specifications to project documentation, you must selectively transfer information from the Excel working book database to Word. In this case, you need to transfer the entire Excel table, but only some of its lines, despite the fact that they are not located in the same range, which could be copied and pasted in one action. An add-in allows you to automate the process of selective data transfer from the Excel table in the Word table.

After selecting the Excel book and the working sheet containing data for transfer to the Word document table, the cell values \u200b\u200bfrom the first two database sheet columns are displayed in the dialog box. The number of columns displayed The user can adjust independently by changing the numbers of the first and last column. Depending on this, the contents of the dialog box change. The first line of the working sheet of the database file serves as headlines for columns in the dialog box. In order to transfer data from the dialog box, you must select the desired strings using left button Mice I. ctrl keys and / or shift on the keyboard.

After starting the program, the values \u200b\u200bof all the row allocated in the dialog box are transferred to the Word document tables, starting with the cell in which the mouse cursor is located. The add-in makes it possible to selectively fill the tables in the Word data editor from Excel. An example of using this superstructure can be filling the specifications of equipment and materials to project documentation, when it is necessary to selectively transfer data from databases created based on Excel working books in the Word document table.

For users using widescreen monitors, it is possible to change the size of the dialog box under the Word application window.

How to transfer individual values \u200b\u200bfromExcel B.Word?

To auto-complete Word Data Data from Excel, you can use ready-made solutions (add-in) for both Word and Excel. These solutions allow you to automatically generate Word documents based on the data contained on the Excel Workbook sheet. These solutions provide for the possibility of batch filling of documents (for cases when, on the basis of one set of source data, you need to fill out several different documents, for example, a contract, additional agreement, a power of attorney, and so on).

Often there are situations when you need to transfer data from excel programs (Excel) in word program (WORD). Although both programs come in one microsoft Package Office, but they do not support each other file formats. What to do in this case when you need to transfer table, or text?

Option simple. It is enough to copy the selected table, or the text block into Excel and paste it into the Word. You can do it through context menu (Copy / paste), having previously highlighting a table or range. Next, we save our file in the formats for the Word.

Everything seems simple, but there is one thing. We all know that Excel has a lot of functions using various kinds of formulas. What to do when changes will occur in them? Copy every time? Not! To do this, there is a very interesting way to copy when changes are made in the Excel table will also be applied in the Word Table (WORD). And consider it below.

To do this, when you are inserted, you need to select a special insert. You can do this using a special insert. When installing a copy to a Word, choose "Special Insert". That's all the changes are made in the file in Excel will also be applied to Word files. One condition files must be in one folder.

Another copy option is designed for aesthetes. It often happens so that the signs in Excel are copied to the Word contain excess elements Marking. If you interfere with the markup of the cells Excel, before inserting a copy to the Word insert it into the notebook, make a copy of the insertion in the notepad again in this case, the text will be inserted without marking Excel.

Instruction

Click the Start button to call the main menu. operating system Windows and open the "All Programs" section to implement the procedure for converting the selected table in the format text document.

Open the Microsoft Office node and run Excel and Word applications.

Open the "Table" menu in the top of the application window toolbar and specify the "Convert" command (for Microsoft Word version 2003).

Use the option "Table to Text" in the drop-down menu and apply the checkbox on the field of the desired separator in the dialog that opens. In this case, it should be remembered that when you select the "Sign of paragraph", the data of the convertible table will be separated by paragraphs, and the "tab" tab will allow you to convert the table into a single partition. Use the space key or hyphen when choosing the Other option.

Confirm the application of selected changes by pressing the OK button (for Microsoft Office version 2003).

Highlight the required table to be converted to the text format, or the entire table, and call its context menu by clicking the right mouse button (for Microsoft Office version 2007).

Specify the "layout" item and select the "Data" command in the submenu discontinuing.

Use the "Convert to Text" option and apply the checkbox on the desired separator field in the dialog box that opens. Confirm the application of selected changes by pressing the OK button (for Microsoft Word version 2007).

Highlight the selected table and expand the "Edit" menu of the upper toolbar of the Excel 2010 application window.

Specify the "Copy" command to save the table in the exchange buffer and go to the Word application.

Select the location of the text document being created and expand the "Edit" menu of the top of the WORD 2010 application toolbar.

Specify the "Special Insert" item and use the option "Microsoft Excel Sheet (Object).

Confirm the application of selected changes by pressing the OK button (for Microsoft Office version 2010).

Sources:

• How to copy Excel Table in Word

The MS Excel application is a very convenient means of performing the calculation and gunpoint of tabular data. However, when preparing the reporting documentation, it is often required to submit tabular information in Word format. At the same time, it is sometimes necessary to translate not only the direct content of the information, but also formatting documents.

You will need

• MS Word programs, MS Excel, computer.

Instruction

To translate information from a file saved in excel format In Word, open the tabular file, select the desired cells in it, right-click and select "Copy". Then, run the MS Word program, create an empty document (usually created automatically) and insert a fragment copied from Excel into it. At the same time, the number of columns required to represent the table will appear in the created document, and each line from the Excel table will be presented on a separate line in the document.
This method is the easiest, however, when using its formatting of the source document. In addition, further editing of such created in Word pseudo-odds will be very difficult.

To prepare in Excel looked in Word almost also, insert copied information into prepared in advance. To do this, count how many columns and strings has a source table. Then, select the "Table" menu item and "insert" in WORD. Specify in the appeared window the number of columns and rows and click confirmation. All other (cosmetic) settings can be held later.

Now, as in the first case, copy the desired one. Then, highlight the entire table created in Word, click the right mouse button and select "Paste". All data from the source table is neatly distributed over the empty cells of the Word table. Using funds formatting Word., correct incorrectly placed sections of the table.
This method is optimal for the preparation of reporting documentation, but does not allow to save that the subsequent recalculation of the data will make it difficult.

To copy a table from Excel along with formulas and design, use not a simple, but "special" insert. To do this, also copy the desired fragment of the table, then select menu Word. Points "Edit" - "Special Insert". Then, select the Line Microsoft Excel (object) window in the window.
Pay attention to the position of the point in the "Insert" and "link" lines. To prepare standard documentation, leave this pointer in the "Insert" string.
If you need the information in Word document automatically vary depending on the data in the Excel table, select "Tie". However, it is necessary to ensure Word file Permanent access to the file in Excel format.

Video on the topic

note

How to transfer a Word to JPG? Press the Print key, then open paint program, On the Edit menu (or edit), click Paste, cut the desired location, do new file. In the same way and save as JPG.

Helpful advice

The resulting graphic file can be saved in any format, including JPG. If necessary, repeat the operation several times, for different pages of the document. The second way to translate PDF in jpg - download the Universal Document Converter program, which will help convert pDF Pages Document in jpg.

Sources:

• how to translate Word.
• How to easily move or copy a sheet in Excel 2013

Quite often, the need to transfer the tabular data from the Microsoft Word program to the Microsoft Excel spreadsheet sheet. The table can be copied, but for the correct display of information, you must execute several commands.

You will need

• - A computer;
• - Installed Microsoft Office Package.

Instruction

Open the document created in microsoft program Word from which you want to transfer the table to the Microsoft Excel program. Left-clicks, select the "Table" command in the menu - "Highlight Table".

Press the CTRL + C key combination (or the Edit menu item is "Copy"; button on the toolbar). Next, go to the working list of the book in Microsoft Excel, select the location where the top left cell table will be located, press Ctrl + V to copy the Word table in Excel.

Make sure that the area in which you want to copy the table in Excel is empty since the data from Word will replace all existing information in the sheet cells that are in the insertion area. Check the size of the inserted table. Next, click the "Paste" button.

To format a table, click the Insert Settings button, which will appear about the inserted information. If you want to use that formatting that is applied to the sheet cells, click the "Use finite cell formats" option. If you want to leave the source table formatting, then click on the "Save original formatting" option.

Edit the resulting table if the table elements were separated by tabs or spaces. To do this, highlight the table, go to the "Data" menu, select the text on the columns command there.

Select the option "with separators", click the Next button. Select the desired character (space or), click on the "Finish" button. Sometimes after inserting data there is a need to clean them to get the ability to use the data calculation function in Excel. For example, unnecessary gaps may appear in the cells, the numbers may be inserted into text format, not numeric. It can also be improperly displaying dates. To fix this, select the data of one format, right-click and select "Cell Format". In the "Number" tab, set the required data format (numeric, money, date, etc.).

Sources:

• how to transfer the table from
• Copy Word Table in Excel