How to Create a Floorplan of Your Space in Excel
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.
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:
- 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.
- 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.
- Highly customizable: There’s a lot of ways to customize your diagrams in Excel.
- 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.
- 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.
- 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.
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.