Import Tie Points from Excel

Overview

It is possible to import large volumes of borehole (previously well) tie-point data or deviation survey information from Excel files. This provides a route for the software to calculate equivalent TVD (true vertical depth) values for project samples.

The import well data option in the project menu, available in version 2.5+, has been updated to import borehole data and associated site information. This will allow users to upload tie points or a deviation survey for a borehole. As with earlier versions of the software, the bulk import of tie-point data/deviation survey requires the import file to conform to a fixed structure. An example file is attached here: Borehole_TiePoint_ImportV3

Version: 3.0 (March 2026)

Usage: Project --> Import site/borehole data...

How to use in practice

Unlike the Excel import for sample data, the import for borehole tie-point/deviation survey data requires that the import file conform to a fixed structure on the first sheet of the Excel file (example file above). The property headers in red text are required to be present, and each row must include a borehole name in the Name.Borehole column for the file to be valid.

The Excel file must have exactly those property headers in the order shown above; the only optional element is the unit provided in ().

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

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 details any data merge actions that would take place upon import. This is where the values you are importing would overwrite property values already present in your project.

The next section allows you to define the depth units and datum used for the depths listed in the Excel file. Most often, depth will be given in feet or meters relative to the Drillers Reference. However, it is possible for you to set different units and datums if needed.

The next section lets you select what 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 tie points for the wells in your project. If there are a large number of wells in the file, be aware that importing them all can take a little time, as all the well calculations may be triggered (and the well artefacts created).

The final section allows you to select what to do with the data. Note: In version 3.0, you can only import top information for boreholes that are already present in the project.

After importing borehole tie-point or deviation survey information, sample-level TVD properties (in the .Sample group) will be automatically populated from the imported information if all appropriate datums are present for samples/site/borehole in question.

- Sample depth: MD datum.Sample
- TVD depth: TVD datum.Sample
- Site: Abs datum.Site
- Borehole: DR height.Borehole

Note: After importing borehole tie-point or deviation survey information, you cannot review or edit the tops in the project. Please open the Sample summary page artefact to see whether you have now calculated TVD values, or open a Depth plot and edit the depth type to see if you can shift the data to TVD levels.