Excel Import Format

( File / Import / XLS (Excel) Program )

Note the following general requirements for the Excel file to be imported into the Borehole Manager: 

• The file must be an XLS file compatible with Microsoft Excel. 
• The structure of the XLS file to be imported is the same as that generated with the Borehole Manager's File / Export / XLS (Excel) tool. 
• It can contain any/all of the worksheets that are listed below, though only the Location worksheet is required and must contain data. You do not need to include blank worksheets.
• The column order layout of the worksheets in Excel must be identical to those shown in the examples, except where noted.
• The titles of the worksheets do not need to match those shown in the examples, though you'll save a step in the import process if they do.
• Avoid blank lines in the XLS worksheets - the program will skip any data listed below a blank line.

The data types are listed below; click on a link for information about the required Excel worksheet setup. 

Tip: For a quick overall view of how to set up this Excel file, try exporting one of the sample data sets, such as that in My Documents\RockWorks15 Data\Samples to an Excel file. The exported file will display the required format of the file to be imported.

Data tables

Well Locations 
Downhole Survey (Orientation) 
Lithology Data 
Stratigraphy Data 
I-Data (Intervals)
I-Text Data
T-Data (Time Intervals)
P-Data (Points)
P-Text Data 
Color Data
Fracture Data 
Water Level Data 
Special Log Symbols 
Special Log Patterns 
Log Bitmaps
Downhole Vectors
Well Construction Data
Production Data

Types tables

Lithology Types
Stratigraphy Types
Well Construction Types
Interval Data Types
I-Text Types
Time Interval Data Types
Point Data Types
P-Text Types

Misc Project Tables

Color Fill Table
Contour Table
Point Map Range Table
3-D Point Map Range Table
XY Coordinate Table
XY Pair Table
Fault Table
Polygon Table
Bargraph Scale Table
3D IDW (Solid Modeling) Sector Table
2D IDW (Gridding) Sector Table
Synonym Table

Reference Information

Project Dimensions
Color Numbers

Back to Importing Excel Data into the Borehole Manager

RockWare home page