The Scenario
You're a content marketing manager at an agency. Your client is three days from a product launch and you've got 400 blog post URLs staged in an Excel table — column A is the long URL, columns B through D are UTM source, UTM medium, and UTM campaign, column E holds the tag label. The client's branded Short.io domain needs to be set up with a link for every row before the campaign brief goes to the email team.
The bad version:
- Open Short.io, create each link manually by selecting the domain, pasting the URL, filling in all UTM fields, applying the tag, saving, and copying the short URL back into the Excel table
- Repeat 400 times while context-switching between your Excel workbook and the browser
- Discover at row 180 that the UTM medium column had a trailing space in the header name and you've been leaving that field blank on every link you created
You were supposed to be reviewing the campaign copy today. Instead, you've been doing data entry for three hours and you're not halfway through.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your columns, connects to Short.io, and creates every link in one operation — writing the results back into the workbook without you touching the dashboard at all.
Create a Short.io short link for each of the 400 rows in my Excel table using domain 'go.mycompany.com', set the title from column C, apply the tag in column D, and paste the short URL into column E
What You Get
- Column E fills with branded short links, one per row, using the client's custom domain
- UTM parameters from columns B, C, and D are applied to each link during creation
- Tags from column D are attached to each Short.io link
- Any row that fails surfaces an error note in column F so you can fix and re-run that specific row without touching the ones that succeeded
What If the Data Is Not Quite Ready
The UTM columns have inconsistent capitalization across rows
Different team members populated the table and some UTM values are mixed-case while others are lowercase — Short.io treats these as distinct values in analytics.
Before creating links, normalize columns B, C, and D to lowercase throughout the Excel table, then create Short.io short links for each row using column A as the URL, the cleaned UTM values from B through D, and tags from column D — write results into column E
Some rows in column A are missing the https:// prefix
The table was assembled from multiple sources and some entries are bare domain names without the protocol.
For any URL in column A that does not start with https://, prepend https:// before creating the Short.io link — then run the bulk creation using UTM parameters from columns B through D and tags from column D, writing short URLs into column E
The tag column E uses comma-separated values but Short.io expects an array
Some rows have a single tag, others have two or three tags comma-separated in the same cell.
Parse the tag field in column E — treating comma-separated values as multiple distinct tags — then create Short.io short links for each row using the URL from column A, UTM parameters from columns B through D, and the parsed tag array from column E, writing results into column F
Full cleanup plus creation in one shot
Normalize all URLs in column A to include https://, lowercase all UTM values in columns B through D, split comma-separated tags in column E into arrays, then create Short.io short links for every row in the Excel table and write the resulting short URL into column F — flag any rows that fail with an error note in column G
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with a column of long URLs staged for shortening — then ask it to create the whole batch at once. Also see how to pull click stats back into the same workbook, or enrich existing Short.io link IDs with full metadata.