How to Create Multiple Word Documents from Excel (3 Easy Methods)

Method 1 – Create Multiple Word Documents Using Copy and Paste Feature

The sample dataset below contains three worksheets in the Excel workbook. Sheet1 is the first worksheet.

Create Multiple Word Documents Using Copy and Paste Feature

Sheet2 is the second worksheet.

Create Multiple Word Documents Using Copy and Paste Feature

Sheet3 is the third worksheet.

Steps:

  • Open the spreadsheet and select the range from Sheet1 to convert. To copy the entire worksheet, press Ctrl+A, and Ctrl+C.

Create Multiple Word Documents Using Copy and Paste Feature

  • Open the Word file where your Excel work will be inserted. Place the cursor on the page of this document, press Ctrl+V to paste.

Create Multiple Word Documents Using Copy and Paste Feature

  • Follow the same steps for Sheet2 and Sheet3.

Create Multiple Word Documents Using Copy and Paste Feature

Read More: How to Copy Table from Excel to Word


Method 2 – Utilizing Object Command

Steps:

  • In the Word document, go to the Insert tab and select Object.

Utilizing Object Command

  • A Object dialog box opens, select Create from File and click on Browse to choose a workbook.

Utilizing Object Command

  • Select your desired Excel file and click on Insert.

  • Click on OK.

  • You will get the following Word document of Sheet1.

Utilizing Object Command

  • Repeat the same process for Sheet2 and Sheet3.

Read More: How to Insert Excel Table into Word


Method 3 – Online Converter to Create Multiple Word Documents from Excel

Steps:

Using Online Converter to Create Word Document From Excel

  • Select the file from your computer that you would like to convert Excel to a Word document and click on Open.

Using Online Converter to Create Word Document From Excel

  • Select the Export As option and click on Word(.docs).

  • Select the Convert to Word option and click on Choose option.

Using Online Converter to Create Word Document From Excel

  • You will be able to convert Excel to a word document and click on Download to download the file.

Using Online Converter to Create Word Document From Excel

 

Using Online Converter to Create Word Document From Excel

  • You will get the following Word document of Sheet1.

Using Online Converter to Create Word Document From Excel

  • Repeat the same process for Sheet2 and Sheet3.

Download Practice Workbook


Related Articles

<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Saquib Ahmad Shuvo
Saquib Ahmad Shuvo

Saquib Ahmad Bhuiyan, holding a BSc degree in Naval Architecture & Marine Engineering from Bangladesh University of Engineering and Technology, skillfully integrates engineering expertise with a passion for Excel. He provides solutions to complex issues as an Excel & VBA Content Developer for ExcelDemy Forum. He demonstrates an enthusiastic mindset and adeptness in managing critical situations with finesse, showcasing his commitment to excellence. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Rhinoceros,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo