{"id":3594,"date":"2018-11-30T17:02:18","date_gmt":"2018-11-30T17:02:18","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3594"},"modified":"2024-03-26T11:06:24","modified_gmt":"2024-03-26T11:06:24","slug":"convert-excel-data-to-word-table","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/","title":{"rendered":"Convert Excel Data to Word Table"},"content":{"rendered":"\n
Convert-Excel-Data-to-Word-Table<\/a>Download File<\/a><\/div>\n\n\n\n

Depending on what exactly you want to copy, there are a few ways you can use to convert an Excel table to a Word table.<\/p>\n\n\n\n

This is an Excel table we are going to use. There are background colors and conditional formatting.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Copy the Excel table to Word (Ctrl + V)<\/h2>\n\n\n\n

The easiest way to copy an Excel table to Word is to select all table cells in Excel (A1:F5<\/strong>), copy these cells (Ctrl + C<\/strong>), and paste them (Ctrl + V<\/strong>) into Word.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Choose Paste Options<\/h2>\n\n\n\n

Standard Excel pasting can be sufficient for some people, but Word gives you more control over pasting methods. Let\u2019s see which of these methods you can use to achieve the desired effect.<\/p>\n\n\n\n

Instead of using a keyboard shortcut to paste the table, use the right mouse button inside your document to insert the table.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

If you use the second position, called Use Destination Styles (S), it will insert a table with the row and column lines, but without formatting.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Paste as an image<\/h2>\n\n\n\n

So far, we pasted the table as values, but we can also paste it as an image.<\/p>\n\n\n\n

Right-click inside a document and choose the second position from the right.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

It will paste the table as an image, so you won’t be able to edit data inside it.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Pasting table and adding borders<\/h2>\n\n\n\n

If you want to keep table formatting, but also want to have borders, you can absolutely do it.<\/p>\n\n\n\n

First, paste the table with Ctrl + V<\/strong>. Click inside the table and choose TableTools >> Layout >> Table >> Properties<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

From the new window choose the Table<\/strong> tab and click the Borders and Shading<\/strong> button.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

From the Borders and Shading Window<\/strong>, under the Setting<\/strong>, choose All<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

It will add borders and keep the formatting intact.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

You can also change color to make them similar to the table inside Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"

Depending on what exactly you want to copy, there are a few ways you can use to convert an Excel table to a…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\nConvert Excel Data to Word Table<\/title>\n<meta name=\"description\" content=\"Learn how to convert Excel data to Word table: copy and paste, choose paste options, and paste as an image.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Convert Excel Data to Word Table\" \/>\n<meta property=\"og:description\" content=\"Learn how to convert Excel data to Word table: copy and paste, choose paste options, and paste as an image.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-30T17:02:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T11:06:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"Convert Excel Data to Word Table\",\"datePublished\":\"2018-11-30T17:02:18+00:00\",\"dateModified\":\"2024-03-26T11:06:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\"},\"wordCount\":321,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png\",\"keywords\":[\"file\",\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\",\"name\":\"Convert Excel Data to Word Table\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png\",\"datePublished\":\"2018-11-30T17:02:18+00:00\",\"dateModified\":\"2024-03-26T11:06:24+00:00\",\"description\":\"Learn how to convert Excel data to Word table: copy and paste, choose paste options, and paste as an image.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Convert Excel Data to Word Table\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Convert Excel Data to Word Table","description":"Learn how to convert Excel data to Word table: copy and paste, choose paste options, and paste as an image.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/","og_locale":"en_US","og_type":"article","og_title":"Convert Excel Data to Word Table","og_description":"Learn how to convert Excel data to Word table: copy and paste, choose paste options, and paste as an image.","og_url":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/","article_published_time":"2018-11-30T17:02:18+00:00","article_modified_time":"2024-03-26T11:06:24+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"Convert Excel Data to Word Table","datePublished":"2018-11-30T17:02:18+00:00","dateModified":"2024-03-26T11:06:24+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/"},"wordCount":321,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png","keywords":["file","pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/","url":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/","name":"Convert Excel Data to Word Table","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png","datePublished":"2018-11-30T17:02:18+00:00","dateModified":"2024-03-26T11:06:24+00:00","description":"Learn how to convert Excel data to Word table: copy and paste, choose paste options, and paste as an image.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/11\/excel-example.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/convert-excel-data-to-word-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Convert Excel Data to Word Table"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3594"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=3594"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3594\/revisions"}],"predecessor-version":[{"id":15492,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/3594\/revisions\/15492"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=3594"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=3594"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=3594"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}