So you’ve got all this data in an excel sheet and you have a WordPress Website. Now you want to add that excel chart to WordPress in a blog or page. No worries. Here’s the quick and easy way to do it. If anything isn’t clear, just let me know in the comments section below and I’ll help you out straight away.
The notes that follow will show you how to put the cells and row of an Excel sheet on your website. Another way to put excel charts on your site is to just upload them to your website and then let people download them. If that helps, just follow the same directions I have here on how to insert a PDF to Craigslist. The steps are the same. Instead of putting the link on Craigslist, you can just let people click on them and download them.
- Open your Excel Doc
- Click ‘File’ in the top right corner.
- Now click ‘Save As Web Page.’
- Open that file in NotePad.
- Scroll down to the bottom of the file to where the
<tablesection starts. - Copy every thing from
<tablesection to the</table>section. - Go to WordPress and paste that code in the code section of your post or page.
- Enjoy your new chart!
In Excel
In NotePad
In WordPress
| Example Column 1 | Example Column 2 |
| Data 1 | 1 |
| Data 2 | 2 |
| Data 3 | 3 |
| Data 4 | 4 |
Any questions? I’m here to help! Just leave a comment and I’ll help you out.
Did you get it to work? Post a link in the comments section below!
{ 9 comments… read them below or add one }
Wow! Thanks! I did as you suggested and got my chart into my WordPress website, but the border lines aren’t showing up. I did borders around the boxes in excel before I followed your instructions. Any ideas? The page is private for now until I can get it to look right.
http://www.thinkvictoriamn.com/loyalty-card-offers/
Michelle,
See how my code came out in step 5? There the border attribute is set to zero.
Ex. border=”0?
Change that in your code to equal 1 or some other number.
Since your page is private, I cannot see it. If you make it visible, or if you make it password protected and send me the password, I can check it out and see what to fix exactly.
Hope that helps!
Michelle,
See how my code came out in step 5? There the border attribute is set to zero.
Ex. border=”0″
Change that in your code to equal 1 or some other number.
Since your page is private, I cannot see it. If you make it visible, or if you make it password protected and send me the password, I can check it out and see what to fix exactly.
Hope that helps!
Ty this is awesome… now if I could just get my formulas to work — I want to put my entire spreadsheet in Wordpress with all of the formulas, and I am thinking that isn’t possible. Any suggestions?
)
TY so much for this … it is easy to do. Gotta love that !
Thanks again,
Janie
Janie,
What exactly are you looking to do? Do you just want the static results of the excel or do you want users to enter a value in some place and then have the page automatically execute those calculations?
What I need, is to be able to put my spreadsheets into Wordpress and to also have the formulas that I have in the spreadsheets — still work?
I would also like it if the users could enter a value in some place and then have the page automatically execute those calculations. Is this possible to do in Wordpress?
Janie,
That is do-able, but requires custom coding. The easiest way is in Javascript. There are other 3rd party form apps that might allow this, too. If you have a web designer who helped you with your site, try asking them to convert your excel sheets to javascript.
The good part of your dilemma is that you have excellent, defined requirements. That would make the job very easy for someone to spec out & price. Also, it makes it easy for you to test upon delivery!
I want all my excel files into searchable database that any one can search on the site by typing specific category, kindly help me im looking any plugin likethis for many times,,,
Salman,
Sorry, I don’t know of any plugins for that purpose. Perhaps you can hire a plug in developer to help you out.