How to Add a PDF Link in Google Sheets (Link PDFs to Cells Easily)

Adding a PDF link in Google Sheets lets you open the file directly from a cell. Without it, you have to leave the sheet, search Google Drive, and find the file manually each time you need it.

You cannot embed a PDF inside a cell the way you attach a file to an email. Cells store values like text, numbers, and formulas. What you can do is add a clickable link so the PDF opens when someone clicks the cell.

In this tutorial, you will learn three ways to add PDF links in Google Sheets and when to use each one.

• Insert Link menu - quickest option for a few files.
• HYPERLINK formula - useful when you already have a column of URLs.
• Drive Explorer Pro add-on - the practical option when you have many files or need to upload from your computer.

Table of Contents

Prerequisites

Before you start, make sure you have:

• A Google account with access to Google Sheets
• PDF files saved in Google Drive, or files on your computer ready to upload
• Edit access to the Google Sheet you're working in

Uploading the PDF to Google Drive and Copying the Link

Before you add a PDF link in Google Sheets, the file needs to be in Google Drive and have the right access. This gives you a shareable URL for the built-in methods and makes the file easier to identify later.

If the PDF is already in Google Drive, skip to the next section.

Organizing the file

Organized folders and clear file names make PDF links easier to recognize and manage.

1. Create a dedicated folder in Google Drive, such as Invoices_2026, Client_Contracts, or Project_Reports_Q2.
2. Rename vague files like scan0047.pdf to something clear, such as Invoice_AcmeCorp_March2026.pdf.

Uploading the PDF

1. Go to Google Drive and open the folder.
2. Click + New > File upload.
3. Select the PDF and click Open.

Copying the link

1. Right-click the file and click Share > Share.
2. Under General access, choose the visibility you need:
   • Restricted - Only people you invite can open the file.
   • Anyone with the link - Anyone with the URL can open the file.
   • My organization - Anyone in your Google Workspace domain can open the file.
3. Click Copy link.

Important: Set the access level before copying the link. A Restricted link will show teammates an "Access denied" error when they click it in the sheet.

Now that your PDF is in Google Drive with a valid link, you are ready to add it to your sheet.

Inserting a Single PDF Link Using the Built-In Methods

Google Sheets has two built-in ways to add a clickable PDF link:

• Use Insert link menu option when you want to add one PDF link manually
• Use HYPERLINK when the URLs are already in cells and you want to create links across multiple rows

Both work for one or a few files, choose based on how your URLs are organised.

Using Insert Link Menu Option

Use Insert Link to add a link to one cell at a time with clean display text instead of a raw URL.

1. Click the cell where you want the link.
2. Press Ctrl+K (Windows) or Cmd+K (Mac). You can also right-click the cell and click Insert link.

3. Type the display text, which is the label shown in the cell (for example, Invoice_AcmeCorp_March2026).
4. Paste the Google Drive URL in the link field, or search for the file directly from your Google Drive.
5. Click Apply.

To edit the link, right-click the cell and select Edit link.

Alternative: @ Smart Chip :

If you know the file name in Google Drive, type @ in a cell, start typing the file name, and select it from the dropdown. This inserts a smart chip that shows the file icon and a hover card with details like the owner and last modified date.

Note: Smart chips do not change file access. If the file is private, the chip still appears, but people without access still cannot open it.

Use a smart chip when you want a richer preview and everyone using the sheet already has access to the file. Use Insert link when you want a standard clickable link that is simpler, clearer, and more predictable.

If you already have a column of Google Drive URLs in your sheet, the HYPERLINK formula is a faster approach.

Using the HYPERLINK Formula

You can use the HYPERLINK formula when you want to create clickable PDF links from Google Drive URLs.

Use it to create one link manually or many links by dragging the formula down.

This formula is useful in two situations:

1. You want to add one clickable PDF link by typing the URL and link label directly in the formula.
2. You already have URLs or label text in other cells and want to create links for multiple rows automatically.

The syntax is:

=HYPERLINK("URL", "display text")

Here is what each part means:

• "URL" is the PDF link you want to open.
• "display text" is the clickable text shown in the cell.

1. Typing both parts directly

Use this when you only need one PDF link and want to enter both the URL and the label in the formula itself.

=HYPERLINK("https://drive.google.com/file/d/abc123/view", "View PDF")

This creates a clickable link labeled View PDF.

2. Referencing values from other cells

Use this when the PDF URLs are already stored in a column and you want each row to generate its own clickable link.

For example, if column B contains the PDF URLs and column A contains client names:

=HYPERLINK(B2, A2)

In this case:

• B2 provides the PDF URL.
• A2 provides the clickable label.

Drag the formula down to create a labeled PDF link for each row automatically.

Common errors: #ERROR! - place the URL in-between double quotes or check the referenced cell has no extra spaces.

Both built-in methods work well for a few files. Beyond that, they quickly become limiting.

• You cannot upload PDFs directly from your computer.
• You do not get file details automatically.
• You have to manage the sheet manually as the list grows.
• Each link becomes one more repetitive task.

If you need to work with multiple PDFs, the next method is more practical.

Inserting Multiple PDF Links Using Drive Explorer Pro add-on

Drive Explorer Pro is a Google Workspace add-on that runs in a sidebar inside Google Sheets. You can use it to upload many PDF files, add their links to your sheet, and log file details in separate columns.

It works with both files already in Google Drive and files on your computer. It can also apply file access settings while uploading the files and adding their links to Google Sheets.

This is useful for invoices, reports, client files, student submissions, audit logs, and other document trackers.

Install Drive Explorer Pro from the Google Workspace Marketplace:

Launching Drive Explorer Pro

Once installed, open the add-on from inside your sheet so the sidebar is available without leaving Google Sheets.

1. Click Extensions > Drive Explorer Pro > Open Drive Explorer Pro.
2. The sidebar opens on the right side of your sheet.

Supported file types: Any file type — PDFs, Word docs, Excel files, images, ZIP archives.

Configuring Settings (One-Time Setup)

Before running either workflow, spend a minute on settings. First set file access, then choose where the files should appear in the sheet and which columns to include.

In the Settings tab, set File Access to control who can open the linked PDFs:

Click Save settings as default to keep these settings for future files.

In the List Files tab, choose where files are written in your sheet and which columns appear:

• Currently Selected Cell - starts at the cell you've clicked (use for new sheets).
• Append Below Existing Data - adds below existing rows without overwriting anything.

Select the file attributes you want as columns. For PDF tracking, start with File Name Linked to URL and Direct Download Link - then add others as needed:

Click Save settings as default when done.

With settings saved, you're ready to run either workflow depending on where your files are.

Listing Existing Google Drive Files in Sheets

Use this when your PDFs are already in Google Drive.

1. In the List Files tab, click Select existing files from Drive and List in Sheets.

2. In the file picker, browse to your PDFs, click the Shared drives tab on the left to access team drives.

3. Select the files and click Select.

If your PDFs haven't been uploaded to Google Drive yet, use the Upload workflow instead.

Uploading Files from Your Computer and Linking Them

Use this when your PDFs are still on your computer. Drive Explorer Pro uploads them to Google Drive and adds their links to Google Sheets in a few clicks.

1. Click Change under Default Google Drive Folder and select the destination folder.
2. Go to the Upload Files tab.

3. Drag and drop your PDFs into the upload box, or click to browse.
4. Select the files and click Open.
5. Reorder files by dragging if row order matters.
6. Click Upload files to Drive and list in Sheets.

If an upload fails: Confirm edit access to the destination folder.

Choosing the Right Method

Each method fits a different scale. Here's how they compare:

• 1–5 files already in Google Drive? → Insert Link (Ctrl+K)
• Have a column of URLs to clean up? → HYPERLINK formula
• 10+ files, uploading from your computer, or need metadata? → Drive Explorer Pro

If the PDF needs to be stored in a team location, see how to upload files to a shared Google Drive folder.

Conclusion

Choose the method that fits your workflow and file volume. Once each row has a clickable PDF link, your sheet becomes one place to manage both the record and the document without searching Drive each time, without searching Google Drive or switching between tabs.