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)
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.
Next you’ll want to open OneDrive: https://office.live.com/start/ and open excel online. It should look like this:
In the bottom left corner you’ll click on OPEN FROM ONEDRIVE then select the file you want to embed:
in the above case, it’s my Christmas gift list file.
Excel online will open up and your file should be visible.
Click FILE and a new window will pop up – from here you want to select SHARE and then EMBED.
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.
If you want your calculator to be usable by readers, you need to check the box to “Let people type into cells…”
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.
Once you’ve entered all of the above information, you’ll want to select the EMBED CODE from the bottom box and copy it.
Head back over to word press and paste the copied text into a new post under the TEXT (HTML) tab.
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.
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!
- Between Naps on the Porch
- Skip to My Lou