How to Embed a Functioning Calculator (Excel spreadsheet) into WordPress

This was a hack and save, hack and save production – so I thought I’d save you, my fellow bloggers, some time and frustration and just show you how to embed excel into your blog post so you can get on with your day of blogging, photo editing, writing, soliciting sponsors, coming up with ideas, taking care of the kids…..  I know you’re busy – I hear ya’!

If you want to be AMAZING and offer your readers an online calculator to keep track of household budgets or maybe gift lists and expenses – then you need to embed an excel spreadsheet into your blog.  (Note: I only have this figured out for WordPress.org, no other platforms).

You can try out my calculator to see what you think:

First, create your spreadsheet in excel: (I’m assuming an average amount of literacy in excel here)

Screen Shot 2015-10-30 at 7.35.07 PM

I formatted the cells to only show borders between gift recipients and coloured the cells to give it a more user-friendly feel.  Insert images, formulas, your logo – anything you want to make it yours.  Save a copy to your desktop just to be safe.

Next you need to click FILE then SHARE and finally SHARE TO ONEDRIVE.

Screen Shot 2015-10-30 at 7.37.07 PM

Next you’ll want to open OneDrive:  https://office.live.com/start/ and open excel online.  It should look like this:

Screen Shot 2015-10-30 at 7.41.00 PM

In the bottom left corner you’ll click on OPEN FROM ONEDRIVE then select the file you want to embed:

Screen Shot 2015-10-30 at 7.44.12 PM

in the above case, it’s my Christmas gift list file.

Excel online will open up and your file should be visible.

Screen Shot 2015-10-30 at 7.45.44 PM

Click FILE and a new window will pop up – from here you want to select SHARE and then EMBED.

Screen Shot 2015-10-30 at 7.47.17 PM

Another window will open up and you will have a few options:

The first box will let you choose the entire workbook or just specific pages and sections.  I only wanted to show the calculator itself, so I selected that specific area.

Screen Shot 2015-10-30 at 7.50.03 PM

If you want your calculator to be usable by readers, you need to check the box to “Let people type into cells…”

Screen Shot 2015-10-30 at 7.50.18 PM

You’ll want to select a size for your calculator so that it fits within your blog layout.  Enter your px sizes in these boxes.

Screen Shot 2015-10-30 at 7.50.30 PM

Once you’ve entered all of the above information, you’ll want to select the EMBED CODE from the bottom box and copy it.

Screen Shot 2015-10-30 at 7.50.49 PM

Head back over to word press and paste the copied text into a new post under the TEXT (HTML) tab.

Easy right?

Sure, after about 6 hours of trying to figure it all out.  Hopefully this step-by-step on how to embed excel will save you the man hours and impress your readers.

Your audience will be able to enter data into the cells on the spreadsheet and (if you’ve included formulas) calculate totals, averages, expenses etc.  Readers can then save their version of the spreadsheet to their desktop – don’t worry, their edits won’t show up on your blog.

How to embed an excel worksheet into WordPress - create a functioning calculator for your readers!

IT’S SO AWESOME!

Share with your blogging buddies – we can all use a hand to make our job a bit easier right?

Have a great one!

 

Linked to:

 

2018-06-18T13:41:32-04:00November 4th, 2015|For me, Uncategorised|0 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: