To convert to a data type, Excel looks for a match between the cell values and the database provider. If there's a match, you'll see a data type icon in the cell to indicate it was converted successfully. If you see a
instead and the Data Selector opens, Excel needs your help to choose the right data type or find a match.
Try it!
If you try to convert to a data type and a question mark
appears instead of the data type icon in the cell, you need to refine or match the result in the Data Selector. If the Data Selector doesn't automatically open, you can open it by selecting the question mark
icon in the cell.In the Data Selector, review the results and select the one you want. Then the Data Selector will go to the next result that needs identifying.
Note
Need help specifying or getting the correct results? See the section for refining your results below.
When all cell values are linked to a data type, the Data Selector will close.
Common questions about the Data Selector
How do I refine my results to get the correct data type?
Try any of these steps to get the correct data type result:
Select the cell you want to change > go to Data > select the appropriate data type in the Data Types gallery in the ribbon.
Specify terms if possible, either in the Data Selector or by typing additional details in the cell.
Note
If your text was converted to the wrong data type, you can also right-click the cell > Data Types > Change... > select a different result or refine your term in the Data Selector.
What if there are no results that match what I'm looking for?
If the Data Selector is open but there are no results, try these steps:
- Check that your text is spelled correctly and that each unique term is in its own cell.
- Try using similar terms and alternatives. For example, entering "MSFT" instead of "Microsoft".
- Specify terms if possible either in the Data Selector or by typing additional details in the cell.
If you still can't find any results, you can check what linked data types are available to see if we support this subject yet. For the term that has no matching result, you can either manually add data in or delete the row.
What if there are multiple results with the same name?
This might happen with certain data types. You can:
- Refine your results by entering a more specific term in the text box of the Data Selector.
- Select the image of a result to open the detail view, then use that information to help you make an informed choice.