First, you need to tick the 'Import Project Task' group to import the project task.

'Import Project Task' menu in the projects.

When you click the 'Import Task' menu, the wizard will open and it looks like below.

Success message looks like below it shows successfully imported records and also provides a list of unimported records with row number in sheet and relative details of data invalidation.

Project and user wise import wizard.

Success message looks like below it shows successfully imported records and also provides a list of unimported records with row number in sheet and relative details of data invalidation.

The following task is imported.

Default import CSV/Excel file format looks like below.

About Fields

Column	Project Model	Field Name	Description	Required
A	Tasks (project.task)	Project	You have to write a Project Name here.	Yes
B	Tasks (project.task)	Assigned To	You have to write a User Name here.	No
C	Tasks (project.task)	Task	You have to write a Task Name here.	Yes
D	Tasks (project.task)	Description	You have to write a Description here.	No
E	Tasks (project.task)	Deadline	Define the Date Deadline.	No
F	Tasks (project.task)	Planned Hours	You have to write a Planned Hours here.	No
G	Tasks (project.task)	Custom Fields	You can import custom fields from here. Please go to the "Custom Fields" tab for more details.	No

General Notes:

1) Don't remove the column from the sample sheet given, you can leave an empty column if the column is not the required type. You can see the table above for that.

2) Don't change the sample sheet column sequence.

3) Please don't use excel if you don't know the very well sheet formatting which is given in the sample sheet. Use CSV for hassle-free import without format issue. If you want to use excel and want to clear the format then please check this video.

4) Add Custom Fields or Non-Exist Standard odoo fields at the end, For adding those fields pls check the custom fields section.