Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
OpenGround | gINT | Keynetix
  • Product Communities
OpenGround | gINT | Keynetix
gINT | Keynetix Wiki Copy/Cut/Paste between gINT and Excel
    • Sign In
    • -gINT | Keynetix Wiki
      • -gINT
        • Subscription Entitlement Service Benefits for gINT Users
        • Downloading and Installing gINT
        • +The gINT Files
        • +gINT Help, Tips and Tricks, and FAQs
        • +gINT Professional Plus
        • Report-Fence
        • +Report-Log
        • +Downloads: Free Reports and Examples
        • +Geotechnical White Papers and Articles
        • +gINT for ArcGIS Toolbar
        • +How-To FAQs
        • -Things You Can Do In gINT
          • -Data Entry/Things...
            • Automatically Input Default Data
            • Automatically Record Date/Time a Record was Last Modified
            • Change Grid Data Entry Layout
            • Color the Data Entry Grid
            • Consolidate Project Structure
            • Copy/Cut/Paste between gINT and Excel
            • Format Data in INPUT
            • Hide Tables and Fields
            • Manage and Calculate Lab Testing Data
          • +Database\Things...
          • +General Reporting
          • +Graph and Non-Graph Reports
          • +Import/Export/Modeling
          • +Log and Fence Reports
          • +Modeling
          • +Programming
          • +Site Maps
          • +Symbols
        • +Troubleshooting gINT
        • Videos on gINT and subsurface data topics
        • +Tutorials
        • gINT User Guides
        • Learning with gINT - On Demand
        • Working from home with gINT
      • +gINT Collector
      • +gINT Civil Tools
      • +Keynetix

     
     Questions about this article, topic, or product? Click here. 

    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

    • Excel
    • data entry
    • gINT
    • Input
    • copy+paste
    • paste
    • Share
    • History
    • More
    • Cancel
    • Jordan Stierly Created by Jordan Stierly
    • When: Mon, Jun 28 2010 9:43 AM
    • Kirk Johnson Last revision by Bentley Colleague Kirk Johnson
    • When: Thu, Feb 18 2021 2:17 PM
    • Revisions: 8
    • Comments: 0
    Recommended
    Related
    Communities
    • Home
    • Getting Started
    • Community Central
    • Products
    • Support
    • Secure File Upload
    • Feedback
    Support and Services
    • Home
    • Product Support
    • Downloads
    • Subscription Services Portal
    Training and Learning
    • Home
    • About Bentley Institute
    • My Learning History
    • Reference Books
    Social Media
    •    LinkedIn
    •    Facebook
    •    Twitter
    •    YouTube
    •    RSS Feed
    •    Email

    © 2023 Bentley Systems, Incorporated  |  Contact Us  |  Privacy |  Terms of Use  |  Cookies