Minitab Connect®  Support

Excel 365

Learn more about Minitab Connect
Use this connection to communicate between Microsoft Excel® 365 and Minitab Connect.

In This Topic

Set up a new connection

Complete the following steps to set up a connection in Minitab Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter Excel 365 and select the connector from the results.
  3. Enter a Name that identifies the connection.
  4. On the Setup tab, select Authorize Microsoft Account. Enter the Microsoft credentials for the account that you want to use. When connected, the button updates to Authorization Successful.
  5. Select Save .

After you save the connection, Connect displays options to import data into a new table. Start at step 4 of the following section for more information on importing data to create a table.

Create a table with data from a connection

Complete the following steps to import data from a file on Excel 365 and create a new table in Connect.
  1. From the Home screen, select the Add button under Tables.
  2. In Datasets, enter Excel 365 and select the connector from the results.
  3. Under Connection, select the connection that you previously set up. If you have not previously set up a connection, select New Connection and follow the steps in the previous section.
  4. On the left panel, enter a Name that identifies the table and select a Folder to save the table.
  5. Under Update Frequency, specify how often you want Connect to update the table. You can import the data one time or have Connect continuously import the data at a set time interval. Connect automatically creates a flow for your import. If you select Once, you can use the flow at a later time to automatically run the import again.
  6. Under Drive, select the connection that you just authorized. Select Next.
  7. Under Files, select the file you want to import. If your file is nested in a folder, you have to select the folder and select Next before you can select the file. If your file is nested in multiple folders, you will have to do this step for each folder.
  8. Select Save . If you go to the Prep Tool and select Run , Minitab Connect displays the imported data.
    Note

    If no data appears after you select Run, select Reset Config .

When you save the import, Connect creates a flow with the settings that you selected. For more information on how to schedule a flow and add more data processes to clean data, go to Overview of the Flow Tool .

Copyright © 2025 Minitab, LLC. All rights Reserved.