The Scenario
You ran a career fair booth yesterday. Two hundred candidates stopped by. You scanned badges, collected business cards, and ended up with a sheet of 200 rows: full name, email, phone, company. You need all 200 in your Outlook contacts before you start making calls tomorrow morning.
The bad version:
- Open Outlook, click New Contact, type the first name, last name, email, phone, and company from the sheet, save
- Open the next contact, repeat
- Get through 30 contacts in 45 minutes, realize you have 170 left, and accept that this is now your entire afternoon
Nothing about this is skilled work. It's transcription. The data is already structured, the destination fields are known — the only missing piece is something that will do the actual moving.
The Easy Way: One Prompt in SheetXAI
SheetXAI reads each row in your sheet and creates the corresponding Outlook contact. All 200 at once.
Create an Outlook contact for every row in this sheet using the Name, Email, Phone, and Company columns — add all 200 contacts at once
What You Get
- One Outlook contact created per row, with name, email, phone, and company populated from your sheet
- Rows where the Email column is blank are skipped and noted
- Full name is parsed into first and last name automatically
- A sidebar summary showing how many contacts were created and flagging any rows that failed
What If the Data Is Not Quite Ready
The name column has the full name as one string but Outlook wants first and last separately
Create an Outlook contact for every row in this sheet — split the Name column into first name and last name at the first space, then map Email, Phone, and Company to the corresponding Outlook fields
Some rows have job titles and LinkedIn URLs you want to include
Import all entries from this sheet into my Outlook contacts folder, mapping Name to display name, Email to primary email, Phone to mobile, Company to company, JobTitle to job title, and LinkedIn to business homepage
You want to skip contacts that already exist in Outlook by email address
Create an Outlook contact for every row in this sheet where the Email column value does not already exist in my Outlook contacts — skip duplicates rather than overwriting them, and write "Skipped — duplicate" in column F for those rows
Deduplicate the sheet by email, clean up name formatting, and import all remaining contacts
Remove duplicate email addresses in column B keeping the first row, title-case column A, then create an Outlook contact for every remaining row using Name, Email, Phone, Company, and JobTitle columns
One prompt handles the deduplication, the formatting fix, and the import.
Try It
Get the 7-day free trial of SheetXAI and open your candidate or contact sheet, then tell SheetXAI to create the Outlook contacts from it. See also: Export and deduplicate Outlook contacts and the Outlook hub overview.