The Scenario
You are the sales operations manager at a company decommissioning a legacy CRM on Friday. The new system is CentralStationCRM. A sales team of eight has 300 past call notes in an Excel export on the Notes tab, one row per call with columns for contact email, note text, and call date. Every note needs to appear as a protocol entry in CentralStationCRM before Friday.
It is Tuesday. You have three days.
The slow version:
- Open CentralStationCRM in a browser, search for the contact by email
- Open the person record, navigate to protocols, click "Add note"
- Paste the note text, set the date manually, save
- Switch back to the Excel workbook, move to the next row
- You get through 40 rows in the first hour and do the math: 260 rows left at this pace means you finish Saturday at the earliest, a full day after the system is gone.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can look up each contact by email, create the protocol entry with the correct note and date, and confirm the operation row by row.
Open the SheetXAI sidebar and type:
For each row in the Notes tab, look up the person in CentralStationCRM by the email in column A. Create a protocol entry for that person with the note text in column B and the date in column C. Write the new protocol ID into column D. If the person is not found by email, write "NOT FOUND" in column D instead.
SheetXAI works through all 300 rows. Found contacts get a protocol entry. Not-found rows are flagged so you can handle them manually.
What You Get
A completed migration log in the workbook:
- Column D — protocol ID for every successfully created note
- Column D (flagged rows) — "NOT FOUND" for contacts the CRM could not match by email
The flag-and-skip behavior is the important part. You do not want 300 rows to fail silently because 12 emails changed between the old system and the new one. The "NOT FOUND" rows surface immediately.
What If the Data Is Not Quite Ready
Legacy CRM exports from older systems are reliably messy. SheetXAI handles the cleanup and the import in the same prompt.
When note dates are in inconsistent formats
The export has some dates as "2024-03-14," some as "March 14, 2024," and some as "3/14/24."
Normalize all dates in column C of the Notes tab to ISO format (YYYY-MM-DD). Then for each row, look up the person in CentralStationCRM by email in column A and create a protocol entry with the note in column B and the normalized date. Write the protocol ID into column D.
When note text contains formatting artifacts from the old system
The export has pipe characters, HTML entities, and legacy field markers in the notes.
For each row in the Notes tab, clean the note text in column B by removing HTML tags, converting pipe characters to spaces, and stripping strings that start with "[FIELD:" and end with "]." Then look up the person by email in column A and create the protocol entry with the cleaned note and the date in column C. Write the protocol ID into column D.
When you need to verify the protocol count before closing the old system
You want to confirm that the protocol count in CentralStationCRM matches what the old system had for each contact.
For each unique email in column A of the Notes tab, count how many rows appear in this workbook for that email. Then look up the person in CentralStationCRM by email and count how many protocol entries they have. Write the workbook count in column E and the CRM count in column F. Flag any row in column G where the counts do not match.
When each note also needs to be linked to a deal
The legacy system tracked which call was associated with which deal. You have the deal name in column D.
For each row in the Notes tab, look up the person by email in column A and the deal by name in column D in CentralStationCRM. Create a protocol entry with the note in column B and date in column C, and link the protocol to the matched deal. Write the protocol ID into column E and the deal ID into column F. If the deal is not found, create the protocol without a deal link and note "DEAL NOT FOUND" in column F.
The pattern: describe the full migration operation in one prompt. SheetXAI handles the lookup, the create, the conditional logic for not-found records, and the ID capture, all in one pass.
Try It
Get the 7-day free trial of SheetXAI and open the call notes export from your legacy CRM, then ask SheetXAI to create protocol entries in CentralStationCRM row by row. The CentralStationCRM integration is included in every SheetXAI plan. For related workflows, see how to bulk import contacts in Excel or the CentralStationCRM in Excel overview.