I’ve written before about some methods for getting the data in an Excel spreadsheet into Word (see the links below).
Recently, one of my colleagues had a BIG Excel spreadsheet table (all text) that had to be inserted into a Word document. In this instance, inserting a link to the spreadsheet was not an option, and saving it as multiple images and inserting those was problematic too (fuzzy, almost unreadable text mostly). So in despair my colleague asked me for some help.
In the process of testing many options I stumbled on a solution, but then I forgot which of the many combinations of things I tried was the one that worked ;-) So after a bit more testing I got it to work again.
- Save the Excel spreadsheet as either a MHT or HTM file (doesn’t matter which – both work).
- Open this saved file in Internet Explorer. NOTE: This method DOES NOT work if you open it in another browser, such as Firefox or Chrome — you must open it in Internet Explorer.
- In Internet Explorer, go to File > Edit in Microsoft Word, which opens the spreadsheet in Word as a table.
- You may have a little bit of fiddling to do (e.g. remove blank columns, resize columns, change font size), but it shouldn’t be much.
- Select the reformatted table, copy it, then paste it into your main Word document (or save it as a new document if you aren’t inserting it into another document).
[Links last checked August 2014]