How to Create a Floorplan of Your Space in Excel

 

How to Create a Floorplan of Your Space Using Excel | In this tutorial, learn how to hack Microsoft Excel to create a floorplan of your space. This is an excellent tool for rethinking and redesigning learning spaces, including classrooms and libraries.

Making Your Library Epic – AASL eCourse

I’m gearing up to start my first eCourse with AASL – Making Your Library Epic!  In the course, I’ll be going over strategies and ideas to transform your library space and make it amazing.  The 3-week course is $25 for current members of AASL, which is a pretty fantastic deal.  This post is a teaser for the first week, where I’ll be offering up ideas for how to take a fresh look at your library and identify the problem areas.  The course runs September 12 – 30.  It’s almost booked up, so if we run out of spaces, make sure you sign up for the waitlist – you’ll get first dibs when we offer it again.

Sign up now!

Making Your Library Epic eCourse

The course runs September 12-30 and is $25 for AASL members.


How to Create a Floorplan in Excel

Confession time: I’m a slight spreadsheet nerd.  My dad worked for IBM and I remember seeing him working on spreadsheets on our home computer at a pretty young age.  I got hooked in late high school/early college, creating spreadsheets for my budget, comparing prices at various grocery stores, etc.  So naturally, when I started working as a school librarian, I wanted to use spreadsheets in my work there.  The physical space of our library was horribly cluttered when I first got there, so I immediately started dreaming up ways of changing the space.  Pretty soon, I decided that I NEEDED a spreadsheet of the floorplan of our space.

My first couple of layout designs came out pretty bad, but gradually I started getting the hang of creating floorplans using Microsoft Excel.  Now I realize that there are probably better programs out there for creating floorplans.  Programs that might even be less labor intensive.  But there’s actually method to my madness in using Microsoft Excel:

PROS

  1. Most reasonably tech savvy people know how to use it: A generalization yes, but you’re likely to find more people with Excel experience than with Google Sketchup.
  2. We often already have access to it:  I researched interior design programs when I first started putting together my layout, and most of the good ones were pretty expensive, while the free ones didn’t give me enough customization.  Most people tend to have a copy of Excel on their work or home computers, even Mac users like me.
  3. Highly customizable: There’s a lot of ways to customize your diagrams in Excel.

CONS

  1. Labor intensive to start: When you make your first floorplan, it will take a good amount of work and elbow grease.  But after you do it the first time, it’s pretty easy to continue modifying it.
  2. Doesn’t cater to unusual shapes: I love our Interior Concepts Collaboration table, but it’s REALLY hard to draw that in Excel.  Basic rectangles and circles are a breeze though.
  3. Previous experience in Excel is needed: This post isn’t an intro to Excel, so if you don’t know how to do things like resizing columns and inserting objects, you’ll want to learn that first.

All this aside, I think it is worth your time to try out making a floorplan using Excel.  Now I’m going to show you how I do it.

Creating your floorplan

Click here to sign up for my e-mail list and download my library floorplan. Use it as a starting point for making your own 🙂

1. Create a rough draft on graph paper (or sketch it out on regular paper)

This might seem counter-intuitive, but it’s easier to sketch out your floorplan on graph paper first, and then take that information to make a spreadsheet.  Grab a tape measure, and measure the boundaries of the room(s) you’re creating the floorplans for.  If you have access to the blueprints, awesome!  Using one square on the graph paper to represent one square foot, draw out the basic boundaries of the space.  Now it’s time to put the stuff in your space 🙂

2. Measure ALL THE THINGS!

Measure the length and width of every table, desk, chair, storage unit, etc in your space.  Write down the measurements on a notecard.  For now, you don’t need to worry about exactly where they fall in the space,  What you DO need are a list of how many of each item you have and what their sizes are (ie. Six 30×60 tables, Four 36×90 bookshelves, etc)  Don’t worry about the height – that won’t be represented in the spreadsheet.  Once you’ve got all the data written down, it’s time to transfer that to the computer.

(Insert a video tutorial here – record on your Mac)

3. Setup your spreadsheet like a grid

Excel spreadsheets start out with wide columns, which doesn’t work well for floor plans.  I like to create a grid of squares where each square represents one square foot.  That makes it the easiest for planning out the space.  This website offers a great tutorial for figuring out exactly what numbers work best for you.

4. Create the boundaries of your space in Excel

Decide how many square feet each square on your grid will represent.  I prefer 1 sq ft per square, but that’s me.  Count out the boundries of your space based on your scale and highlight those squares.  Create a bold boundary around this area to help you see the scale you have.

5 . Create fixed objects

If there are certain elements of your space that are fixed, such as wall mounted library shelves, add them straight to the grid.  For our shelves, I highlighted the areas where they are and colored those squares burgundy.  This helps me to get a visual idea of where they are and it’ll be useful in the next step when creating furniture.

6. Create and arrange your furniture items

Using the measurements you took earlier, start to create the furniture items of your space.  This can be as simple or complex as you like.  Basic rectangle shapes tend to work best for most things.  I like to color code my shapes in colors similar to the furniture items, as it helps me to remember what they are.  Try to position the items relatively as they are now.

7. Group items as needed

If there’s a certain grouping of furniture that always goes together (ie. chairs at computer tables) you can group the items together using the group function in Excel.  Hold down control (PC) or command (Mac) and select each of the items you want to group.  Then choose group items.  Now when you move one, you can move all of them

8. Play house

Now that you have all your furniture items in place the way your space is set up, save your file.  Then save as and create a new file for experimentation and ideas.  Move your furniture all over and experiment with new layouts.  Create shapes for furniture items you’re thinking about purchasing and play around with your space.  This is my favorite part of creating an Excel layout – it makes it so easy to experiment with new ideas.


Sign up now!

Making Your Library Epic eCourse

If all this has piqued your interest, make sure you click on over and sign up for my AASL eCourse. The class begins September 12.

 


Diana Rendina, MLIS, is a middle school media specialist/teacher librarian in Tampa, FL. She is the creator of the blog RenovatedLearning.com & is also a monthly contributor to AASL Knowledge Quest. Diana is the winner of the 2016 ISTE Outstanding Young Educator Award, the 2015 ISTE Librarians Network Secondary Award, the 2015 AASL Frances Henne Award & the 2015 SLJ Build Something Bold Award. She is an international speaker on the Maker Movement and has presented at conferences including AASL, FETC & ISTE. Diana co-authored Challenge-Based Learning in the School Library Makerspace with Colleen and Aaron Graves (to be published August 2017). She is also the author of the forthcoming ISTE book, Reimagining Library Spaces.

Comments

  1. This is such a fantastic use for Excel! I’m going to have to try this in the future. Thanks for sharing!

Comments are closed.