Any user of the Microsoft office suite knows that the basic Word and Excel programs differ quite strongly and it’s not possible to directly open documents created in one program using another, because Word is more of a test editor, although it can work with other data types , and Excel is designed to work with tables and calculations. Nevertheless, the question of how to convert the Word document to Excel or vice versa is solved by using special data import functions. Consider both options. Having an action algorithm, this problem is not difficult to solve.
How to convert Excel to Word and vice versa: the basics
Since the programs differ quite significantly among themselves, the user often faces the problem of data conversion. Even when using the simplest methods, it is believed that both documents should have the same formatting, because the structure of the imported material can be violated when pasted.
But these applications have common ground - tables. With them, the situation is quite simple. If you import data from Word, it does not look as complicated as the inverse transformation, so the very initial problem of how to convert Excel to Word with full preservation of the data structure is often unsolvable for many novice users.
The simplest technique
To begin, consider the simplest option that the Internet community calls “copy-paste” (the combination of the English terms copy and paste, or, more simply, “copy” - “paste”).
Of course, the question of how to convert the Word file to Excel can be resolved in such a primitive way. However, here you need to clearly understand that in this option there is only a copying of text data that can be inserted from Word into only one Excel cell. If you want to put text in different cells, you have to copy the text in fragments.
You can also insert Excel data in Word using this method, however, they will be presented in the form of a table, and the data from the Excel sheet may not always fit on the Word page. Therefore, this technique is often unacceptable.
We work with tables
How to convert the Word table to Excel? There are several options here. From a Word test editor, exporting data to Excel is much easier than the other way around.
In the simplest case, you just need to select the Word table, copy the data to the clipboard and paste it into Excel. All information will be automatically distributed in cells, as in the previous structure. But then an unpleasant surprise awaits the user. For example, there are two cells with different data, which should correspond to the general description. In the Word table, in order not to enter a value twice, the cells are combined. But when pasted into Excel, they will be automatically broken, so that the description will correspond to only one initial value. To prevent this from happening, in the paste options in Excel, you need to use the section of the formats of the destination cells with preservation of the original formatting.
Import Excel data into Word
Now let's see how to convert Excel to Word. The usual insertion technique, as already understood, is not good.
The following technology is applied here. We copy the data to Excel, then in Word from the file menu we use the paste command and select linking using the final styles for Word 2010 or a special paste for Word 2007 followed by linking. In the linking method, select the Excel sheet and click the "OK" button.
Another technique that allows you to solve the problem of how to convert Excel to Word is to use the text-to-text command with the formatting method in the spreadsheet editor (for this, use the tabulator to create a single section, the space for paragraph separation, etc.). Only after this is done copying using a special paste in Word.
Conclusion
As can be seen from the foregoing, the very process of converting documents from one application into the format of another is not particularly difficult. In conclusion, it is worth noting that here we did not consider methods that allow, for example, importing tabular data in a text editor, when initially an Excel table is inserted as a graphic object. With this formulation of the question, the inserted table will not be editable and it will not work with such data. This makes sense only in cases where a change in information is not provided for initially. But the methodology for transferring one type of data to another using the simplest tools shown above is suitable for any user. Yes, and do not believe those who say that this type of conversion can be done using converters. There are no such programs in nature. And if they exist, then they are very primitive, from which you cannot achieve the desired result.