Building a reliable CSV workflow for link creation

One row is one link, always

Resist the urge to encode several links per row with columns like url_1 and url_2. It makes validation impossible and it breaks the moment someone needs a third. One row per link, with a column identifying which campaign and placement it belongs to, is easy to filter, easy to validate and easy to import.

Build the destination with a formula, not by hand

Keep the base URL and each UTM value in separate columns, then concatenate them in a formula column with proper encoding. Hand-typed destinations accumulate double question marks, missing ampersands and stray spaces. A formula produces the same shape every time, and fixing the formula fixes every row.

Guard against the classic spreadsheet corruptions

Autocorrect capitalises the first letter of a cell, which breaks a case-sensitive slug. Long numeric campaign codes are reformatted into scientific notation. Trailing spaces from a paste survive into the destination and produce a subtly wrong URL. Format the relevant columns as plain text before anyone types in them, and trim every value on export.

Validate before importing, in the sheet

Add checking columns: does the destination start with a scheme, is the slug duplicated within the file, does the slug contain only permitted characters, is any field blank. Conditional formatting that turns bad rows red catches nearly everything, and it catches it while the person who made the mistake is still looking at the file.

Import a sample first

Take five rows spanning the different shapes in the file, import them, and click each resulting link. Encoding problems and slug rules reveal themselves immediately at this scale and are painful to unwind at a thousand.

Write the results back into the same file

The import should produce a file containing the original rows plus the created short URL and a status per row. That file is what you distribute to the people who need the links, and it is the record you will want when someone asks where a link came from.

Keep a template, not a folder of one-off sheets

A single template with the columns, the formula, the validation rules and the dropdowns already in place means the next campaign starts from a known-good structure. Copies of last month's working file inherit last month's mistakes and last month's stale campaign name.