The Scenario
It's the last week before Q2 starts. You're an executive assistant managing the calendar for a leadership team, and you have an Excel workbook with 40 client check-in meetings: subject lines, start times, end times, and attendee email addresses. All 40 need to be in Outlook before Monday. You've been clicking "New Event" for 25 minutes and you're on meeting seven.
The bad version:
- Open Outlook calendar, click New Event, type the subject, set the start and end times, add attendees one by one from the workbook, save
- Repeat 33 more times
- Discover on meeting 31 that you misread a start time two hours ago and three meetings now have the wrong time — go back and fix them
Nobody assigned you this work because they thought it would take four hours. They assigned it because someone has to do it — and right now that someone is you, doing it one meeting at a time.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads each row and creates the corresponding Outlook calendar event — all 40 in one pass.
Create an Outlook calendar event for every row in this table using the Subject, StartDateTime, EndDateTime, and Attendees columns — create all 40 at once
What You Get
- One Outlook calendar event created per row, with the subject, times, and attendee invites populated from your workbook columns
- Attendees receive calendar invitations through Outlook automatically
- Rows where StartDateTime is blank are skipped and flagged
- A summary in the sidebar confirming how many events were created and noting any failures
What If the Data Is Not Quite Ready
The start and end times are in local time but Outlook needs them in a specific timezone
Create an Outlook calendar event for every row in this table — treat all times in the StartDateTime and EndDateTime columns as Eastern time, convert to UTC for the API, and use the Subject and Attendees columns for the event details
Some rows are missing attendees and should still be created as solo blocks
Create an Outlook calendar event for every row in this table using Subject, StartDateTime, and EndDateTime — if the Attendees column is blank, create the event with no invitees rather than skipping the row
The location column needs to be included as an online meeting link
Create an Outlook calendar event for every row, using Subject, StartDateTime, EndDateTime, and Attendees columns — set the location field from column D and mark each event as an online meeting using the Teams link in column E
Deduplicate by subject and time, then create all remaining events with full attendee invites
Check this table for duplicate rows where Subject and StartDateTime match, keep only the first occurrence of each, then create one Outlook calendar event per remaining row using Subject, StartDateTime, EndDateTime, and Attendees — invite all attendees listed in the Attendees column
One prompt handles the deduplication and the creation together.
Try It
Get the 7-day free trial of SheetXAI and open the workbook with your meeting schedule, then ask SheetXAI to create the calendar events in Outlook. See also: Bulk cancel or update Outlook calendar events and the Outlook hub overview.