Bulk Import of Well Data from Excel

It is possible to import large volumes of well data from Excel files, in particular the standard well properties and select to add or update data in the wells in the project. This is a useful way of bringing in well 'metadata' from an external source.

Version: p:IGI+ 1.21.0 (December 2019)


Usage:  Project --> Import well data --> Import well information from Excel...


How to use in practice

Unlike the Excel import for sample data, the bulk import for well information requires that the file being imported conforms to a fixed structure, on the first sheet in the Excel file. We provide an example file: ExampleWellImportFile.xlsx. This file should have a simple structure and the valid headers are defined in the ValidWellPropertiesForImport.xlsx file. Any invalid headers will prevent the file being imported. Similarly you cannot have duplicate well names in the file. The headers can come in any order, and must specify the unit where this is required for a property. An example would look like:

BulkWellImportExample

Each row must include a well name in the Well Name.Well column. Possible units are listed in the ValidWellPropertiesForImport.xlsx file.

To import the Excel file, go to Project --> Import well data --> Import well information from Excel... and select the desired file from the file picker. Once you have chosen your file you will see the following dialogue:

 WellBulkImport

In this dialogue you can select various options. The top section allows you to change the file selected. The next "File overview" section gives you a summary of the number of wells in the file, and how these relate to the wells currently in your project.

The next section allows you to select what you want to import from the file. You can select to only import data from wells already present in the current project, or to import all wells in the file. In general you probably only want the additional data for the wells in your project. 

The final section allows you to select what to do with the data. You only have two options here - to retain existing data, and only update wells that currently have data in those properties, or overwrite the data for all import properties (but don't remove existing values if there is no value in the file).

Select Import to begin the import process, which will show a progress bar.


Video tutorials

None Available


Return to the main User Guide page