Word: Getting an Excel table into WordJuly 10, 2013
Typically, you have two choices when you want to insert an unlinked Excel table into a Word document:
- insert it as an image (Note: you can’t modify it in Word once inserted); instructions are here: https://cybertext.wordpress.com/2011/06/29/excel-save-a-worksheet-as-an-image-file/
- insert 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/ OR https://cybertext.wordpress.com/2009/06/05/word-2003-import-an-excel-2003-table/
The choice you make will depend on what you need to do – or not do – with the data once it’s in Word. If you don’t need to modify it, then insert it as an image; if you do need to modify it, then insert it as a Word table.
- Create a PDF of a multi-workbook Excel spreadsheet: https://cybertext.wordpress.com/2009/12/24/creating-a-pdf-of-a-multi-workbook-excel-2007-spreadsheet/
- Insert a multi-page PDF into Word: https://cybertext.wordpress.com/2011/08/08/word-insert-a-multi-page-pdf/
[Links last checked July 2103; based on a Writing Tip I wrote for my work colleagues]