9.1.3 Import Wizard

Summary

The Import Wizard allows you to preview your ASCII file. This is especially helpful when you are importing a file with many lines of header, and want to extract variables from both the file name and file headers for use in annotating a graph.

Minimum Origin Version Required: Origin 8.0 SR6

What you will learn

This tutorial will show you how to use the Import Wizard.

Steps

The Import Wizard allows you to import complicated ASCII files, extract variables from the import file name and header (for reuse in Origin), specify custom delimiters and date formats, or handle post-processing of your imported data using a custom LabTalk script. Another chief advantage of using the Wizard to import your data files is that you can save your custom settings to a filter that can be used repeatedly to import the same or similarly-structured files.

  1. Create a new workbook. Click File, point to Import, and then click Import Wizard to open the Import Wizard dialog. Click the browser button Tutorial Import 005.png to the right of the File box. Browse to the \Samples\Import and Export folder and open the file F1.dat. Click Next to navigate to Header Lines page.
  2. This page enables you to easily customize the worksheet headers. For example, to specify the worksheet long name, clear Auto determine header lines check box, place your cursor on the relevant line in the lower panel, and then click the button next to Long Names.
    Tutorial Import 006.png
    Similarly, specify the Unit line and select <None> for Comments.
  3. Click Next to navigate to File Name Options page. Make sure the worksheet with file name box is checked to rename worksheet by imported file name.
  4. Click Next to go to the Data Columns page. Select (XYE) from the Column Designations drop-down menu and click Apply.
    Tutorial Import 007.png
  5. Click Next twice to go to the Save Filters page. To use these settings again, you can save this import procedure as a filter. Select the Save filter check box and type a filter name in the Filter file name text box (MyFilter in this example).
    Tutorial Import 009.png

    Click Finish to import the data.
  6. Open Windows Explorer and browse to <Origin installation folder>\Samples\Import and Export\. Locate the file F2.dat, drag and drop it to Origin workspace. The Select Filter dialog will open asking you to select a filter.
    Tutorial Import 010.png
    Select MyFilter filter just saved. It will be used to import the file.