5. Merge the 7pace Timetracker export using the "TFSID" column and the TFS/VSTS query using the ID column. In the "Join Kind" dropdown, select "Left Outer":

6. Click "Ok" -> TFS/VSTS data is merged with Timetracker data.

Note: Cross-project data collection is not currently supported by Excel (as of March 31, 2017). However, it might be possible to make multiple calls to different projects, append as one big table, and then apply the merge to that consolidated table.