Import from Excel files

Overview

Data import directly from Excel provides the most flexible approach to data entry. Excel import uses smart table detection to identify data blocks and import data efficiently.

Version: 1.7.2+ (Aug 2017)


Usage:  Project --> Import data --> Import Excel data...


How to use in practice

Excel Data Import

When importing an Excel file the process can be broken into the following steps:

  • Select the file to be imported. We look for files with a .xlsx, and .xls file extension, and cannot currently import macro-enabled Excel files.
  • Stage 1 - Configure the file reader: a preview of the data is provided along with tools to define the file structure. 
  • Stage 2 - Property linking: where you can define the relation between the properties in your file and the IGI property model.
  • During the actual data import an import summary screen shows progress and any issues encountered.
Stage 1: Configure the file reader

During stage 1 the user is given the option to configure the structure of the Excel file being imported. This is shown below:

ExcelImportSettingsScreen

The software will attempt to identify several features of the Excel file, in particular:

  • The sheets within the Excel file will be listed, and the first one selected by default. The user can import data from any sheet.
  • The tables within each sheet are auto-detected, and listed. Table detection will also try and identify transposed (rows = properties, columns = samples). It is possible to turn off table detection if this does not work.
  • Metadata (data about the data in the table), for example the well name, or the source of the data can be auto-detected and then added to each row of the table.
  • The location of the header information can be defined. The user can change the row on which the properties are defined, and on which units are defined, if present. It is possible that units are contained in the property row in which case the user can specify the method used to specify the units, for example being contained in (). The user can also specify whether indicators are present for molecular data (heights, areas, etc) and also if there is information on the ion channels.
  • The extent of the data can be specified too, with the option to automatically exclude properties with no data, or duplicate data (absolutely identical information) from the linking stage.
The preview will adjust to your choices dynamically.

Finally the user can specify the default datums to be assumed for the well absolute datum (what the software should interpret as zero depth) and also the sample measured depth / true vertical depth datums. Typically these will be the well Kelly Bushing, but could be mean sea level or some other reference depth. It is important these values are defined, in order for the depth conversion and associated logic to work in the system.

Once you are happy the selections have been correctly made, selecting the Next button will take you to the linking screen.


Video tutorials

None Available


Return to the main User Guide page