Follow
Export Task List to Excel Showing Child Tasks Indented

Overview

By default, when exporting a task list to Excel, the indentation is removed. The following syntax will retain the parent-child relationship of the project when exported.

Details

  1. Edit your view and for the Name column, switch it to text mode
  2. Your view should look like this:
  3. valuefield=name
    querysort=name
    valueformat=HTML
    displayname=
    linkedname=direct
    namekey=name
  4. Replace valuefield=name with the following valueexpression syntax: 

valueexpression=IF({indent}<1,{name},IF({indent}<2,CONCAT(" - ",{name}),IF({indent}<3,CONCAT(" - - ",{name}),IF({indent}<4,CONCAT(" - - - ",{name}),CONCAT(" - - - - ",{name})))))

5.  Save your view and you can now export to excel and see your parent & children tasks