Copy/Cut/Paste between gINT and Excel


Subsurface exploration data is commonly stored in Excel, either as a convenient way to collect data in the field or because it is a well-understood, readily-available tool for data entry in the office. If it is already in Excel, data does not have to be re-entered in gINT; it can be moved directly into the gINT database, usually by importing it. Ranges of data cells can also be copied or cut from Excel and pasted into the appropriate gINT table or field. The reverse is also true: data can be copied from gINT and pasted into Excel as needed. 

The ability to copy or Cut and paste data supplements the import of data directly from Excel into gINT, or vice versa. 

When you import data from Excel into gINT, either the worksheet names and Row 1 labels in the Excel spreadsheet need to match the corresponding Table names and Column Headers in gINT, or you need a correspondence file to map between them. 

For these two data sets, for example, many of the Excel row 1 labels are different from the gINT field names:

Excel Field Names in Row 1
Excel fields.jpg (49.89 KiB) Viewed 165 times
gINT Field Names in Borehole (POINT) Table
gINT BH fields.jpg (49.04 KiB) Viewed 165 times

Also, data and header labels may match, but occur in a different order in Excel and gINT, or data in one spreadsheet in Excel may belong in several different tables in gINT.

Rather than writing a correspondence file in order to import data from Excel, it may be quicker to simply copy or cut the data from Excel: 

Copy Excel data.jpg (59.21 KiB) Viewed 165 times

and paste it into the appropriate table and field(s) in gINT:
  
Paste into gINT.jpg (71.19 KiB) Viewed 165 times

This is especially useful when data from a single Excel spreadsheet needs to be brought into fields in several different tables in gINT: 

Copy Water Data.jpg (45.02 KiB) Viewed 165 times
Paste Water Data.jpg (38.32 KiB) Viewed 165 times

The Cut, Copy and Paste keyboard commands are standard Windows commands: Ctrl-C for Copy, Ctrl-V for Paste, etc. Cut, Copy and Paste options are also available from the right mouse-button click menu.

References - Help Topics
- The full range of cut, copy and paste options available in gINT are discussed in gINT Help > Contents > Input Application > Grid > Copying and Cutting and Pasting.
- For import from and export to Excel files, see Help > Contents > Import-Export.

References - Classes
- Topic covered in gINT Fundamentals class