The Scenario
You bought a 200-address storm damage lead list — names, phones, emails, and property addresses in an Excel workbook — and your sales team starts calling at 8 AM. It's 10 PM the night before and none of those contacts exist in JobNimbus yet.
The bad version:
- Open a new JobNimbus contact form. Type the name, phone, email, and street address from row 2. Save. Open another form for row 3.
- 45 contacts in, you misread a phone number. That contact now has a transposed digit in every system it touches downstream.
- At row 120 you notice the address format in the sheet doesn't match what JobNimbus expects for the street field. You stop and try to figure out whether to fix the workbook or fix each contact record manually.
The lead list isn't the problem. The entry work is. You have 200 potential jobs sitting in a workbook and a team who can't work them until they're in the CRM — and nobody hired you to be a data entry clerk at 10 PM.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads the rows in your Leads worksheet, understands the column structure, and through its built-in JobNimbus integration it creates the contacts for you — all 200, in one shot.
For each of the 200 rows in my Excel prospect sheet, create a new JobNimbus contact and note any failures with the error message in column F.
What You Get
- A new JobNimbus contact for every row, created with the name, phone, email, and address from the workbook.
- The JobNimbus contact ID written back into column E for each successful row — so you have a direct reference linking your workbook to the CRM record.
- Rows that fail land a specific error message in column F instead of an ID, so you know exactly which ones need a fix before your team starts calling.
- No partial mystery failures. Every row either succeeds with an ID or fails with a reason.
What If the Data Is Not Quite Ready
Phone numbers in the workbook have mixed formats
Some rows have (555) 867-5309, some have 5558675309, some have +1 555 867 5309. JobNimbus may reject the inconsistent ones.
Before creating contacts, normalize all phone numbers in column B to the format 555-867-5309, then create a JobNimbus contact for each row using the cleaned phone number and write the contact ID into column E.
Some rows are missing an email address
A lead list from a door-knock campaign often has phone and address but no email. You don't want those rows to fail — you just want them created without the email field.
Create a JobNimbus contact for each row in my Excel prospect sheet. If column C is blank, skip the email field rather than failing. Use name from A, phone from B, address from D. Write the contact ID into column E or the error into column F.
The address is split across multiple columns
Your workbook has street in column D, city in column E, state in column F, zip in column G instead of a combined address field.
Create a JobNimbus contact for each row in my Excel prospect sheet using name from A, phone from B, email from C. Combine columns D, E, F, G into a full address formatted as street, city, state zip. Write the contact ID into column H.
You need a cleanup, dedup, and import in one pass
The lead list has duplicate emails and some rows have no name — just a phone number and address. You need deduplication, a fallback for blank names, and the full import done before morning.
In my Excel prospect sheet, remove any rows where column C appears more than once, keeping the first occurrence. For rows where column A is blank, set the name to Unknown Lead. Then create a JobNimbus contact for each remaining row using name from A, phone from B, email from C, address from D, and write the contact ID into column E or the error into column F.
One prompt handles the audit, the cleanup, and the import in sequence.
Try It
Get the 7-day free trial of SheetXAI and open the Excel workbook with your next lead list — storm damage addresses, canvassed prospects, purchased contacts — then ask it to push the whole thing into JobNimbus as contacts. See also how to export open invoices or the JobNimbus overview for Excel.