The Scenario
You are an SEO specialist. Your client migrated their store to CloudCart last month. The migration consultant delivered a redirect map as an Excel workbook: 300 rows, old path in column A, new URL in column B. Every redirect needs to be live in CloudCart so organic traffic lands on the correct page.
Google is re-crawling the old URLs. Each additional day without redirects is measurable ranking signal loss.
The dashboard alternative:
- Open CloudCart URL redirects, click "Add redirect"
- Paste the source path from the workbook, paste the target URL, save
- Repeat 300 times
- Discover on redirect 180 that you pasted column B values into the source field for the past ten rows and now ten old paths redirect to themselves
- Spend an hour undoing the bad redirects before continuing.
One prompt creates all 300 correctly.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that reads the migration map and creates every redirect in CloudCart.
Open the SheetXAI sidebar and type:
Add all 300 redirects from this workbook into CloudCart using the old URL in column A and the new URL in column B, all as "manual" type. Write the CloudCart redirect ID into column C for each success and the failure reason into column D for any failure.
SheetXAI reads all 300 rows, creates each redirect, and writes results back to the workbook.
What You Get
A complete redirect implementation with confirmation:
- All 300 redirects created in CloudCart — source path and target URL from the workbook
- Column C with redirect IDs — the client deliverable
- Column D failure log — any redirects that failed with a specific reason
The redirect IDs in column C are your deliverable. Copy columns A and C into the client handoff report: old path, CloudCart redirect ID, done.
What If the Data Is Not Quite Ready
Migration maps assembled by consultants frequently have formatting issues.
When source paths include the full domain
The migration map has full URLs like https://oldsite.com/products/widget but CloudCart expects just the path /products/widget.
Strip the domain from all values in column A so only the path remains, starting with /. Then create CloudCart redirects for all rows using the cleaned source paths and target URLs in column B.
When target URLs are relative paths instead of absolute
Column B has a mix of full URLs and relative paths like /products/widget. CloudCart requires absolute URLs for redirect targets.
For any column B value that does not start with "https://", prepend "https://newsite.cloudcart.net". Then create CloudCart redirects for all rows.
When duplicate source paths appear
The migration map was assembled from multiple sheets and some source paths appear twice. Duplicates cause conflicts in CloudCart.
Deduplicate the workbook by column A keeping the last occurrence (last is more likely the correct destination). Then create CloudCart redirects for the deduplicated rows.
When you need the full cleanup and redirect creation in one pass
Full domains in column A, relative targets in column B, duplicates, and you need redirect IDs plus a summary for the client.
Strip domains from column A leaving only the path starting with /. For relative column B values, prepend "https://newsite.cloudcart.net". Deduplicate by column A keeping the last occurrence. Create CloudCart URL redirects for all remaining rows as "manual" type. Write redirect IDs into column C and failures into column D. Add a summary in column F rows 1 to 4: total processed, redirects created, duplicates removed, failures.
The pattern: clean the source data and create all redirects in one instruction.
Try It
Get the 7-day free trial of SheetXAI and open your migration map workbook, then ask it to create all redirects in CloudCart. The CloudCart integration is included in every SheetXAI plan. See also how to bulk-create products from a catalog workbook or the CloudCart in Excel overview.