Import tasks from spreadsheets

I need these 120 rows turned into actionable tasks for the product launch team. Import the spreadsheet with columns for task name, assignee, due date, description, and priority. Before you finish, scan for missing assignees, impossible due dates (weekends or past dates), and duplicate task names; flag any rows that fail and stop the import so I can fix them. Then assign tasks to Maya, Luis, and Anika as listed.

Before I bring this spreadsheet into the project, make it review-ready so stakeholders can approve quickly. Surface the 10 highest-priority tasks at the top, group tasks by owner, highlight any rows missing a due date or assignee, and call out tasks with the same name but different descriptions. Create a clean import file that will map columns to task fields exactly as: Task Name, Description, Assignee, Due Date, Priority.

I just ran the import for the launch tasks and about 60 rows came in without assignees even though the spreadsheet has names. Maya, who coordinates resources, will be furious if work slips. I don’t know if it’s a column mismatch, typo in the names, or the assignee list in the workspace missing people. What’s the most likely cause, exactly how do I check the mapping and workspace roster, and what’s the fastest safe fix so Maya sees assigned work today?

Every time I import spreadsheets for campaigns I spend two hours fixing assignees, dates, and duplicates. It costs priority review time and irritates owners. I want a habit that prevents this cleanup: what checks or a lightweight pre-import checklist should I make standard so imports are accurate first time and the team stops losing trust after every upload?