Convert Specific Excel Worksheet to PDF using PDF.co and Make

In this tutorial, we will show you how to convert specific excel worksheets to PDF using PDF.co and Make. We will use a sample invoice from a Google Sheet for the source file.

Sample XLS source file
Sample XLS source file

Step 1: Create New Scenario and the Add PDF.co App

In Make start a new scenario and search and select the PDF.co app.

Select the PDF.co App in the list
Select the PDF.co App in the list

Step 2: Make an API Call

Then, choose the Make an API Call module.

Make an API Call
Make an API Call

Step 3: Configure the API Call

Let’s set up the PDF.co Make an API Call module.

  • In the API Endpoint Path field, type in /v1/xls/convert/to/pdf the endpoint.
  • For the Input Type field, select the Override “url” param with value as an input.
  • In the URL field, enter the source file link. The Embed link from Google Sheet works here.
  • Type in your desired PDF output name for the Output File Name field.
  • Under the Body param, type in the worksheet index parameter as the key. The worksheet index parameter will allow you to specify which specific sheet you’d like to convert to PDF. Then, type the value of the particular sheet you’d like to convert into a PDF. The worksheet index starts at 0 for sheet 1 and the worksheet index 1 represents sheet 2.
Configure the API Call
Configure the API Call

Step 4: Run the Scenario

Hit the button to run the scenario. You can copy the URL and paste it into your browser to view the output.

URL in Output
URL in Output

Step 5: Converted PDF Output

Here’s what the converted PDF output looks like.

Converted PDF Result
Converted PDF Result

In this tutorial, you learned how to convert a specific excel worksheet to PDF using PDF.co and Make. You learned how to use the /v1/xls/convert/to/pdf endpoint to convert XLS to PDF format. You also learned how to use the PDF.co Custom API Call Web API to generate PDF.

Video Guide