From Field delimiter, select the character that separates the values in the text file.The Open Text File dialog box displays a representation of the text file.

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. This option applies only to data in the columns, not to the column names.

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.Nonprintable characters may be embedded in text when you import text from external sources. Remove nonprintable characters and extra spaces: Select this option to remove nonprintable characters and extra spaces from text columns.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.Do not import blank rows: Select this option if you don't want to import blank rows.

For example, if you enter 999, Minitab converts all instances of 999 to the missing value symbol *. 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.

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.

Click Options to change any of the following data cleaning settings for the file that you are opening:.

To see a preview of the Minitab worksheet, click Preview Minitab worksheet.

To change the data type of a column, select a different data type from the drop-down list ( Numeric, Text, or Date Time).

If you don't want to import a column, deselect the column checkbox.

If the first row of data to import contains the column names, select Data has column names.

Specify the range of rows to import in First row to import and Last row to import.

If the Excel file contains more than one sheet, and you don't want to import a sheet, deselect Import this sheet.

The Open Excel File dialog box displays the first Excel sheet.

Minitab online