Import Excel Data into Multiple Datasheets

The Data Editor's File | Import | Excel (Multi-Sheet) import tool reads data from multiple worksheets in a single Excel file into one or more new LogPlot LDAT8 files.

You can import data for more than one borehole from a single Excel file. The required file structure is different for single-well versus multiple-well files.

The format of the Excel data to be imported must be the same as that produced by the export-to-Excel program (File | Export | Excel). The worksheet titles in Excel must be identical. See Excel File Format for details. There must be no blank rows within the Excel worksheets. Otherwise, the import program will stop reading that particular worksheet as soon as a blank row is encountered.

! We HIGHLY recommend that you create a sample file in LogPlot that contains a representation of the data you'll be importing, and export that data to Excel, either with data or without - as a template - in order to generate the proper worksheets. Use the exported Excel spreadsheet as the guide for formatting the data to be imported into LogPlot.

If you wish to import data from Excel into a single datasheet, such as Point Data, in a single LogPlot data file, use the File | Import | Excel menu option.

 

How to…

Import Data from an Excel File into Multiple LogPlot Datasheets

  1. Click in any open Data Editor window. If none is present, create a new Data Editor window. Note that new LogPlot data files will be created for the new data.
  2. Select the File | Import | Excel (Multi-Sheet) menu option.
  3. Browse for the desired Excel spreadsheet to be imported. These files typically have an .XLSX file name extension. Click on the file's name to select it, and click OK to continue.

    LogPlot will read the contents of the Excel file and generate LogPlot datasheets for each worksheet, where the data will be listed. It will be able to determine, based on the structure of the Excel file, whether you are importing data for a single well or for multiple wells; if the latter then multiple data files will be created. 

    ! The data is stored in memory only at this point.

  4. Choose File | Save to save each borehole's data as a LogPlot LDAT8 file. (See Saving Data Files.)

     

Here is a listing of the comparable data types:

Excel Worksheet LogPlot datasheet
SETUPGRD BH Info
BMP_name Bitmap
CRV_name Point Data
EDT_name Edit Text
FIL_name Fillbar
FRA_name Fractures
INB_name Interbed
INT_name Interval Text
H20_name Water Level
HST_name Interval Data
HZL_name Horizontal Line
LTH_name Lithology
NOT_name Edit Notes
PPP_name Pattern Percent
SCA_name Scale Table
SCB_name Orientation
SYP_name Point Symbol
SYM_name Symbol
TAD_name Tadpole
TMD_name Time Data
TXT_name Point Text
VTX_name Vertical Text
WCN_name Construction

 

See also

 

Back to Importing Data

RockWare home page