Data Selector Wizard (Select Columns)

You can use the Select Columns page to determine which columns of data are imported. If your data set is within the recommended size, it is fastest to close this dialog without clearing any of the column check boxes. The check boxes are all checked by default.

Note: Your data set is above the recommended size if it meets any of the following criteria:

  • The number of rows exceeds 1000

  • The number of columns exceeds 100

  • The number of rows multiplied by the number of columns exceeds 20,000

To select a column, check the box next to the column name     This list contains all of the columns in your data source. Column names are listed in the left column and sample values in the right. Columns that are not viewable data types, such as binary data types, are dimmed.

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.