How to Convert Excel Files to PDF

Converting Excel files to PDF is fairly straightforward, but there are a few things you may want to keep in mind. Here’s an easy tutorial for you to follow that will help you get the most out of your experience.

Things You’ll Need

  • A computer
  • An internet connection
  • Printer
  • Excel
  • Adobe Acrobat Reader DC

Step 1: Open Excel

The first step is to open Excel. You’ll want to navigate to the file you want to convert and click the Open button. Once it’s opened up, you’ll see a small piece of code at the top of the worksheet. If you click that code, you’ll notice a small grey window with some text in it. In this tutorial, we’ll be using the Python programming language for scripting, so you’ll want to type in the following text and click the Run button:

from openpyxl import Workbook as Wb

Then, instead of clicking OK, you’ll want to press the Save As PDF button, which will then save the file with a.pdf extension. If you try to open the file now, you’ll see a notification that the file is “protected” due to the scripting.

Step 2: Convert Worksheet to PDF

Once you’ve saved the file with the extension, you can start the process of converting the worksheet to PDF. All you have to do is navigate to the folder where you saved the file, and double-click the file to open it in Adobe Acrobat Reader. After opening the file, you’ll see a file menu on the top left. Choose the “File” option and then navigate to the “Export” tab. You can either choose to “Export to PDF” or “Export to Print”. PDF is a file format that will look the same no matter what device you use to read it, so it’s perfect if you’re looking to give the file to someone later.

Step 3: Print PDF

Once you’ve exported the PDF, you can print it. However, if you’re looking to create a physical copy of the file, you’ll want to first scan it. After scanning, you can continue with the print process. When printing, you may want to make sure you look at the settings on your printer to ensure that the quality is saved as well as possible.

Things To Keep In Mind

Converting Excel files to PDF is an easy process, but it’s not exactly straightforward. If you want to ensure that everything looks exactly the same when you view the file on a different device or software, you may want to consider making some additional adjustments to the settings. Additionally, you should consider checking for updates to Acrobat Reader if you’re using an older version. Older versions may not support the scripting language that Excel is written in, so you’ll want to make sure you’re not out of date before converting files.

This process is fairly simple and straight forward, but there are a few things you should remember. First off, make sure that you save the file with a.pdf extension. This will ensure that it is recognized by Adobe Acrobat Reader as a PDF file and will not be “treated” as a Microsoft Excel file. Second, make sure that you’re not out of date with the latest version of Acrobat Reader. Third, when scanning the PDF file for printing or displaying on other devices, you may want to consider adjusting the settings to match the original file as closely as possible. Finally, make sure that you download the proper drivers for your printer before starting any print jobs. If everything is set up correctly, you should have no problems finishing this process successfully.

Thanks for reading! We hope this was helpful to you. If you have any questions, feel free to reach out to us through our website or through one of our social media accounts (@thepdfgroup). Happy converting!

Scroll to Top