6.2 Importing Third Party FilesImport-ThirdPartyFormats
Methods of Third-party File Import
Origin can import data from a wide variety of third-party file formats. Many import routines are installed with the product. Others are available as free downloads.
There are three places in Origin where you will find third-party import routines:
Main Menu: Data > Connect to File
Data Connectors are Origin's newest data import technology. A number of pre-installed Connectors are listed under Data: Connect to File. Additionally, an Add New... sub-menu opens the App Center and searches for additional Data Connectors that you can download free-of-charge. Note that installed Data Connector Apps are also accessible from the Connectors tab of the Apps Gallery, normally docked to the right-side of the Origin workspace.
Main Menu: Data > Import from File
Common third-party formats are available from this menu. These are older, but still-supported import routines that typically use (a) import dialog settings saved to the sheet or (b) an Origin Import Filter (*.oif) to parse data in the import file. If you are not finding an Import from File format, you can check the Add/Remove File Types... sub menu. This opens the Import Menu Customization dialog listing all supported file formats. Use this dialog to show or hide formats.
| If you do not see an Add/Remove File Types... menu item, choose Preferences: Import Filters Manager, then click Customize Menu and check the Show "Add/Remove File Types..." menu box. This will restore Data: Import from File: Add/Remove...
|
Apps Gallery
There may be additional Apps available for importing third-party file formats. Press F10 to open the App Center, click on the Search tab on the left, and then enter the word import into the edit box and press Enter. Installed Apps will have a green check mark beside them. Those not installed will have a black download icon beside them. You can then select which import Apps you want to download and install. Installed Apps will appear on one or more of the Apps Gallery tabs, docked to the right-side of your Origin workspace.
Supported File Types
The following table lists various third-party formats supported by Origin. This includes the older, *.oif-supported import routines as well as the newest Connectors. Those not listed in the default menu are linked to instructions for adding the import routine.
Name
|
File Type (Extension)
|
Latest Supported Version
|
How to Install
|
How to Use
|
Agilent mass spec
|
MS
|
|
Download...
|
Apps Gallery
|
Binary 2D Array
|
IMG,B2B
|
|
Add to Menu...
|
Data > Import from File
|
Bio-Logic MPR
|
MPR
|
|
Download...
|
Apps Gallery
|
BRUKER
|
BRUKER OPUS, RAW4.00 (XRD)
|
OPUS7.5
|
Add to Menu...
|
Data > Import from File
|
Bruker BES3T
|
DTA
|
|
Download...
|
Apps Gallery
|
C3D
|
C3D
|
|
Download...
|
Apps Gallery
|
Chem Data
|
SDF,SDF.GZ,MOL,CDX
|
|
Download...
|
Apps Gallery
|
Comma Delimited
|
CSV
|
Microsoft Office Excel 2021
|
Pre-installed
|
Data > Import from File Data > Connect to File or Apps Gallery
|
Common Data Format
|
CDF
|
File version: 3.9.0
|
Pre-installed
|
Data > Import from File
|
Data Translation
|
DCF, HPF
|
DCF:1.0 HPF 1.2: Internal OriginC code support, no version specified.
|
Add to Menu...
|
Data > Import from File
|
DICOM
|
DICOM images
|
|
Download...
|
Apps Gallery
|
EarthProbe
|
EPA
|
Only support EPA file import
|
Add to Menu...
|
Data > Import from File
|
EDF
|
EDF,BDF,REC,HYP
|
|
Add to Menu...
|
Data > Import from File
|
ETAS INCA MDF
|
DAT, MDF
|
INCA5.4(File version:3.0)
|
Pre-installed
|
Data > Import from File
|
European Data Format
|
EDF,EDF+,BDF,REC,HYP
|
Internal OriginC code support, no version specified.
|
Pre-installed
|
Data > Import from File
|
Excel
|
XLS, XLSX, XLSM
|
Microsoft Office Excel 2021
|
Pre-installed
|
Data > Connect to File
See Also: Importing from Excel Chapter
|
Famos
|
DAT, RAW
|
imc2 format imc3 format
|
Pre-installed
|
Data > Import from File
|
Flow Cytometry Standard
|
FCS
|
|
Download...
|
Apps Gallery
|
FITS
|
FIT,FITS
|
|
Download...
|
Apps Gallery
|
Gamry Voltammetry
|
XLSX,DTA
|
|
Download...
|
Apps Gallery
|
Google Map
|
Google Map images
|
|
Download...
|
Apps Gallery
|
HBM Catman
|
BIN
|
Catman 5.4.2
|
Download...
|
Data > Connect to File or Apps Gallery
|
Heka
|
DAT
|
PATCHMASTER 2x90.3 (File version:9)
|
Add to Menu...
|
Data > Import from File
|
Hierarchical Data Format
|
H5,HE5,HDF5
|
HDF (File version:1.14.3)
|
Pre-installed
|
Data > Import from File
Data > Connect to File
Another relevant App:
HDF5 Browser
|
HTML
|
HTM,HTML
|
|
Pre-installed
|
Data > Connect to File or Apps Gallery
|
IgorPro
|
PXP, IBW
|
Igor Pro 8
|
Pre-installed
|
Data > Import from File
|
JCAMP-DX
|
DX, DX1, JDX, JCM
|
File version: 6
|
Add to Menu...
|
Data > Import from File
|
JSON
|
JSON
|
|
Pre-installed
|
Data > Connect to File or Apps Gallery
|
KaleidaGraph
|
QDA
|
Internal OriginC code support, no version specified.
|
Add to Menu...
|
Data > Import from File
|
LeCroy
|
trc
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
LSM
|
LSM
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
MATLAB
|
Mat
|
Matlab 2019b (File version: v7.3)
|
Pre-installed
|
Data > Import from File Data > Connect to File or Apps Gallery
|
MDF4
|
MDF4
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
Minitab
|
MTW, MPJ
|
Minitab 22
|
Add to Menu...
Download...
|
Data > Import from File
Data > Connect to File or Apps Gallery
|
MZXML
|
mzData, mzXML, mzML, imzML
|
mzXML3.0 mzML:1.1.0 mzData:1.05 imzML:1.1.0
|
Add to Menu...
|
Data > Import from File
|
N42
|
N42 (XML)
|
ANSI/IEEE N42.42
|
Download...
|
Data > Connect to File or Apps Gallery
|
NanoScope
|
NanoScope
|
|
Download...
|
Apps Gallery
|
NetCDF
|
NC, NC4
|
Version: 4.9.2 (no DAP support)
|
Pre-installed
|
Data > Import from File
Data > Connect to File
|
Nicolet WFT
|
WFT
|
|
Download...
|
Apps Gallery
|
NI DIAdem
|
DAT
|
DIAdem 2023
|
Pre-installed
|
Data > Import from File
|
NI TDMS
|
TDM, TDMS
|
|
Pre-installed
Download...
|
Data > Import from File
Data > Connect to File or Apps Gallery
|
NMR
|
fid,1r, 1i, 2rr, 2ii, 2ri, 2ir, 3rr, etc.
|
|
Download...
|
Apps Gallery
|
pCLAMP
|
(ABF, DAT, AB?)
|
pClamp 11 (ABF 2)
|
Pre-installed
|
Data > Import from File
|
PDF
|
PDF
|
|
Download...
|
Apps Gallery
|
PLEXON
|
PL2
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
PLEXON's PLX
|
PLX
|
|
Download...
|
Apps Gallery
|
PNRF
|
PNRF
|
|
Download...
|
Apps Gallery
|
Princeton Instruments
|
SPE
|
SPE 3.0
|
Pre-installed
|
Data > Import from File
|
Prism
|
PZFX, XML
|
GraphPad Prism 8
|
Pre-installed
|
Data > Import from File
|
SAS
|
SAS7BDAT, SD2
|
SAS 9.4
|
Add to Menu...
|
Data > Import from File
|
Shapefile
|
SHP
|
|
Pre-installed
|
Data > Connect to File or Apps Gallery
|
SigmaPlot
|
JNB
|
SigmaPlot 12.5
|
Pre-installed
|
Data > Import from File
|
SPSS
|
SAV
|
SPSS 28
|
Optional install
|
Data > Import from File
|
Somat SIE
|
SIE
|
InField 2.5 (File version:1.0)
|
Add to Menu...
|
Data > Import from File
|
Sound
|
WAV
|
8/16/24/32/64-bit (PCM format, incl. 32/64-bit float)
|
Pre-installed
|
Data > Import from File
|
Stiegele MDF
|
MDF
|
|
Download...
|
Apps Gallery
|
Tektronix ISF
|
ISF
|
|
Add to Menu...
|
Data > Import from File
|
Tektronix WFM
|
wfm
|
|
Download...
|
Apps Gallery
|
Thermo
|
SPC, CGM
|
File version: new Galactic SPC file
|
Pre-installed
|
Data > Import from File
|
Touchstone
|
s1p,s2p,s3p,s4p,s5p,s6p,s7p,s8p,s9p,ts
|
Touchstone version 2.0
|
Download...
|
Data > Connect to File or Apps Gallery
|
Universal File
|
UNV,UFF,UF
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
VAMAS
|
VMS
|
|
Download...
|
Apps Gallery
|
Word
|
docx
|
Microsoft Office Word 2021
|
Download...
|
Data > Connect to File or Apps Gallery
|
XML
|
XML
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
XPORT
|
XPT
|
|
Download...
|
Data > Connect to File or Apps Gallery
|
Yokogawa WDF
|
WDF
|
DL350, DL850, DL850E,
XVWDF, SL1000, DLM2000,
DLM3000, DLM4000, DLM6000, PX8000
|
Download...
|
Data > Connect to File or Apps Gallery
|
Zygo MetroPro
|
DAT
|
binary data file
|
Download...
|
Data > Connect to File or Apps Gallery
|
For more specific information on importing supported third party files by X-Functions(Tools under the Data > Import from File menu), see the X-Function Help file (click Help, and then click X-Functions, or press F1 while the dialog box is open).
For direct access to the documentation from the Command Window, type the following at the command prompt:
help X-FunctionName
If you have a third party file that isn't currently supported, you may be able to develop your own import routine using the Origin Import Wizard (requires some Origin C coding ability). For more information, see "Importing chapter" in Origin C Guide.
File Metadata
When you import a file, the file's date, name, and path are saved to the target workbook. Some third-party files contain additional metadata that is saved upon file import. For example, Origin will save time format information from an NI DIAdem .DAT file.
You can view the metadata associated with an imported file in the following ways:
- View the information in the Workbook Organizer. To open the Organizer, right-click the workbook title bar and click Show Organizer in the menu.
- View the information in the Insert Info Variables dialog box. Metadata associated with a given workbook may be inserted into a text object in that book, or into plots of workbook data, with a shortcut key combination. For more information see "Inserting Variables Extracted from Imported ASCII Files into Text Labels".
- For basic information, enter the following script command in the Command Window:
page.info = <ENTER>
- For more complete information, enter the following script command in the Command Window:
impinfo <ENTER>
- View information in the Column Properties dialog box, User Tree tab. To open the Properties dialog box, double-click the column heading, then click the User Tree tab. Origin stores file information here but the tree can be edited by the user.
With some files (e.g., .WAV and Thermo .SPC/.CGM), parameters read from the file headers are added to the target worksheet for graphing or analysis purposes. For instance, the sampling interval of a .WAV file is written to the header row of the target worksheet. When you plot the imported data, the sampling interval is used to set the X axis increment.
Import Mode
For most supported third party files, you can set the import range using controls in the import dialog boxes. Import Mode options are:
- Replace Existing Data: The data that exists in the target window will be cleared on data import.
- Start New Rows: Append new rows, as needed.
- Start New Columns: Append new columns, as needed.
- Start New Sheets: Create a new sheet for each imported file.
- Start New Books: Create a new book for each imported file.
Notes:
- Some X-Function based third party import routines do not support these Import Modes.
- For Princeton Instruments SPE data files, the target window type as chosen by Origin will depend upon the dimensions of the data. If the data files are one-dimensional, they will be imported into a workbook. Otherwise a matrixbook will be used as a target window (even if a workbook is the active window).
|
|