Search:     Advanced search

How to merge or combine multiple files into one document

Article ID: 514
Last updated: 08 Feb, 2013

How to merge or combine multiple files

If you would like to merge multiple Word, Excel or Text files together, it can be done with relative ease, and at no extra cost. Follow the below steps for the type of file you're trying to merge.

Merging Microsoft Word documents

To merge Word documents, you can merge those documents within Microsoft Word itself. To do this, open the first file in MS Word, and follow the steps for your version of Word. The steps are different because of the changes between the file menu and the Office ribbon.

Microsoft Word 2010 or later (ribbon)

From the Word ribbon, click Insert at the top of the menu and then click the down arrow next to Object and then Text from File (as shown below).

Select the file you wish to merge into the current document and click Insert. Once completed the text and other information from the document will be merged into the current document. These steps can be completed as many times as you want if you want to merge multiple files.

Tip: If there are multiple files you want to merge at the same time you can select multiple files by holding down the Ctrl key and selecting each file you want to merge.

Microsoft Word 2007 or earlier (file menu)

In Word click on Tools and then Compare and Merge Documents in the menu bar.

Find the document you want to merge. You have the option of merging the selected document into the currently open document or merging the two documents into a new document. To choose the merge option, click the arrow next to the Merge button and select the desired merge option. The files will then be merged.

Tip: If there are multiple files you want to merge at once you can select multiple files by holding down the Ctrl key and selecting each file you want to merge.

Merging Microsoft Excel files

To merge Microsoft Excel files together, it is best to save them as CSV files first. Open the Excel files and in the menu bar, click File, Save As. In the Save as type drop-down list, select CSV (comma delimited) from the list.

Do this for each Excel file you want to merge, then place all the CSV files in the same folder. For ease, place them in a folder in the root of the C: drive (e.g. c:\csvfiles).

Open the Windows command prompt and navigate to the folder containing the CSV files. Type dir to view the files in the folder and ensure all the files are there.

Type in the below command to merge all CSV files in the folder into a new CSV file titled "newfile.csv" (any name could be used).

copy *.csv newfile.csv

After the new file has been created open the new CSV file in Microsoft Excel and save it as an Excel file.

Merge PDF files

PDF documents can also be merged. Simplty open a browser and use MergePDF  or http://foxyutils.com/mergepdf/

then follow the directions to upload 2 or more pefs, and click merge.  NOTE: there is a limit up to 50mb pdf file.

article written by computerhope.com

uploaded by Adam Starnes 2/8/13

Article ID: 514
Last updated: 08 Feb, 2013
Revision: 1
Views: 54520
Comments: 0
Posted: 08 Feb, 2013 by -- .
Updated: 08 Feb, 2013 by -- .
This article was:   Helpful | Not helpful
Also listed in
folder Sage PCs -> Software

Prev   Next
Microsoft Office     How to get Office for Free (Students)