h1

Excel table into Word — quick and easy method!

August 25, 2014

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.

Here’s how:

  1. Save the Excel spreadsheet as either a MHT or HTM file (doesn’t matter which – both work).
    excel_word01
  2. Open this saved file in Internet Explorer. Right-click on the saved file, then select Open with > 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.
  3. In Internet Explorer, go to File > Edit in Word (or similar), which opens the spreadsheet in Word as a table. (If you can’t see File, press the Alt key to show the menu.)
  4. 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.
  5. 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).

See also:

[Links last checked August 2014]

4 comments

  1. […] Update Jan 2015: Try this method instead: https://cybertext.wordpress.com/2014/08/25/excel-table-into-word-quick-and-easy-method/) […]


  2. […] it as a Word table that you can modify later in Word; instructions are here: https://cybertext.wordpress.com/2014/08/25/excel-table-into-word-quick-and-easy-method/ […]


  3. Hi! I wanted to try this but I can’t get “File>Edit in Microsoft Word” to show up as an option. It will only let me edit it back in Excel. Any help is appreciated.


  4. Hi Rebecca

    I just repeated these steps in Windows 7, Internet Explorer v11, with Word and Excel 2010 and I get the ‘Edit in Microsoft Word’ option.

    I then repeated on a Windows 10, Internet Explorer 11, Word and Excel 2016 machine, and also get the option, though this time it’s called ‘Edit with Word 2016’.

    What version of Windows, Internet Explorer, Office etc. are you using?

    –Rhonda



Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: