Creating hundreds of links from a spreadsheet

Design the sheet around the output

One row per link. Columns for destination, slug, title, tags, folder and the five UTM fields. Keep the destination clean — build UTM values in their own columns and let the platform assemble the final URL, rather than pasting pre-tagged URLs you cannot audit.

Formulas that prevent typos

Generate the slug from a name column with a formula that lowercases and replaces spaces with hyphens. Build the campaign name from a base plus a date cell so every row of a campaign matches exactly. Use data validation dropdowns for medium and source so nobody invents "e-mail".

Check before you import

Add a column that flags rows where the destination is empty, does not start with http, or where the slug duplicates another row. Sort by that column and fix the flagged rows first. Five minutes here saves an hour of cleanup.

Import, map, review

A good importer shows you the detected columns and lets you map each one to a field before anything is created. Always look at the preview rows: a shifted column is obvious in the preview and invisible in the finished import.

Fix failures from the error report

Failures are almost always a taken slug or a malformed URL. Download the error CSV, fix those rows, and re-import just that file rather than the whole sheet.

Editing in bulk afterwards

The same layout works in reverse: export existing links, edit the cells you want to change, and re-apply. It is the fastest way to add a tag to two hundred links or repoint a folder full of links after a site migration.