Complete the following steps to open a test limits text file in Microsoft Excel.

  1. In Excel, select Open. Select All Files in the drop-down menu of file types.
  2. Select the test limits file you want to open and click the Open button.
  3. In the Text Import Wizard, select Delimited in the Original data type option and click Next.
  4. Select Tab in the Delimiters option and click Next.
  5. Select General in the Column data format option and click Finish.

Alternatively, you can drag and drop a test limits text file into Excel to open the file.

When you save a modified test limits file that you opened or edited in Excel, Excel might return a message that the Excel file contains features that are not compatible with the tab-delimited text format. Click Yes in the prompt to save the workbook in text format. The Import/Export Test Limits tool is unable to parse any additional formatting information Excel adds to the file.

Note
  • If a field name begins with a mathematical sign, Microsoft Excel might interpret the contents of the cell as a formula and return an error for the cell. To work around this issue, format the cell in Excel as text data.
  • In some cases when a limit has a large number of digits, Microsoft Excel might truncate the decimal portion of the number. To work around this issue, format the columns that contain the limit numbers in Excel as text data.