sketchucation logo sketchucation
    • Login
    ℹ️ Licensed Extensions | FredoBatch, ElevationProfile, FredoSketch, LayOps, MatSim and Pic2Shape will require license from Sept 1st More Info

    Excel into Sketchup or Layout

    Scheduled Pinned Locked Moved LayOut Discussions
    layout
    6 Posts 3 Posters 5.5k Views 3 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.
    • MatteM Offline
      Matte
      last edited by

      Good day to all,
      I have been wrestling for the past few week trying to get an excel file into Layout, so I can show the prices of things along with my sketches of things so people understand the extent of repairs needed. I do all the pricing in excel to keep the changing costs up to date. Importing into Layout ALWAYS crashes every few minutes or so. Trying to do what it is "supposed to work"? ... So my "thinking" was to import the “ALL” info, into Sketchup so I could window the “Big Drawing” as a few sub-views of the overall. And place them next to each other as smaller views to show the “Over All”. But I have not figured out any way of "smoke and mirrors" way to set up such a thing up? Does anyone have any advice!!!!!! I see a few ways out there for… But, at OVER “3 grand” to do it! Since I can barely afford rent! That’s not an option! I am happy to pay a few bucks to “get things done”, but that’s WAY out of my wheel house to even consider. Any advise GREATLY appreciated!
      Thank’s Maka

      1 Reply Last reply Reply Quote 0
      • Dave RD Offline
        Dave R
        last edited by

        Is this in LO2017 as your profile indicates you are using? Can you share the .xlsx file via a PM so I can try it? Let me know what range of cells you want to use.

        Etaoin Shrdlu

        %

        (THERE'S NO PLACE LIKE)

        G28 X0.0 Y0.0 Z0.0

        M30

        %

        1 Reply Last reply Reply Quote 0
        • MatteM Offline
          Matte
          last edited by

          Hi Dave and all,
          Until I figure out how to "xref" in to layout an Excel spreadsheet without major modifications to make it "work". (Oh, by the way, I am using 2017 Sketchup and Layout Pro if it matters?) I have "figured" out a work around.... Here is my "experiment"

          1 - Put Excel on a 8-1/2x14 page layout (For shorter spreadsheet)
          2 - Window around the needed info (Print type to be by selected.
          3 - Print out with Cute PDF (As it allows higher DPI output) I select 3600 DPI - save to location
          4 - Open with Adobe Acrobat Crop if needed > Export as an Image > PNG @ 600 DPI, (I did not know a
          major improvement worth doing at a higher Res.)
          5 - Then import onto Layout page, (Can't do to Sketchup... WAY to blurry). > Scale and place as
          needed.

          Lots of song and dance, but it get's things done. I just have to make and update image and pricing changes. And go through most of these steps again (Except step 5), just have to update newer image saved in same place with same name as original. So far that's "my only hillbilly" way until I figure out something more "professional". Hope this has some value to someone?
          Mattee

          1 Reply Last reply Reply Quote 0
          • Dave RD Offline
            Dave R
            last edited by

            Seems like a lot of screwing around for what you get out of it.

            It wouldn't hurt if you updated to the latest version of SketchUp and LayOut, either.

            Etaoin Shrdlu

            %

            (THERE'S NO PLACE LIKE)

            G28 X0.0 Y0.0 Z0.0

            M30

            %

            1 Reply Last reply Reply Quote 0
            • J Offline
              jenny13857
              last edited by

              Can someone please share a screenshot of how it is done from excel to layout?

              1 Reply Last reply Reply Quote 0
              • Dave RD Offline
                Dave R
                last edited by

                @jenny13857 said:

                ...share a screenshot...

                Shouldn't need a screenshot. Go to File>Insert and select your .xlsx file. Then choose the range of cells you want in the pop up window.

                Your profile says you are using SketchUp 8 Free/Make. If that is correct, you don't have LayOut to import the .xlsx file into. If you are using SketchUp 8 Pro then you have LayOut 3 and it doesn't have the option to import .xlsx files at all.

                Etaoin Shrdlu

                %

                (THERE'S NO PLACE LIKE)

                G28 X0.0 Y0.0 Z0.0

                M30

                %

                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