Importing Datasets

Follow this procedure to import data for a dataset from a file:

  1. Select Project > Datasets. The Datasets dialog box appears.

  2. Click Import.
  3. In the file browser window that appears, choose data from the following file types:

    .mdx, .mda

    Twin Builder Characteristic format

    .xls, .xlsx

    Microsoft Excel

    .txt

    text file

    .csv

    Comma-separated value

    .out

    Maxwell SPICE (read-only - reads data inside the KW_DATA section)

    .cfg

    Comtrade (IEEE Std C37-111-1999)

    .dat

    TEK Oscilloscope

    .tab

    tab delimited data files


    1. If you select a file type other than .xls, .xlsx, .txt, .dat, .out, or .csv the data is imported immediately into the Add Dataset dialog box.
      Note:

      Importing an .xls or .xlsx file requires Microsoft Excel to be available.

    2. Select an .xls or .xlsx file containing multiple sheets to open a Table Properties dialog box where you can choose the desired sheet from a drop-down list. Otherwise, selecting an .xls or .xlsx file imports the data immediately into the Add Dataset dialog box.
      Note:
      • The x-coordinate values for successive data points must increase within ten significant digits. Non-numeric entries are assigned a value of zero.
      • The first row of data is assumed to contain column headings and is ignored.
    3. Selecting a .txt, .dat, .out, or .csv file opens an Import dialog box in which you can specify settings for reading the data in the file for import. Choose the Separator and Decimal Symbol, as well as the line at which to begin the import. Select the channels to import with the check boxes in the Select Channels combo box. The dialog box shows both the original text and the text as it would appear when imported based on the current import settings. For more information, see Import Data from Generic Text Files.
  4. When satisfied with the import settings, click OK to import the data.

    Imported datasets take the name of the imported file. If a dataset of the same name already exists, a number will be appended to the end of the new dataset (for example, a duplicate 'dataset' becomes 'dataset1').

  5. After importing the data, you can modify it manually (see Editing Datasets).

    Note:

    You can also import a dataset in the Add Dataset and Edit Dataset windows.

Related Topics 

Adding Datasets

Editing Datasets

Cloning Datasets

Exporting Datasets

Removing Datasets

Using SheetScan

File Formats