Open a file

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)
Open a text file (CSV, TXT, DAT)
Open a Minitab file (MPX, MPJ, MWX, MTW)
Open worksheets that are stored in a Minitab project
Open from an online repository

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.

Choose File > Open.
Browse to and select the Excel file.
Click Open.
The Open Excel File dialog box displays the first Excel sheet. Each sheet has its own tab.
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.
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.
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.

Choose File > Open.
Browse to and select the text file.
Click Open.
The Open Text File dialog box displays a representation of the text file.
Specify the range of rows to import in First row to import and Last row to import.
If the first row of data to import contains the column names, select Data has column names.
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.
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.
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.
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.
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.
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.

Choose File > Open.
From the file type drop-down list, select Minitab Worksheets.
Browse to and select the project file (MPX or MPJ), then click Open.
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.
Click OK.

Open from an online repository

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

In the web app, you can indicate whether to sign into Microsoft OneDrive®, Google Drive™, or a local file. You can open files directly from the landing page or by selecting Add/Open from the left pane when you are in Minitab.