Data Selector Wizard (Connect to data)

Use the Connect to data page either to confirm that you want to import all of your data or to launch the Select Columns and Select Rows pages where you can select the columns and rows to import.

You can use the Select Rows page to determine which rows of data are imported. If your data set is within the recommended size, it is fastest to close this dialog without filtering the data.

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

Select Columns    Launches the Select Columns dialog box where you can review the columns and choose which ones to import.

Select Rows    Launches the Filter Rows dialog box where you can review the rows and choose which ones to import.

The remaining pages of the wizard may be optional for you. Do one of the following:

  • Click Finish if you want the wizard to choose a unique identifier (key column) for you.

  • Click Next to choose your own unique identifier (key columm).

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.

×