However, you need to convert the table in Excel without splitting. If you turn on the Show/Hide ¶ (Pilcrow character) from the Home tab in the Word document, you’ll see the Pilcrow character for every line break. Let’s explore why the cells are splitting. Now, if you use the copy and paste tool, you’ll get the following output where the cells are split.
Copy word table to excel without splitting cells full#
Full Name, State, and Email) of Sales Rep is given as shown in the below table. If you have line breaks in your word table, you cannot convert such a type of table to an Excel spreadsheet using the above discussed methods. Convert Word Table to Excel without Splitting Cells
![copy word table to excel without splitting cells copy word table to excel without splitting cells](https://cdn.extendoffice.com/images/stories/doc-excel/array-table-to-list/doc-array-table-to-list-16.png)
Follow the procedures to understand the process. Instead of pressing any key or tools, you may copy the word table to Excel quickly! All you need to do is drag the table and drop it to the desired place.
![copy word table to excel without splitting cells copy word table to excel without splitting cells](http://1.bp.blogspot.com/_BTi19j0EYpQ/TNWQfxIe97I/AAAAAAAAACo/_2HzxDv0vnM/s1600/613-Excel+cell+references+-+Mixed+References+02.jpg)
![copy word table to excel without splitting cells copy word table to excel without splitting cells](https://i.ytimg.com/vi/ZNTf7X2TrAg/maxresdefault.jpg)
In the beginning method, I’ll show you the simple method using the copy and paste tool to convert the Word table to Excel. And the rest method is handy for converting a complex table. The first 5 methods are suitable for converting a simple table. Now, you need to convert the above table into an Excel spreadsheet program using the following methods. Product ID, Fruit Items, Unit Price, and Sales in USD. Here, the Sales Report of Fruit Items is given along with the necessary information i.e. Converting Word Table to Excel Spreadsheet.xlsxĦ Methods to Convert Word Table to Excel SpreadsheetĪssuming that you have a table like the following one in your Word document.