This is part 1 of the series about importing Work Items into TFS 2010 using the Excel Add-in. For more information about the Excel Add-in for TFS, check out http://msdn.microsoft.com/en-us/library/dd286627.aspx.
Using Excel is a very convenient way to import Work Items into TFS. It’s fast and flexible and most people know how to use it! There are however some pitfalls one needs to consider. This series will describe some of them.
When configuring a Work Item Type, a choice can be made between a “Plain Text” field and an “Html” field. The difference is clear; Plain Text can only contain text whereas the “Html” field can contain markup as well.
Having the possibility to add markup to your text is of course a nice feature. There is however a downside to this when cooperating with Excel; You cannot edit Html type fields. It’s only possible to initially fill them when creating the work item in Excel. So be conscious when using Html fields!