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,

By Claudio Pires
Updated on May 23, 2024
How To Embed Data From Excel In WordPress

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.

How To Embed Data From Excel In WordPress
How To Embed Data From Excel In WordPress

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.

How To Embed Data From Excel In WordPress
How To Embed Data From Excel In WordPress

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.

How To Embed Data From Excel In WordPress
How To Embed Data From Excel In WordPress

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.

Final thoughts

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.

Make your chart or graph web ready
How To Embed Data From Excel In WordPress
Claudio Pires

Claudio Pires is the co-founder of Visualmodo, a renowned company in web development and design. With over 15 years of experience, Claudio has honed his skills in content creation, web development support, and senior web designer. A trilingual expert fluent in English, Portuguese, and Spanish, he brings a global perspective to his work. Beyond his professional endeavors, Claudio is an active YouTuber, sharing his insights and expertise with a broader audience. Based in Brazil, Claudio continues to push the boundaries of web design and digital content, making him a pivotal figure in the industry.