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.

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.

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.

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