# How to Link a PDF in Google Sheets (2026)

- url: https://www.plox.in/blog/how-to-link-a-pdf-in-google-sheets
- date: 2026-06-24
- tags: Google Sheets, PDF, Document sharing, How-to, Productivity
- excerpt: Upload your PDF to Drive, grab the share link, and use =HYPERLINK("url","label") or Insert > Link to add it to a cell. Sheets links out, it cannot embed or.

To link a PDF in Google Sheets, upload the PDF to Google Drive, copy its shareable link, then put `=HYPERLINK("url","label")` in a cell, or select a cell and use Insert > Link. Sheets links out to the file; it cannot embed or preview a PDF inline, and there is no native thumbnail.

## TL;DR

- Fastest way to link a PDF in Google Sheets: upload it to Drive, get the share link, and use `=HYPERLINK("drive-url","Open PDF")` in a cell.
- The no-formula path is Insert > Link (or Ctrl/Cmd+K) on a selected cell, then paste the Drive URL.
- Google Sheets cannot truly embed or preview a PDF inline. It only links out, and there is no native way to show a thumbnail.
- For an internal sheet, a plain Drive HYPERLINK is fine. When the PDF is sensitive or goes to outside parties, link a [trackable Plox link](/document-control) instead so you can see who opened it, add a passcode or expiry, and swap the file without touching the cell.
- Copy-paste the HYPERLINK formula cookbook below, including a variant that builds the link from a Drive ID column.

## Method 1: the HYPERLINK formula (the reliable one)

This is the method that survives copy-paste, sharing, and large sheets. It works because the link lives in a formula, not in cell-link metadata that some exports drop.

1. Open Google Drive and upload your PDF (drag it into drive.google.com, or use New > File upload).
2. Right-click the PDF, choose Share, set access to "Anyone with the link" if the recipient is outside your domain, and click Copy link.
3. Go to your Google Sheet and click the cell where you want the link.
4. Type the formula and paste your URL between the first set of quotes:
   `=HYPERLINK("https://drive.google.com/file/d/FILE_ID/view","Open PDF")`
5. Press Enter. The cell now shows the clickable label "Open PDF".

The second argument is the friendly label. Skip it and the cell shows the raw URL, which is ugly in a tidy sheet. Keep labels short: "Open PDF", "View contract", "Q3 report".

One catch with Drive URLs: the default `/view` link opens Google's PDF viewer in a new tab. If you want the file to download instead, swap the URL for the export form, covered in the cookbook below.

## Method 2: Insert > Link (no formula)

If you would rather not touch a formula, Sheets has a built-in linker.

1. Click the cell.
2. Open Insert > Link, or press Ctrl+K (Windows) / Cmd+K (Mac).
3. Paste the Drive share URL into the link field.
4. Optionally edit the "Text" field to set the display label, then click Apply.

This is quick for a one-off. The downside: the link is attached to the cell as a property, not a formula. If you copy that cell to another sheet, sort the range, or export, the link can behave differently than a HYPERLINK formula. For anything you will reuse or hand off, the formula is sturdier.

## The honest limitation: Sheets links out, it does not embed

This trips people up, so be clear-eyed about it. Google Sheets cannot embed a PDF inside a cell or render it inline the way Google Docs can with an image. There is:

- No inline PDF preview. The link opens the file in a new tab.
- No native thumbnail. You cannot make a cell show the first page of the PDF automatically.
- No page-level rendering. Sheets is a grid of values, not a document canvas.

People reach for workarounds, and it is worth knowing they are workarounds. `=IMAGE()` only displays image files (PNG, JPG, GIF), not PDFs, so it will not show a PDF page. You can manually screenshot page one, upload that PNG to Drive, and `=IMAGE()` it next to the link, but now you maintain two assets and the thumbnail goes stale the moment the PDF changes. For a real preview experience, you link out to something that renders the PDF, which is exactly where a viewer-based link earns its keep.

If your goal is genuinely just "a clickable reference to a file in an internal tracker," stop here. The plain Drive HYPERLINK is the right tool and you are done. The rest of this guide is for when the PDF matters more than that.

## The upgrade: link a trackable Plox link instead of a raw Drive URL

A raw Drive link is a dead end once it leaves your sheet. You cannot see whether anyone opened it. You cannot expire it. And if you update the PDF, you often get a new file and a new URL, so the cell now points at the old version or a broken link.

[Plox](/document-control) gives you a link that behaves like a real document, not a file path. You upload the PDF once and share a trackable link. That link is what goes in your HYPERLINK formula. Here is the real path:

1. Sign in to Plox and click New, then upload your PDF. The [free plan](/document-control) covers secure links, analytics, and real-time view notifications with no credit card and no time limit.
2. Open the document's link settings. Toggle on what you need: a passcode, email verification, link expiry, allow or block download, and a one-click NDA gate.
3. On paid plans, turn on dynamic watermarking so every page is stamped with the viewer's email, applied per viewer.
4. Copy the Plox share link.
5. In Google Sheets, drop it into the formula: `=HYPERLINK("https://app.plox.in/v/your-link","View deck")`.

Now the cell in your sheet is a control surface. Because the Plox link never changes, you can update the underlying PDF anytime and every sheet pointing at that cell instantly serves the new version. No re-sharing, no chasing stale URLs. And every open is logged: who opened it, time per page, completion percentage, with a real-time notification when it happens. That is the difference between a link you send and a document you can [track](/blog/how-to-track-documents).

## Original asset: the HYPERLINK formula cookbook

Copy these directly into Google Sheets. Replace the placeholder URLs and column references with your own.

**1. Basic link (raw URL shows in the cell):**

```
=HYPERLINK("https://drive.google.com/file/d/FILE_ID/view")
```

**2. With a friendly label:**

```
=HYPERLINK("https://drive.google.com/file/d/FILE_ID/view","Open PDF")
```

**3. Force download instead of opening Google's viewer:**

```
=HYPERLINK("https://drive.google.com/uc?export=download&id=FILE_ID","Download PDF")
```

**4. Build the link from a Drive File ID column (put the bare ID in column A, the label in column B):**

```
=HYPERLINK("https://drive.google.com/file/d/"&A2&"/view", B2)
```

Drag this down a column and every row becomes a clickable link generated from its ID. This is the pattern to use when you are managing dozens of PDFs in a tracker.

**5. Plox trackable link with a label (recommended for sensitive or external PDFs):**

```
=HYPERLINK("https://app.plox.in/v/YOUR_PLOX_LINK","View document")
```

You can also build Plox links from an ID column the same way as variant 4, with `"https://app.plox.in/v/"&A2` as the URL argument.

### Raw Drive link vs Plox link

| Capability | Raw Google Drive link | Plox trackable link |
|---|---|---|
| Works as a HYPERLINK in Sheets | Yes | Yes |
| See who opened the PDF | No | Yes, with name/email and real-time alerts |
| Page-by-page analytics (time per page, completion %) | No | Yes |
| Update the file without changing the cell link | No, new file often means a new URL | Yes, link stays the same, file updates in place |
| Passcode / email verification | No native passcode | Yes |
| Link expiry and revoke access | No | Yes |
| Dynamic watermark per viewer | No | Yes (paid) |
| One-click NDA before access | No | Yes |
| Cost for basic use | Free | Free plan, no card, no time limit |

For a deeper walkthrough of turning any file into a shareable link, see [how to turn a PDF into a link](/blog/how-to-turn-a-pdf-into-a-link).

## When each method is the right call

Use the table above as a gut check, but the rule of thumb is simple.

A plain Drive HYPERLINK is genuinely the right choice when the sheet is internal, the PDF is not confidential, and nobody cares who reads it. An expense-policy PDF in a team ops tracker does not need tracking. Adding it would be overhead for no benefit.

The trackable link earns its place the moment the PDF is sensitive or leaves your company: a pitch deck in an investor tracker, a contract going to a counterparty, a financial model in a fundraising sheet. There you want to know who opened it, you want a [passcode or expiry](/blog/how-to-password-protect-a-pdf), and you want to update the file without breaking every link in the sheet.

Google Drive itself is genuinely good at one thing here: frictionless, free file hosting that anyone with a Google account already has. You do not need a new tool to get a working link. Plox is the upgrade for control and visibility, not a replacement for casual file storage.

## Frequently asked questions

**Can I embed or preview a PDF inside a Google Sheets cell?**
No. Google Sheets cannot render a PDF inline or show a live preview in a cell. It only stores a link that opens the file in a new tab. The `=IMAGE()` function works for image files like PNG and JPG, not PDFs, so it cannot display a PDF page either.

**How do I show a thumbnail of the PDF in Sheets?**
There is no native way. The common workaround is to screenshot the PDF's first page, save it as a PNG, upload that to Drive, and place it with `=IMAGE("png-url")` next to the link. It works but the thumbnail does not update when the PDF changes, so you maintain two files.

**Why does my Drive link open Google's viewer instead of downloading?**
The standard `/view` URL opens Google's built-in PDF viewer. To force a download, use the export URL form: `https://drive.google.com/uc?export=download&id=FILE_ID`. Variant 3 in the cookbook above does exactly this.

**How do I make sure the link still works after I update the PDF?**
With raw Drive links you often cannot, because replacing a file can create a new ID and a new URL. Upload the PDF to a Plox link instead. The Plox link stays constant while you update the file in place, so every cell pointing at it serves the latest version automatically.

**Can I see who opened the PDF I linked in my sheet?**
Not with a raw Drive link. Drive shows you the file's own activity, not per-recipient opens of a shared link. A Plox link logs who opened it, time spent per page, completion percentage, and sends a real-time notification on each view.

**Is linking a PDF in Sheets secure enough for confidential documents?**
A public "anyone with the link" Drive URL is not secure for confidential files, since anyone who gets the link can open it. For sensitive PDFs, gate the link with a passcode, email verification, expiry, or an NDA, which is what a [trackable link](/document-control) is built for.

## Put control behind the link

If the PDF in your sheet is a pitch deck, a contract, or a financial doc that matters, do not let it leave on a naked Drive URL. Upload it to Plox, switch on a passcode and analytics, and paste the trackable link into your HYPERLINK formula. You keep the tidy sheet and gain a record of every open. [Start free with Plox](/document-control), no credit card, no time limit.