# Can't copy spreadsheet intoLayout

**URL:** <https://forums.sketchup.com/t/cant-copy-spreadsheet-intolayout/120105>\
**Category:** LayOut\
**Tags:** excel\
**Created:** [March 28, 2020, 8:04am UTC](https://forums.sketchup.com/t/cant-copy-spreadsheet-intolayout/120105 "2020-03-28T08:04:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ssbaker305](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/ssbaker305/32/59340_2.png) [@ssbaker305](https://forums.sketchup.com/u/ssbaker305)\
**Post date:** [March 28, 2020, 8:04am UTC](https://forums.sketchup.com/t/cant-copy-spreadsheet-intolayout/120105/1 "2020-03-28T08:04:42Z")

</div>

With my old version of Excel I used to be able to do a Shift+Edit, Copy to copy a portion of a spreadsheet into SU Layout. Now with Excel 2018 instead of Excel 2008, it only copies a portion of what I’m trying to copy, like a strange screen shot. Is there a way to copy sections of a spreadsheet into Layout in this new version? I do this frequently to show various characteristics, costs and revenues of my model in my presentation.

---

<div class="post-metadata">

**Author:** ![DaveR](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/daver/32/7601_2.png) [@DaveR](https://forums.sketchup.com/u/DaveR)\
**Post date:** [March 28, 2020, 1:11pm UTC](https://forums.sketchup.com/t/cant-copy-spreadsheet-intolayout/120105/2 "2020-03-28T13:11:56Z")

</div>

Why don’t you try doing it like it’s designed to work and see if you get the results you want? Save the spreadsheet as a .xlsx file. Then in LayOut, use File\>Insert and select the spreadsheet file. Set the range of cells you want to show and finish inserting it.

---

<div class="post-metadata">

**Author:** ![colin](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/colin/32/266703_2.png) [@colin](https://forums.sketchup.com/u/colin)\
**Post date:** [March 28, 2020, 6:01pm UTC](https://forums.sketchup.com/t/cant-copy-spreadsheet-intolayout/120105/3 "2020-03-28T18:01:29Z")

</div>

If you paste the copied data into a new Excel spreadsheet, does it look correct, or the same as it does in LayOut?

---

<div class="post-metadata">

**Author:** ![DaveR](https://sea2.discourse-cdn.com/sketchup/user_avatar/forums.sketchup.com/daver/32/7601_2.png) [@DaveR](https://forums.sketchup.com/u/DaveR)\
**Post date:** [March 28, 2020, 6:06pm UTC](https://forums.sketchup.com/t/cant-copy-spreadsheet-intolayout/120105/4 "2020-03-28T18:06:28Z")

</div>

As I wrote in his other thread on the exact same topic, copying and pasting into LayOut is not a good idea because it creates a reference to a temporary file which is guaranteed to be deleted. Better to use File\>Insert and insert the spreadsheet .xlsx file.
