This article contains a table that shows supported SharePoint field type conversions.
Using the Set Field Properties Task, you can convert SharePoint fields from one type to another. The table below depicts which conversions are supported. To read the table, find the row that contains the field type you are converting from. Then, find the column that contains the field type you are converting to. If a O appears in the cell at this intersection point, then the conversion is supported. Otherwise the conversion is not supported. If the conversion is not supported, you must either use a different field, or delete and recreate the field using the new type.
| Single line of text |
O |
O |
O |
O |
O |
O |
|
|
|
|
|
|
|
| Multi text |
|
O |
|
|
|
|
|
|
|
|
|
|
|
| Choice |
O |
O |
O |
O |
O |
O |
|
|
|
|
|
|
|
| Number |
O |
O |
O |
O |
O |
|
|
O |
|
|
|
|
|
| Currency |
O |
O |
O |
O |
O |
|
|
O |
|
|
|
|
|
| DateTime |
O |
O |
O |
|
|
O |
|
|
|
|
|
|
|
| Lookup |
|
|
|
|
|
|
O |
|
|
|
|
|
|
| Yes/No |
O |
O |
O |
O |
O |
|
|
O |
|
|
|
|
|
| Person or Group |
|
|
|
|
|
|
|
|
O |
|
|
|
|
| Hyperlink or Picture |
|
|
|
|
|
|
|
|
|
O |
|
|
|
| Calculated |
|
|
|
|
|
|
|
|
|
|
O |
|
|
| Rating Scale |
|
|
|
|
|
|
|
|
|
|
|
O |
|
| Page Separator |
|
|
|
|
|
|
|
|
|
|
|
|
O |
The table below lists the common name and internal type name for fields. All internal names are in the Microsoft.SharePoint namespace.
| Single line of text |
SPFieldText |
| Multiple lines of text |
SPFieldMultiLineText |
| Choice (drop-down) |
SPFieldChoice |
| Choice (checkboxes) |
SPFieldMultiChoice |
| Choice (radio buttons) |
SPFieldMultiChoice |
| Number |
SPFieldNumber |
| Currency |
SPFieldCurrency |
| Date and Time |
SPFieldDateTime |
| Lookup |
SPFieldLookup |
| Yes/No (check box) |
SPFieldBoolean |
| Person or Group |
SPFieldUser |
| Hyperlink or Picture |
SPFieldUrl |
| Calculated |
SPFieldCalculated |
| Rating Scale |
SPFieldRatingScale |
| Page Separator |
SPFieldPageSeparator |
Other field types are available in Microsoft Office SharePoint Server as well as internally to SharePoint. The SharePoint SDK has additional information about these fields, although you are unlikely to encounter some of them in most applications.