Importing Excel spreadsheets into project task lists
As you may know we have been supporting for some time now the ability to add a list of tasks from an excel spreadsheet. This is quite common in project management especially when one of the project management has created a task list when they are in offline mode. Sharing tasks that are actually embedded in an Excel spreadsheet can be counter-productive if you are using email to share your list. There is no ability to track due dates, versions and attached files(if you are already using GroupCamp Project for online projects, this will probably seem obvious to you).
To import a task list, click on the import link in the Tasks home screen, you will be presented with two options, 1) importing a task list from another project 2) importing from a spreadsheet.
Choose the spreadsheet import option then upload your spreadsheet in the relevant list (create a relevant task list if needed). You can also use the second column to add comments to tasks. The corresponding cell in column2 will be added as a comment to the task described in column 1.
If you are using the first row for headers (task names, comments), check this option for the app to know whether the first row should be considered as a task.
Supported Excel formats
The Excel upload works for .xls Excel files (Microsoft Excel 97-2004) and for .xlsx files.