The Scenario
The kick-off call is in four hours, and your project plan isn't in Magnetic yet.
You built the plan in Excel — 120 rows, each with a task name, assignee email, due date, and linked opportunity ID. The client signed last Thursday. The PM who was going to handle the Magnetic setup is out sick. You're looking at the workbook, doing the math: 120 tasks, click-through form, probably 8 clicks per task. That's not something you can finish before the call.
The bad version:
- You open Magnetic's task creation panel and start entering row 1 by hand, copying from the workbook and pasting into each field one at a time
- You get through 15 tasks in 25 minutes, realize the date format you're pasting doesn't match what Magnetic expects, and have to go back and fix the ones you already entered
- You hit row 40 and accept you're not finishing this before the call — the client will see an empty project board at kick-off
Leadership will be on that call. Showing up with an unpopulated project board after signing is not the first impression your agency needs.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that runs inside your Excel workbook. It reads the worksheet, understands the structure, and through its Magnetic integration it can create tasks, push records, and write results back — without you touching the Magnetic UI at all.
Open the SheetXAI sidebar in your project plan workbook and ask:
Excel 'Task Import' has task_name, description, and user_id for 120 rows — bulk-create all tasks in Magnetic
What You Get
- A Magnetic task created for each of the 120 rows, with the fields mapped from your workbook columns
- Any rows where Magnetic returned an error flagged row by row rather than silently skipped
- The full operation completes before the call
What If the Data Is Not Quite Ready
The assignee column has names instead of user IDs
Column C in worksheet 'Task Import' has assignee names — look up each name in worksheet 'Team Directory' column A and return the matching Magnetic user_id from column B, write results into column C, then create Magnetic tasks for all rows
Some due dates are in MM/DD/YYYY and others are text like "end of May"
Normalize all values in column D of worksheet 'Task Import' to ISO date format YYYY-MM-DD — convert text dates relative to today — then create Magnetic tasks for all rows
The opportunity IDs need to be looked up from a second worksheet
Column D of 'Task Import' has opportunity names, not IDs — look up each name in worksheet 'Opportunities' column B and return the Magnetic opportunity_id from column A, then create tasks with the correct IDs
Clean up, confirm, and create — all in one
In worksheet 'Task Import': normalize dates in column C to YYYY-MM-DD, look up user IDs from worksheet 'Team Directory', skip any rows where task_name is blank, create a Magnetic task for each remaining row, and write the returned task_id into column E
The cleanup and the import run in a single prompt — no prep-then-import two-step.
Try It
Get the 7-day free trial of SheetXAI and open your project plan workbook — the one with 120 task rows your team built before the client signed — then ask it to push everything into Magnetic before the kick-off call. After you've seen this work, take a look at pushing opportunities into Magnetic from a pipeline workbook or head back to the Magnetic integration overview.