Use the Data Selector to specify data types

Applies To
Excel for Microsoft 365 Excel for Microsoft 365 for Mac

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  Question mark icon  instead and the Data Selector opens, Excel needs your help to choose the right data type or find a match.

Try it!

  1. If you try to convert to a data type and a question mark   Question mark icon   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   Question mark icon    icon in the cell.

  2. 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.

  3. 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.

Want more?

Linked data types FAQ and tips

What linked data types are available in Excel?