(C) Select the output location for the resulting PDFs. If you only wanted to convert the Excel files found in the source folder, only select Microsoft Excel. This window allows you to choose which types of files will be converted.īy default, any of the types of files listed will be converted to PDF. (B) Click the Source File Options button.Then click the Browse button and locate the folder containing your source Excel files (A) Set Run Commands on “Selected Folder”.The Edit Batch Sequence window will appear:.Choose Advanced->Document Processing->Batch Processing.To create a Batch Process to convert many text files, follow these steps: It’s a good idea to set portrait/landscape printing as needed. Worksheet Print Settings: You may also want to take a look at your Excel documents to make sure the margins and print orientation is set as desired. The Batch Sequence you build will allow Acrobat to convert any documents found within the folder, even if they are located in sub-folders. Organizing and Getting Ready : The steps below presume that you will put all of the Excel files you wish to convert into a single folder.
The following section describes how to build a very simple sequence. You may also specify a number of operations to be made to a file.
Using Batch Sequences (or Actions in Acrobat X) you can open Excel files (or other supported file types) from the originating location and save a PDF version to the same location. If you have Acrobat Pro, you can take advantage of batch sequences to automate the conversion process. Here you can set where the resulting PDFs will be created and even add a prefix or suffix to the file names. The Batch Create options window opens.In the Batch Create Multiple Files window, click the Add Files button and choose whether you want to process individual files or Folders, Click OK.
I chose a custom setting I created.ī) Enable “Convert entire Excel workbook”Ĭonverting Multiple Excel Files to PDF: Not Batch Here’s how:Ī) Choose the PDF conversion setting needed. Instead, you’ll need to set Acrobat application preferences to get Excel file conversion to work the way you want. Setting Conversion PreferencesĪcrobat makes a distinction between the settings you employ inside an application like Excel to convert to PDF (the Excel PDF Maker) and settings you use to convert in bulk via Acrobat.Īcrobat generally ignores some of the personal settings you’ve made in the PDF Maker. Read on learn how in the rest of the article. If you want to convert many Excel documents in batch to PDF, there are a few additional tricks involved. The result is a nicely bookmarked PDF that looks like this: When you use the PDF Maker in Acrobat 9 or later, you have some additional options to select just the worksheets needed:Ī) Choose options to convert all worksheets, the currently selected worksheet or a subset of the worksheets.ī) To choose some worksheets, but not others, select from the list on the left and use the Add or Remove buttons to move them to the list on the right.Ĭ) Click the Convert to PDF button to complete the process And, No, you don’t have to convert each worksheet separately! Converting Multiple Worksheetsįortunately, Acrobat 9 and Acrobat X can easily convert all of the worksheets in your Excel files to PDF: Yes, Acrobat can convert multiple Excel files to PDF. Do I have to convert each worksheet separately? Is there a way to do this in Acrobat? A lot of the files have multiple worksheets, too. I have several hundred Excel files to convert to PDF as part of a case. I recently received the following inquiries below from customers: Updated! I added some more options in this article, October 2010.