Home -> Law Blog Directory -> Law Technology Blogs -> Acrobat for Legal Professionals

Law Technology

: Acrobat for Legal Professionals

Batch Conversion of Excel to PDF

By Rick Borstein

I recently received the following inquiries below from customers::

I have several hundred Excel files to convert to PDF as part of a case. Is there a way to do this in Acrobat? A lot of the files have multiple worksheets, too. Do I have to convert each worksheet separately?

So Yes and No. Yes, Acrobat can convert multiple Excel files to PDF. And, No, you don't have to convert each worksheet separately!

Converting Multiple Worksheets

Fortunately, Acrobat 9 can easily convert all of the worksheets in your Excel files to PDF:

When you use the PDF Maker in Acrobat 9, you have some additional options to select just the worksheets needed:

A) Choose options to convert all worksheets, the currently selected worksheet or a subset of the worksheets.

B) 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.

C) Click the Convert to PDF button to complete the process

The result is a nicely bookmarked PDF that looks like this:

What about batch conversion?

If you want to convert many Excel documents in batch to PDF, there are a few additional tricks involved. Read on learn how in the rest of the article.

Full post as published by Acrobat for Legal Professionals on March 31, 2009 (boomark / email).