Clipkaro.com: How to Generate Bulk Dropbox Links on Microsoft Excel

How to Generate Bulk Dropbox Links on Microsoft Excel (2 Easy Methods)

If you have ever uploaded hundreds of files to a Dropbox folder and then realised you need the direct shareable link of every single file in a list, you already know how painful the manual job is. Right-click → Share → Copy link → paste → repeat 500 times. Nobody has time for that.

In this tutorial I will show you two working methods to generate bulk Dropbox links inside Microsoft Excel — one is the classic VBA macro method, and the other is a much faster no-code online tool that does the same job in one click (no macros, no scary security warnings, works on Mac too).

Let’s get started.

Why You Might Need Bulk Dropbox Links

Before we jump into the steps, here is the typical use case. Suppose you have:

A Dropbox folder with hundreds of product photos, rock samples, PDFs, or invoices.
A database, GIS layer, ArcGIS popup, Google Sheet, or website where you want every file’s public URL.
No time (or no interest) to use the Dropbox API or write Python scripts.

The trick is simple — Dropbox already attaches a hyperlink to each file when you copy-paste them from the web interface into Excel. We just need a clean way to pull those hidden URLs out into a separate column. That’s exactly what we’ll do below.

Method 1: The Easy Way — Using Clipkaro Hyperlink Extractor (Recommended)

If you don’t want to mess with VBA, macro security warnings, or Mac compatibility issues, the fastest way is to use a free browser-based tool I built for exactly this situation:

👉 Open the Clipkaro Hyperlink Extractor

It does the same thing a VBA macro does — extracts every hyperlink from your Excel file and puts the URL in the next column — but it runs inside your browser, so your file never gets uploaded to any server.

Steps:

Get the Dropbox links into Excel. Open the Dropbox shared folder in an Incognito / Private window (so it doesn’t open in the Dropbox app), select all the files using Ctrl + A, copy them with Ctrl + C, then paste them into a blank Excel sheet using Ctrl + V. Excel will paste the file names along with the thumbnails — that’s fine.
(Optional) Delete the pasted images. Go to Home → Find & Select → Go To Special → Objects → OK, then press Delete. This removes the thumbnails and leaves only the clickable file names with hidden hyperlinks.
Save the file as .xlsx.
Go to the Hyperlink Extractor tool, drop your file onto the upload area, and click Extract Links.
Hit Download Excel. Done — every Dropbox URL is now in the column next to its file name.

Why people prefer this over VBA:

✅ Zero setup — no macros to enable, no code to paste.
✅ Works on Windows, Mac, Chromebook, anywhere with a browser.
✅ Scans all sheets at once, not just the active one.
✅ 100% private — file is processed locally in your browser, not uploaded.
✅ Free, no signup, no usage limits.

Method 2: The Classic VBA Macro Way

If you prefer doing it inside Excel itself with a small piece of code, here’s the traditional method.

Step 1 — Copy the file list from Dropbox

Open your Dropbox shared folder in an Incognito browser (this avoids logging in, which makes Dropbox switch to a different layout that doesn’t allow easy multi-select). Press Ctrl + A to select all files, copy them, and paste them into a blank Excel sheet.

Step 2 — Remove the thumbnail images

When you paste, Excel keeps both the file names and the image previews. To clean it up:

Go to Home → Find & Select → Go To Special.
Choose Objects and click OK.
All images get selected — press Delete.

You should now have a clean list of file names, each one still carrying its Dropbox hyperlink underneath.

Step 3 — Open the VBA editor and add a new module

Press Alt + F11 to open the VBA editor.
Right-click your workbook in the left panel → Insert → Module.
Paste this code into the new module:

Sub ExtractHL()
    Dim HL As Hyperlink
    For Each HL In ActiveSheet.Hyperlinks
        HL.Range.Offset(0, 1).Value = HL.Address
    Next
End Sub

Step 4 — Run the macro

Press F5 (or go to Run → Run Sub). The macro walks through every hyperlinked cell and writes its URL into the next column. That’s your bulk Dropbox link list.

Heads up: macros only run on the currently active sheet, and Excel for Mac sometimes blocks them with security warnings. If you hit those issues, just use Method 1 instead — it bypasses all of that.

VBA Macro vs Online Tool — Quick Comparison

Feature	VBA Macro	Clipkaro Hyperlink Extractor
Setup time	Enable macros, paste code	Zero — just open the page
Security warnings	Yes (scary popups)	None
Mac support	Limited / patchy	Works on any device
Multi-sheet	Active sheet only	All sheets at once
Privacy	Local (file open in Excel)	Local (browser-only, no upload)
Cost	Free	Free, no signup

Convert Dropbox Links Into Direct Download / Image URLs

One more pro tip: the URLs Dropbox gives you end in ?dl=0, which opens the Dropbox preview page instead of the actual file. If you need the raw image / direct file (for example, to show photos in an ArcGIS popup or embed them on a website), do a find-and-replace in your URL column:

Replace ?dl=0 → ?raw=1 (to load the file directly)
Or replace www.dropbox.com → dl.dropboxusercontent.com (for direct download)

FAQ

Q. Does Dropbox have a built-in option to export all links at once?
No. As of today, Dropbox doesn’t expose a simple “export all links” button in the UI. You either use their API or use the copy-paste-into-Excel trick described above.

Q. Will this work for Google Drive links too?
Yes. The same Excel/VBA logic works for any hyperlinks pasted into a cell — Google Drive, OneDrive, vendor sites, anything. The Clipkaro tool handles all of them.

Q. Is my Excel file uploaded anywhere when I use the online tool?
No. The extractor runs entirely inside your browser tab — nothing is sent to any server, so private Dropbox links stay private.

Q. What if the file names are too long and get cut off with “…”?
This happens when Dropbox shortens long file names in the web view. The hyperlink (URL) still works correctly — it’s only the visible text that’s shortened. If you need the full original file names, rename them inside Dropbox first, or pull them from the Dropbox API.

Wrapping Up

Generating bulk Dropbox links inside Excel used to be a pain that needed VBA, macros, and a Windows machine. Now you have two solid options:

If you’re a power user who’s comfortable with Excel macros, use the VBA method above.
If you want the fastest, no-fuss path that also works on Mac, just drop your file into the Clipkaro Hyperlink Extractor and download your link list.

Either way, you’ll save hours of clicking. If this guide helped you, share it with someone who’s still copying Dropbox links by hand 😄