How To Embed Data From Excel In WordPress
1 billion people uses Excel software so, in today's article, you'll learn how to embed data from excel in WordPress simply and effectively,
Whether you use Microsoft Excel to create small tables, large sets of data, charts, or live data functions, nearly 1 billion users would agree it is the best spreadsheet software out there. However, when it comes to displaying Excel data on a website, it’s not as easy as it could be. We’ve put together this tutorial to show you an easier route. In today’s article, you’ll finally learn how to embed data from excel in WordPress simply and effectively.
How do I get my Excel data into WordPress
Various disjointed solutions will do the job, but none of them link data directly into your WordPress page. Usually, you need to upload files or recreate what you’ve already made in Excel.
Connect your spreadsheet to WordPress, and there’s no need to leave Excel again!
ipushpull is a SaaS app that offers a premium WordPress plugin that connects Excel straight to WordPress. It allows you to publish any data (live or static) that sits in an Excel spreadsheet and needs to appear on a WordPress page.
Once your data is in connection, any changes you make can either update live automatically in under a second or when you choose to release it at the push of a button manually.
Displaying data couldn’t be simpler, as you don’t need any HTML knowledge. An easy-to-use pop-up in WordPress makes possible to select your page and add a shortcode. Ipushpull do all the heavy lifting for you, and once you’re ready a runner-up, all your work is up in Excel.
You can publish league tables, jobs rotas, financial data, research charts, or anything you like to WordPress without leaving Excel.
Note: ipushpull offers a 7-day free trial and paid plans.
How to embed any Excel data in WordPress pages
Step 1 – Sign up for an ipushpull account
You will first need to set up an ipushpull account. There is a free 7-day trial and packages with all the features outlined on their pricing page, but try it out first with the free service.
Step 2 – Download and install the ipushpull add-in for Excel
Once your account is setup, log in and download the add-in for Excel, which will connect your spreadsheet to your WordPress page. Open it and follow the installation instructions.
Step 3 – Login to ipushpull in Excel
When the installation is complete, open Excel. ipushpull creates an Excel ribbon. Once you are logi to the ribbon. Select the range of data in your spreadsheet that you want to display on your website.
Step 4 – Make your data web ready
Click the Push button (Manual Push in the ribbon), create a New Page in the dialog box that opens and name it, then click Push. Your data is now available on the encrypted ipushpull cloud platform, which means it can be embedded on the web. (For live data and charts, please see appropriate sections below).
Step 5 to embed Excel data in WordPress – Activate the ipushpull plugin in WordPress
Next, let’s activate the ipushpull plugin in WordPress, which will allow you to display your data in your WordPress page.
In the WordPress left-hand panel, find Plugins, then Add New, search ipushpull, and click ‘Install Now and “Activate”. This will add ipushpull to your plugins and the ipushpull Shortcode Generator to your page menu for quick and easy access.
Step 6 – Embed your Excel data in WordPress
Navigate to the page you need to embed your data. Click on your new ipushpull icon in the WordPress page menu.
Select your folder and page in the drop-downs, then adjust the height and width of your page. Don’t forget to “Make page public,” which allows the page to be viewed by the general audience (otherwise, viewers will also need ipushpull accounts to view – although this is something you might want if you are looking for added security). Click insert Shortcode to finish.
Your page will now have embedded data once it is published. This is also available with a preview.
How to embed Live streaming data in your website
If you have live data in Excel, it can now be hosted online. This is done with ipushpull’s Live Push feature, which can also be used to create automatic updates from Excel once data has been embedded in a WordPress or web page.
The only variation for live data from the above steps is that you must select a different option in Excel when “pushing” your data to ipushpull. So instead of step 4, please do the following:
Step 4b to embed Excel data in WordPress – Make your live data ready for the web
Select the range of live data you want to embed in your WordPress page and navigate to the Push button in the ipushpull ribbon. Click on the drop-down arrow on the bottom half of the controller.
Select Live Push and in the new dialog box, either create a new page or select the page to host your data securely. Click Live Push.
For the dialog box that pops up, select a cell outside your data to display the status of your Live Push. This will tell you whether your data is updating.
Next, click Start in the ipushpull ribbon. You can always Pause your updates with the same button.
Once you have published your live data on your website at the interval you selected, it will keep updating from Excel as the connection is live when Excel runs.
How to embed a chart or graph in a WordPress page
Just like the data, you can embed any charts or graphs you create in Excel. With ipushpull’s Push function, all Excel charts and graphs are available for embedding. There is no variation for charts from the steps outlined in the first section, as it is published just like manual data. For step 4, the instructions are the following:
Step 4c to embed Excel data in WordPress – Make your chart or graph web ready
Select the chart or graph you want to embed on your web page. Click the Push button (Manual Push) in the ribbon, select a page or create a New Page in the open dialog box, then click Push.
Your chart/graph is now available on the encrypted ipushpull cloud platform, which means it can be embedded on the web.
Great! You now know how to embed data from Excel within WordPress. Embedding data within WordPress is easier than ever, meaning you don’t have to recreate your data or charts for the purposes of the web. You can publish them directly from this software without messing around with code.