The Scenario
You are an e-commerce manager migrating from Klaviyo to eSputnik. The migration is live in four business days.
You have 900 historical orders in an Excel workbook on the "Historical Orders" tab: customer email in column A, external order ID in column B, order total in column C, product name in column D, order date in column E. That history needs to be in eSputnik before launch so the abandoned-cart and repurchase automations have enough data to trigger from day one.
The slow version of this week:
- You read eSputnik's event import documentation and realize it needs a specific field structure
- You ask your developer to convert the workbook rows into the right API format
- The developer is mid-sprint and gets to it two days later
- The script runs but errors on 40 rows with date formats Excel stores differently from what eSputnik expects
- You manually fix the dates, re-run, re-import
- It is Thursday and you have not verified whether the automations are actually triggering.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads the workbook tab and calls eSputnik's event import API for you, handling date formatting and field mapping automatically.
Open the SheetXAI sidebar and type:
Push every row in my Excel 'Historical Orders' tab to eSputnik as a past order event: email in A, order ID in B, amount in C, product name in D, date in E.
SheetXAI reads every row, structures each as an eSputnik order event with the right field names, calls the import API, and returns a confirmation. The automations have the history they need before launch.
What You Get
900 historical order events in eSputnik, structured correctly for automation triggers:
- Each row imported as an event — not as a contact field, as a trigger-able past order event
- Product name preserved — so product-specific automations like repurchase nudges have the right data
- Date field handled correctly — Excel stores dates as serial numbers internally; SheetXAI converts them to the ISO format eSputnik expects
- Confirmation returned — you know the import ran and how many events were processed
Excel date formatting is the silent migration killer. A date that looks like "14/03/2025" in a cell is actually stored as a number in Excel's format. A naive script that reads the raw value will send the wrong date to eSputnik and your repurchase timing will be off by years.
What If the Data Is Not Quite Ready
Migration source data from legacy platforms is always messy. SheetXAI handles the cleanup and the import in the same prompt.
When order dates are in mixed formats across rows
Some rows were entered manually as text ("March 14, 2025"), others are Excel date values. eSputnik needs one consistent format.
Normalize all dates in column E of the 'Historical Orders' tab to ISO format (YYYY-MM-DD), handling both Excel date values and text-format dates. Then import all rows into eSputnik as past order events — email in A, order ID in B, amount in C, product in D, normalized date in E.
When some orders have no total amount
A handful of rows have blank column C values from the old platform's data gaps.
Import all rows from the 'Historical Orders' tab into eSputnik as past order events. For rows where column C is blank, import the event with amount set to 0 and flag the row in column F with "MISSING AMOUNT." For all others, use the value in column C.
When you only want orders from the last 12 months
The workbook goes back three years but the automations only need recent purchase history to trigger correctly.
Filter the 'Historical Orders' tab to rows where column E is within the last 12 months from today. Import only those rows into eSputnik as past order events — email in A, order ID in B, amount in C, product in D, date in E.
When the export has duplicate order IDs from a platform sync error
The old platform's export script ran twice on one day and duplicated about 60 orders.
Deduplicate rows in the 'Historical Orders' tab by order ID in column B, keeping the first occurrence. Then import the deduplicated set into eSputnik as past order events — email in A, order ID in B, amount in C, product in D, date in E. Write the total imported event count into cell F1.
The pattern: instead of cleaning the export in one step and writing a separate import script in another, you ask for both in one prompt and have the migration done today.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with order history, then ask it to push the records to eSputnik. The eSputnik integration is included in every SheetXAI plan. See also how to bulk-import contacts from Excel into eSputnik or the eSputnik in Excel overview.