• Login
sketchucation logo sketchucation
  • Login
⚠️ Libfredo 15.4b | Minor release with bugfixes and improvements Update

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 2 Dec 2008, 20:47

    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
    • T Offline
      TaffGoch
      last edited by 2 Dec 2008, 23:04

      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
      1 / 1
      • First post
        2/2
        Last post
      Buy SketchPlus
      Buy SUbD
      Buy WrapR
      Buy eBook
      Buy Modelur
      Buy Vertex Tools
      Buy SketchCuisine
      Buy FormFonts

      Advertisement