Minitab®  Support

Open a file

Learn more about
You can open Minitab files, Microsoft® Excel files, and text files directly in Minitab. Minitab can import up to 4000 columns. The number of cells that Minitab can import is limited by your available memory address space.

When you open a file, the file's contents are copied into the project. Therefore, if you change the data or graph contents within a project, you do not affect the original file.

In This Topic

Open an Excel file (XLS, XLSX, XML)

If the Excel file contains multiple sheets, you can control the import of each sheet separately.

Note

In the web app, you cannot open XLS and XML files.

  1. Choose File > Open.
  2. Browse to and select the Excel file.
  3. Click Open.
    The Open Excel File dialog box displays the first Excel sheet. Each sheet has its own tab.
  4. For each sheet, follow these steps:
    • If the Excel file contains more than one sheet, and you don't want to import a sheet, deselect Import this sheet.
    • To avoid importing unnecessary rows, enter the row to start with in First row to import.
    • If the first row of data to import contains the column names, select Data has column names.
    • If you don't want to import a column, deselect the column checkbox.
    • To change the data type of a column, select a different data type from the drop-down list (Numeric, Text, or Date Time).
    • To see a preview of the Minitab worksheet, click Preview Minitab worksheet.
  5. Click Options to change any of the following data cleaning settings for the file that you are opening:
    • What values represent missing data in your file? Minitab uses * for missing numeric and date/time values, and a blank space for missing text values. If your file does not follow these conventions, specify the missing value conventions for the Numeric columns and for the Text columns in the file. For example, if you enter 999, Minitab converts all instances of 999 to the missing value symbol *.
    • Do not import blank rows: Select this option if you don't want to import blank rows.
    • Add missing values to make the number of rows the same across all columns: Select this option to add missing values to shorter columns so that all columns have the same number of rows.
    • Remove nonprintable characters and extra spaces: Select this option to remove nonprintable characters and extra spaces from text columns. Nonprintable characters may be embedded in text when you import text from external sources. Single spaces between words will remain.
    • Correct case mismatches: Select this option to correct letter case mismatches in text columns by applying the capitalization of the first occurrence of a text value to all matching values in the column. This option applies only to data in the columns, not to the column names. For example, if the first three values in a column are Red red RED, and you select this option, the values are imported as Red Red Red.
  6. Click OK in each dialog box.
Tip

To change the default settings for importing files, choose File > Options > Open.

Open a text file (CSV, TXT, DAT)

Minitab can open plain text (ANSI or Unicode) files, which have an extension of .txt (text), .dat (data), or .csv (comma separated values). If the data that you want to use are in a file with an extension that is not in the drop-down list, try saving the data as a text file and then importing it. Most applications can create text files.

  1. Choose File > Open.
  2. Browse to and select the text file.
  3. Click Open.
    The Open Text File dialog box displays a representation of the text file.
  4. Specify the range of rows to import in First row to import and Last row to import.
  5. If the first row of data to import contains the column names, select Data has column names.
  6. From Field delimiter, select the character that separates the values in the text file. If you select Custom, enter a custom character. Minitab interprets two consecutive separators as missing data.
  7. From Text qualifier, select the character that delineates text values. Text qualifiers are necessary only if the text value includes embedded field delimiters. For example, if the field delimiter is a space, and the text value is John Smith, then the text value needs to be enclosed in text qualifiers.
  8. From Decimal separator, select the character that is used to separate the integer portion and decimal portion of a number. By default, Minitab uses the separator that is specified in your computer's regional settings.
  9. If you don't want to import a column, deselect the column checkbox.
  10. To change the data type of a column, select a different data type from the drop-down list ( Numeric, Text, or Date Time).
  11. To see a preview of the Minitab worksheet, click Preview Minitab worksheet.
  12. Click Options to change any of the following data cleaning settings for the file that you are opening:
    • What values represent missing data in your file? Minitab uses * for missing numeric and date/time values, and a blank space for missing text values. If your file does not follow these conventions, specify the missing value conventions for the Numeric columns and for the Text columns in the file. For example, if you enter 999, Minitab converts all instances of 999 to the missing value symbol *.
    • Do not import blank rows: Select this option if you don't want to import blank rows.
    • Add missing values to make the number of rows the same across all columns: Select this option to add missing values to shorter columns so that all columns have the same number of rows.
    • Remove nonprintable characters and extra spaces: Select this option to remove nonprintable characters and extra spaces from text columns. Nonprintable characters may be embedded in text when you import text from external sources. Single spaces between words will remain.
    • Correct case mismatches: Select this option to correct letter case mismatches in text columns by applying the capitalization of the first occurrence of a text value to all matching values in the column. This option applies only to data in the columns, not to the column names. For example, if the first three values in a column are Red red RED, and you select this option, the values are imported as Red Red Red.
  13. Click OK in each dialog box.
Tip

To change the default settings for importing files, choose File > Options > Open.

Open a Minitab file (MPX, MPJ, MWX, MTW)

To open a Minitab project file (MPX, MPJ) or worksheet file (MWX, MTW), choose File > Open and browse to and select the file.

Note

To open a Minitab sample data set, go to https://support.minitab.com/datasets/.

With the release of Minitab 19 and tabbed output, Minitab saves projects as MPX files and worksheets as MWX files. You cannot open MPX or MWX files in versions of Minitab that do not support tabbed output. You can open a project (MPJ) or a worksheet (MTW) from Minitab versions 16, 17, and 18.

Open worksheets that are stored in a Minitab project

To open worksheets that are stored in a Minitab project without opening the project file, complete the following steps.

  1. Choose File > Open.
  2. From the file type drop-down list, select Minitab Worksheets.
  3. Browse to and select the project file (MPX or MPJ), then click Open.
  4. Select one or more worksheets to open. You can do the following to learn more about a worksheet:
    • Click Preview to see what the worksheet will look like in Minitab.
    • If the worksheet has a description, click Description to view it.
  5. Click OK.

Open from an online repository

You can open files from Microsoft OneDrive® and Google Drive™. In the desktop app, choose File > Open from repository; in the web app, choose File > Open. Minitab will prompt you to choose either Microsoft OneDrive® or Google Drive™.

Open a Google Sheets™ file

You can open Google Sheets™ files in the Minitab web app and save them as part of your Minitab project. Any changes you make to the data in Minitab will not affect your original Google Sheets™ file.

When you import a Google Sheets™ file, the first row in each column is imported as the column's name. Minitab recognizes and imports columns of text, numeric, and date/time data.

  1. Choose File > Open > Worksheet.
  2. Select Google Drive™ and click OK.
  3. Navigate to the Google Sheets™ document that you want to import and click Select.
Copyright © 2024 Minitab, LLC. All rights Reserved.