Create Floor Plan Using MS Excel

36,953

192

17

About: Hello I'm a hobbyist and crafts enthusiast. I love to share things I know would help solve a certain problem. Hope to share more instructables for you all!

Everyone is familiar with MS Excel, right?. MS Excel being a spreadsheet program is used to store and retrieve numerical data in a grid format of columns and rows. Excel is ideal for entering, calculating and analyzing company data such as sales figures, sales taxes or commissions. Yet did you know that it can be used for creating floor plans? Yes, you heared that right!

This 'ible demonstrate the use of Microsoft excel as a tool in designing any type of floor plan (i.e. house, industrial, plant).

So hover on the rest of the steps and learn how I did it.

Step 1: Set-Up Row and Column

Once we open the spreadsheet, we have to set-up the cells to create grid coordinate so that scaling is easy.

I set the column width to 1 and the row height to 9 units.

This can be done by following the steps below:

  • Select entire cells by pressing Ctrl+A.
  • Right click column letters then select Column Width. Change value to 1 then click 'Ok'.
  • Next while entire cells are still selected, right click row numbers then select Row Height. Change value to 9 then click 'Ok'.
  • Now the grid 'working area' is now ready for layout.

Step 2: Create the Scaling and Wall

This part goes through depending on the design in mind to be implemented.

I decided to create a house layout with 400 square feet area (scaled). I started with the wall. The width is 2 square units. By the way, my scaling for this layout is 4 square units (cells) equivalent to 1 square foot.

To create the lines simply create border lines on the cells depending on the scaling used. I put grid lines (in purple) to visualize the 1 square foot scaling.

Step 3: Start Partitioning the Floor Area

Now that the floor area has been established. I partitioned it by putting walls inside creating rooms in the layout.

I started with the bedroom and living room area. Next I worked with the bathroom and closet. At this moment I added shapes from the Shape toolbar to create figures on the layout (for the lavatory, faucet bowl etc.).

Afterwards, I created partition for the pantry and kitchen adding also shapes to make it look more of a layout .

Step 4: Refine the Floor Plan

I refine the layout by removing the lines connecting the walls making it look as one. I did it by selecting the cells with the 'unnecessary' lines then right click on it. Select the format cells option then go to borders option and remove the unnecessary lines as mentioned.

I eventually end up adding an area for the balcony of my design.

Step 5: Add Color and Last Touches

I colored the layout on some parts. This makes it look more realistic (I guess). Don't forget the labels for each area. Some decorations can be added to improve the look of the design. In my design I added a sofa, a TV, bed, table lamps etc.

That's it for my demonstration of using MS Excel Spreadsheet as floor plan layout tool. One restriction i can see using this tool is that it's limited to horizontal and vertical wall designs. To overcome this, shapes can be used as alternative arranged diagonally.

Hope you enjoyed it!

Thanks for your attention.

Creative Misuse Contest

Participated in the
Creative Misuse Contest

Share

    Recommendations

    • Colors of the Rainbow Contest

      Colors of the Rainbow Contest
    • Classroom Science Contest

      Classroom Science Contest
    • Sensors Contest

      Sensors Contest

    17 Discussions

    0
    None
    SudhakarP2

    12 hours ago

    I am a retired Civil Engineer. I am planning to develop my agricultural land in my native place. This has helped me in drawing the details in the MS Excel spreadsheet. Thank you for this technical Information.

    0
    None
    PaulD279

    Question 3 months ago

    I can't follow your instructions on how to set and draw to scale. Could you please elaborate?

    0
    None
    NoBoxEver

    10 months ago

    I've used Excel for ages for its original purpose-- never thought of using it for a planner. I can stop laboriously scratching away on graph paper, which is often unsatisfactory. I can also see its value for creating all kinds of patterns!

    1 reply
    0
    None
    ArtuinoNoBoxEver

    Reply 10 months ago

    yes, creating patterns using excel would be fun as well.

    2
    None
    raphanNancyK85

    Answer 11 months ago

    Nancy, don't post your email never ! You'll be drown in scams.

    0
    None
    ArtuinoNancyK85

    Answer 11 months ago

    Hi Nancy,

    Have sent already your requested excel file.

    0
    None
    sendrakhi

    11 months ago

    Can you please provide us more detailed information how to created this?

    1 reply
    0
    None
    Artuinosendrakhi

    Reply 11 months ago

    Thanks. At what particular part would you want me to provide elaborate information?

    1
    None
    dumb_and_dumber

    11 months ago

    CooL! I just remembered myself twenty years ago. I drew the same plans in Excel.

    But twenty years have passed! You can take freeware Sketchup and make much more and more clearly. Why return to the past?

    1 reply
    0
    None
    Artuinodumb_and_dumber

    Reply 11 months ago

    Well, I guess that's right..this is just a demonstration showing people a different approach to floor plan design using a practical tool already lying around. thanks.

    0
    None
    OutofPatience

    11 months ago

    My sister does this, but hasn't had the patience to teach me how, so I've continued to do it the old fashioned way. But I've wanted to be able to do this, so I greatly appreciate that you have taken the time to write this up. Thank you!

    1 reply
    0
    None
    ArtuinoOutofPatience

    Reply 11 months ago

    Thanks...I have done this before. Just recently remembered doing it and decided to create an 'ible about it.

    3
    None
    krn1978

    11 months ago

    Have you ever tried Sweet Home 3d? :)

    1 reply
    0
    None
    Artuinokrn1978

    Reply 11 months ago

    No haven't tried it but may give it a try sometime. the graphics looks great.

    0
    None
    jeanneambro

    11 months ago on Step 5

    I've used Excel for floor plans for years now - never thought of writing an instructable though - kudos to you, and thanx.

    1 reply
    0
    None
    Artuinojeanneambro

    Reply 11 months ago

    thanks. have used it well before in designing my mother's house's renovation.