Exporting Borehole Data to Excel - Multiple Tables

RockWorks | Borehole Manager | File |
Export | Multiple Tables | Excel (Bulk Export)

This Borehole Manager program will export selected/all data tables for selected/all boreholes to Microsoft Excel, each RockWorks data table a separate worksheet within the output Excel workbook.

This tool requires that Excel be installed on your computer.

Notice: This program can take a while if you have a lot of downhole I-Data and/or P-Data.  Be patient.

Menu Options
Step-by-Step Summary

Menu Options

• Output Filename: Click on the open button to the right of this prompt to browse for the folder where the Excel file is to be created, and to enter the name for the exported file.
  • Edit/View Output File: Check this box if you want the output spreadsheet to be loaded into Excel when the export is complete.
• Borehole Data:
  • Current borehole: Choose this option to export the data for the current borehole only.
  • Enabled boreholes only: Click in this button if only the data in the activated (checked) boreholes are to be exported.
  • All boreholes: Click in this button of all boreholes in the current project should be exported to Excel.
• Items to Include: Use the checkboxes to select which of the data tables, data types tables, and accessory tables in the current project database are to be exported. They can be activated/deactivated individually, or quickly using the selection buttons.
  • Select All: Use this button to select all of the tables.
  • De-select All: Use this button to de-select all of the tables.
  • Select All Types: Use this button to quickly select all of the Types tables in the database (e.g. Stratigraphy Types, P-Data Types, etc.)
  • De-select All Types: Use this button to de-select all of the Types tables.
  • RCL: This button contains several drop-down options which you can use to save/load menu settings and (if you have RockWorks Level 5) to build RCL scripts.
    • Show RCL: Choose this option to display the menu settings.
    • Load from RCL: Select this option to browse for a list of menu settings for this export program which you've already saved.
    • Save to RCL: Click on this option to save the current settings in an "RCL" file for later re-loading or (if you have RockWorks Level 5) to build RCL scripts.
  • Other Project Data:
    • Project Units System: Check this box to include in the export a worksheet which lists the project coordinate and unit system.
    • Project Dimensions: Activate this option to include a worksheet in which the Output (Model) Dimensions are listed.
    • Project Support Tables: Check this box to include worksheets for any of the Map/Model Tables (such as color fill or polygon tables), Log/Section Tables (such as section or profile location tables), and Index Tables (such as line style or color index tables for legends).
    • Include XYZ Computations: If you want to include the XYZ point for each downhole measurement (which RockWorks stores, in the background, in the database) be sure this box is checked. In the output file, point-based measurements (P-Data) will have three added columns, with the XYZ location for each downhole point. Interval-based measurements (lithology, I-Data, etc.) will have six added columns, with the XYZ location for the top and the XYZ location for the base.

Step-by-Step Summary

1. Access the Borehole Manager if necessary.
2. Open the project to be exported, if necessary.
3. Select the boreholes to be exported by enabling them, if you don't intend to export all.
4. Choose the File | Export | Multiple Tables | Excel (Bulk Export) menu option.
5. Enter the menu options, described above.
6. Click the Process button at the bottom of the window to proceed with the export.

The program will create an Excel worksheet for each data type and save the spreadsheet under the specified file name. If you have asked to view the output file, RockWorks will launch the Excel program for display of the workbook. Each sheet will contain that data for either all boreholes or enabled boreholes in the current project. The structure of each worksheet is different, because of the different nature of the stratigraphy, lithology, i-data, location, and other data.  

! The exported file will have the same format as that required for importing data from Excel into the Borehole Manager.

See also

• Summary of the RockWorks database tables
• Excel file format
• Importing Excel data into the Borehole Manager

Back to Exporting Data
 

RockWare home page