sketchucation logo sketchucation
    • Login
    🤑 SketchPlus 1.3 | 44 Tools for $15 until June 20th Buy Now

    Importing data from Excel

    Scheduled Pinned Locked Moved Newbie Forum
    sketchup
    2 Posts 2 Posters 445 Views 2 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A Offline
      Allyson
      last edited by

      Hi Everyone,

      I am extremely new to Sketchup, today is my first day investigating the software program. Before I get started, I want to be looking in the right direction.

      The objective of using this program for me is to draw cases that will be built out of wood. I am collecting data points in excel (x,y,z) for start and stop and for item inputs. My question is, how do i know how to format the data in excel so that I can import the data into Sketchup and have it draw the cases correctly.

      Any help provided would be so greatly appreciated.

      Best,
      Allyson

      1 Reply Last reply Reply Quote 0
      • TaffGochT Offline
        TaffGoch
        last edited by

        Allyson,

        You can save your Excel data in three columns (x,y,z) as a '.csv' (comma-separated-values) file. Excel produces a text file containing your x,y,z data.

        The .csv file can be imported into SketchUp, by use of Didier Bur's 'Cloud_V6' plugin, available here:
        http://www.crai.archi.fr/RubyLibraryDepot/Ruby/en_fil_page.htm

        Note that this plugin will create a guidepoint at each x,y,z location. It can 'skin' the surface, if it's relatively horizontal (such as a topographic surface.) If you have any vertical faces, or 'bottom' faces, or vertices that are 'stacked' over another, the skinning won't work properly. I use the plugin to import vertices for geodesic spheres, and manually connect the data points with the 'line' tool.

        Epcot_Spaceship_Earth.png
        If you have faces that are vertical, or 'beyond' vertical (undercut,) you likely will have to do some manual line connections yourself. Hopefully, this method will give you the start you need.

        Taff

        "Information is not knowledge." -- Albert Einstein

        1 Reply Last reply Reply Quote 0
        • 1 / 1
        • First post
          Last post
        Buy SketchPlus
        Buy SUbD
        Buy WrapR
        Buy eBook
        Buy Modelur
        Buy Vertex Tools
        Buy SketchCuisine
        Buy FormFonts

        Advertisement