The next method to import a PDF file into Excel is to use its Data menu. It lets you extract data from an existing file, database, Azure, etc., and lets you insert the data into your Excel sheet.

Drag the files that you want to combine into a single PDF into the file-list box. You can add a variety of file types, including PDFs, text files, images, Word, Excel, and PowerPoint documents.

You can do a mail merge in Microsoft Word and Excel to create personalized documents for many recipients at once.

And that’s how you make a single PDF out of several PDF files using various ways on your Windows 11 computer. It’s also possible to combine images into a PDF file if you’d like to do that.

We show you how to clean up and prepare your data for the big mail merge, everything from trimming unnecessary data fields to setting up record ID numbers.