Skip to content
GeoEQ · Geotechnical software research lab · University of Utah

Documentation / Data in and out

Import boring log data from Excel or CSV in GeoEQ SPT Logs

Applies to 1.0 and later · current 1.2 2 min read

Short answer

Right-click a project in GeoEQ SPT Logs and choose Import borehole, then pick an .xls, .xlsx or .csv file. The office BH-xx template imports in one click. Any other table opens the Assign columns window, where you correct the guessed mapping and press OK.

.xls .xlsx .csv
file types the import reads
1 click
to import the office BH-xx template
The Assign columns window listing file columns such as DEPTH (m), 1st, 2nd, 3rd, Sample, Dec, F % and MC % with their sample values and the borelog field each is assigned to.

How do I import an Excel or CSV file?

  1. Right-click the project in the explorer and choose Import borehole. To bring data into a borehole you already have, right-click it and choose Import data, or use the Import Excel button in its borelog tab.
  2. Select an .xls, .xlsx or .csv file. CSV files can use commas, semicolons or tabs.
  3. For the office template, the borehole appears at once. For any other file, the Assign columns window opens.

The new borehole takes the file’s name, which you can change afterwards with Rename.

What is the office BH-xx template?

It is the office Excel workbook with a header block, an SPT input sheet and a borelog sheet. Importing it creates the borehole with its header, samples, blow counts and strata in one click, with no mapping step.

How does column mapping work?

For any other Excel or CSV table, the Assign columns window lists each column of the file with sample values and a guessed target field. The guess works from the column name and the values, so “Dec” is assigned to Strata description and “SPT N” to the N-value.

Correct anything that was guessed wrongly using the drop-down beside it, set unwanted columns to ignore, and press OK. The rows are inserted into the new borehole.

Target fieldGoes to
DepthSPT & samples
15 cm: 1st, 2nd, 3rdSPT & samples, blow counts
SPT N-valueSPT & samples, direct N
Sample ID, Sample type (D/UD)SPT & samples
Fines, LL, PI, qu, Moisture contentSPT & samples, lab columns
Strata: description, to depth, soil type (C/S/M/G/F/O/R)Strata

What happens to the data?

  • A file with only an N column, and no blow counts, works. The N goes into the direct-N column.
  • Consecutive rows with the same description merge into one stratum automatically.
  • Units are not converted. Imperial and Metric change labels only, so enter or import values in the unit the project uses.

Afterwards, open the borehole and review the SPT & samples and Strata tabs, then complete the Header tab, which the file may not have filled in.

Common problems

A column was guessed wrongly. Change its target in the Assign columns window before pressing OK.

Strata look merged. Identical consecutive descriptions become one layer. Make sure different soils do not share exactly the same text.

Only a few rows. Copy and paste from Excel straight into the table instead. The input tables accept Excel-style paste.

For a walkthrough, follow the tutorial on importing boring log data from Excel. With version 1.3 you can also ask an AI assistant to import a workbook of boreholes through Connect AI.

Step-by-step tutorials

Frequently asked questions

Can I import an Excel file into GeoEQ SPT Logs?

Yes. Right-click the project, choose Import borehole and select an .xls, .xlsx or .csv file. The office BH-xx template imports directly. Any other table opens the Assign columns window so you can match its columns to the borelog fields.

What if my file has only N-values and no blow counts?

It works. When the file has only an N column, the values go into the direct-N column of the SPT & samples tab.

Are units converted when I import?

No. Units change labels only, and values are never converted. Make sure the numbers in the file are in the unit the project uses.

What happens if I cancel the Assign columns window?

The empty borehole that was created for the import is removed again, so cancelling leaves the project as it was.