it is easy to export tfs data to excel, but i wonder how to get the data from excel imported to capacity of tfs scrum 2013. by capacity, i mean the team member, capacity per day something like this.
Thanks!
It is not possible at all.
You can use the API to access this information through the TeamSettingsConfigurationService as per TFS 11 2012 API Questions : query capacity and days off