The Scenario
You are a promotions manager. Your team generated 5,000 unique single-use promo codes for a winter clearance campaign. The codes are in an Excel workbook, one per row in column A.
eSputnik needs all 5,000 uploaded before the campaign builder can assign a unique code per recipient. The campaign sends in 36 hours.
The slow version of this task:
- You open eSputnik and find the promo code upload section
- The upload expects a CSV with a specific header name. You save the Excel file as CSV from the desktop app
- The upload runs and eSputnik reports 43 failures but gives you no row references
- You download the error report, open it, realize the 43 failures are codes with leading whitespace that Excel added when the column was formatted as text
- You go back to the workbook, fix the 43 codes, re-save as CSV, re-upload the subset
- The campaign builder is waiting and your manager is asking for an ETA.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the workbook and calls eSputnik's promo code upload API for you, trimming and validating inline.
Open the SheetXAI sidebar and type:
Upload all promo codes in column A of my Excel sheet to eSputnik as 20%-off codes expiring 2025-12-31.
SheetXAI reads every code in column A, calls eSputnik's promo code API with the right discount type, value, and expiry, and returns the uploaded count. No CSV step, no re-upload loop.
What You Get
5,000 promo codes uploaded to eSputnik and confirmed in the workbook:
- Discount type and value set — 20% off, percent-type, no manual entry in the eSputnik UI
- Expiry date applied to all codes — set once in the prompt, not configured per code
- Upload confirmation returned — total count of successfully uploaded codes, not just "completed"
- Failures surfaced per row — any code that fails gets logged in a status column, not dropped silently
Excel text column formatting is the quiet failure mode here. When a column is formatted as Text in Excel, numbers and values often gain a leading apostrophe or whitespace that is invisible in the cell but present in the raw data. eSputnik's API rejects these. SheetXAI trims and normalizes the values before calling the API, so the 43 formatting failures do not happen.
What If the Data Is Not Quite Ready
Promo code exports from rewards and e-commerce platforms are consistently messy. SheetXAI handles normalization and upload together.
When codes have inconsistent casing
Some codes are uppercase, some are mixed. Your redemption system requires uppercase for matching.
Normalize all promo codes in column A to uppercase and trim whitespace. Then upload them to eSputnik as percent-type codes with a 20% discount and expiry 2025-12-31. Write the uploaded count into cell B1.
When the workbook has duplicate codes from a generation error
The rewards platform accidentally doubled a batch. Uploading duplicates causes assignment conflicts in eSputnik.
Deduplicate promo codes in column A of this workbook, keeping one instance per code. Upload the unique codes to eSputnik as percent-type codes with discount 20 and expiry 2025-12-31. Write the unique code count into B1 and the duplicate count removed into B2.
When each code has its own discount value in column B
Not all codes are 20% off. Column A has the code, column B has the discount percentage (10, 15, or 20).
Upload all promo codes in column A of this workbook to eSputnik. Use the discount percentage from column B for each code (type: percent). Apply expiry 2025-12-31 to all. Write the upload result into column C for each row.
When you want to clean, deduplicate, upload, and confirm in one pass
The export was assembled from three separate batches and has mixed case, duplicates, and codes with extra spaces.
Trim whitespace from all codes in column A. Convert them to uppercase. Deduplicate by code value. Upload the remaining unique codes to eSputnik as percent-type codes with discount 20 and expiry 2025-12-31. Write "uploaded" or the error into column B for each code. Write the total success count into cell C1.
The pattern: normalization, deduplication, upload, and confirmation in one prompt. The campaign builder gets the go-ahead this afternoon.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with promotional codes, then ask it to upload them to eSputnik. The eSputnik integration is included in every SheetXAI plan. See also how to send a personalised eSputnik message to an Excel recipient list or the eSputnik in Excel overview.