Bentley Communities
Bentley Communities
  • Site
  • User
  • Site
  • Search
  • User
RAM | STAAD | ADINA
  • Product Communities
RAM | STAAD | ADINA
RAM | STAAD | ADINA Wiki How to Transfer Data from EXCEL to STAAD.Pro
    • Sign In
    • -RAM | STAAD | ADINA Wiki
      • +ADINA
      • +iTwin Analytical Synchronizer_
      • +Structural Analysis Support Solutions
      • +RAM Concept
      • +RAM Connection
      • +RAM Elements
      • +RAM SBeam
      • +RAM Structural System
      • -STAAD.Pro
        • +Revision History
        • -STAAD.Pro Support Solutions
          • STAAD.Pro Safety Related Features
          • -Analytical Modeling workflow
            • +STAAD.Pro Analysis Solutions
            • +STAAD.Pro Design Solutions
            • -STAAD.Pro General Solutions
              • 3D Space to 2D plane conversion
              • A meaning of command SET GUI 1 in STAAD.Pro
              • Analyze multiple STAAD.Pro models in a batch processing
              • Books on STAAD from the Bentley Press
              • Bridge Deck is not available in the list of Workflow
              • Changing the Base Unit Settings in STAAD.Pro
              • Computation of Center Of Rigidity (CR)
              • Computation of Story Stiffness
              • Convert Single Line Input to Multiple Line Input
              • Create Tab is Disabled
              • Creating an archive of the analysis files
              • +Customizing the Interface in STAAD.Pro CONNECT Edition
              • Deleting files generated at the time of analyzing a STAAD.Pro CE model
              • Display Node to Node Dimension
              • Error in analysis ERROR FILE NOT FOUND
              • ERROR-STAAD BUILT IN MEMORY BLOCK HAS OVERFLOWED
              • How can I change the name appears in STAAD.Pro output header
              • How do I change the Background color?
              • How do I deactivate the additional modules in STAAD.Pro
              • How to access Help File in STAAD.Pro Connect Edition?
              • How to Graphically Display the Distance Between Two Nodes
              • How to Transfer Data from EXCEL to STAAD.Pro
              • How to View Individual Floors
              • Maximum model size in STAAD.Pro
              • Navigate 3D Rendered Window
              • Online Training resources for STAAD.Pro
              • Organize Joint Coordinate Data
              • Pdf file for STAAD.Pro Help Documentation
              • Prevent Truncation of Joint Coordinate Digits.
              • Recovering STAAD model data
              • Results do not Match for E
              • Retain my Input using the REPEAT Commands
              • Some of the icons in my STAAD.Pro interface are grayed out
              • STAAD PLANE - what are the assumptions
              • STAAD.Pro analysis results getting deleted
              • STAAD.Pro File Extensions
              • STAAD.Pro manuals in .pdf format
              • Stiffness Matrix of a Tapered Beam
              • Temporary local folder specified for analysis does not exist or is not accessible
              • Tension/Compression Converged
              • The information in Staadpro.ini is not in the expected format
              • This structure is disjointed, accompanied by several instability warnings
              • +Tool Search option in the STAAD.Pro CONNECT Edition
              • Unable to launch STAAD.Pro Connect Edition in Windows 7.
              • Unable to open STAAD.Pro model
              • Validation examples of STAAD.Pro
              • Want to abstain STAAD.Pro CONNECT Edition Licensing dialog box.
              • When I open a file from ProjectWise server, STAAD.Pro crashes
              • Where can i find the Installation Log file for my STAAD. Pro Product?
              • Where can i find the Installation Log for my STAAD. Pro Product?
              • Why does the program give some strange numbers when the joints are generated graphically
            • +STAAD.Pro Import/Export Solutions
            • +STAAD.Pro Modeling Solutions
          • +Building Planner workflow
          • +Connection Design workflow
          • +Physical Modeling workflow
          • +Piping workflow
          • +Postprocessing workflow
          • +Steel AutoDrafter workflow
        • +STAAD.Pro OpenSTAAD
        • +(+) Archived Wikis
        • +STAAD.Pro - Known Issues
        • +STAAD.Pro Download/Installation/Performance/Security
        • +STAAD.Pro Licensing Solutions
        • +STAAD.Pro Webinars/Videos/Events
      • +STAAD Foundation Advanced
      • +STAAD Advanced Concrete Design (RCDC)
      • +STAAD.building
      • +STAAD RCDC FE
      • +Scenario Services
      • +STAAD.offshore
      • +Limcon
      • +Microstran
      • +MStower
      • +Structural Dashboard
      • +Structural WorkSuite
    • +RAM | STAAD Learning Resources
    • Simplifications to Bentley's Engineering Simulation Software Licenses

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

    How to Transfer Data from EXCEL to STAAD.Pro

       
      Applies To 
       
      Product(s): STAAD.Pro
      Version(s): All
      Environment:  N/A
      Area:  General Solutions
      Subarea:  General Information
      Original Author: Bentley Technical Support Group
       

    Can you please tell me how to transfer data from EXCEL to STAAD-PRO?

    The only data which can presently be transferred from Excel to STAAD is the geometry information, namely, joint coordinates, member incidences, plate element incidences, and solid element incidences. To do this, first select the cells in Excel where you have the numbers, and choose Copy from Excel's edit menu.

    Next, come into the STAAD program. The data may be brought into a new STAAD file or an existing STAAD file. Accordingly, open a new file or an existing file.

    Select the Geometry page from the left side of the screen, and choose the Beam, Plate or Solid sub-page depending upon the type of information you wish to bring in.

    If you are looking to bring it into a New file, close the Snap/Node dialog box which is open on the right hand side of the screen.

    For copying the joint coordinate data, click on the appropriate starting cell in the Node Tables grid on the right side, and type Ctrl+V or select paste from the Edit menu.

    For beam incidence, plate incidence or solid incidence data, click on the appropriate starting cell in the Beam Tables, Plate Tables or Solid Tables grids on the right side, and type Ctrl+V or select paste from the Edit menu. You should see the numbers you copied from Excel appear in those cells.

    • How to Transfer Data from EXCEL to STAAD.Pro
    • Share
    • History
    • More
    • Cancel
    • Steve Crabtree Created by Steve Crabtree
    • When: Wed, Jun 15 2016 12:37 PM
    • Abhisek M Last revision by Bentley Colleague Abhisek M
    • When: Thu, Jun 8 2023 7:14 AM
    • Revisions: 4
    • 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