Export Excel Files

The Data Editor's Excel export tool creates an Excel file with individual worksheets for each datasheet in a single or multiple LogPlot LDAT8 file(s). Each worksheet will be labeled with the data type (text versus symbols versus lithology, etc.) and with the specific entity name. Note that (at the time of this writing) Excel limits worksheet names to 31 characters. If your LogPlot datasheet tab names are lengthy, they might exceed this limit when combined with the data type; see the Excel File Format (link below) for details.

The worksheets can be created with data or with column headings only, to act as a template. The file is loaded automatically into the Excel program upon completion of the export process. The exported file has the same format as required for importing Excel data into LogPlot.

You can use this tool as a means of getting your LogPlot data transferred to another software application, via Excel. You can also use this as a means of formatting field data in Excel for future import into LogPlot.

This tool requires that Excel be installed on your computer.

How to…

Export a LogPlot LDAT8 file to Excel format

1. Be sure the LDAT8 file(s) containing the data you wish to export is/are currently open in LogPlot. For a single file export, be sure it is in the visible data window. (See Opening Data Files.)
   
2. Select the File | Export | Excel menu option.
   
3. In the displayed window, enter the requested information:
   • Template Only (no data): Choose this if you want to generate worksheets in Excel with column titles only, to serve as a template for entering data for later import. It will format the template based on the current LDAT8 data file.
   • Multiple Logs Template Only (no data): Choose this if you want to generate worksheets in Excel with column titles only, to serve as a template for entering data for later import. It will format the template based on all open LDAT8 files.
   • Current Log: Choose this option if you want to export the data listed within the LogPlot datasheets, for the current LDAT8 file.
   • All Open Logs: Choose this option to export the data listed within all open LDAT8 files.
   • 
     
4. Click OK.

LogPlot will generate an Excel-format file containing a worksheet for each datasheet, each with column headings identifying the data listed, with or without actual data, for the current data file or all data files, as you requested. The file will be loaded into Excel.

See also

• Excel File Format

Back to Exporting Data

RockWare home page