News Blog: WordPress & Joomla Extensions

Synchronize and import Excel files with Wordpress tables

IMAGE-AUTOMATIC-RENAME

Important organizations have important Microsoft Excel files, and important Excel files deserve to be displayed professionally. This post evaluates all the options you have available on WordPress to display your tables in a manner that is consistent with your WordPress website's theme, sending a professional message to your website's customers.

WP Table Manager is the perfect way to create spreadsheets and display aesthetically-pleasing tables in a professional setting. While the plugin has many tools to create spreadsheets on WordPress, you might not have waited for WP Table Manager to start tabulating data. If all your company's spreadsheets are stored in Microsoft Excel files, then don't worry: one of WP Table Manager's tools allows you to import your Excel files into WordPress.

 

Thanks to WP Table Manager, you won't have to re-create all your spreadsheets on WordPress manually. Instead, you can use WP Table Manager's import tool to copy your spreadsheets into your WordPress table manager. Best of all, you can import tables in a few simple steps: copy your files onto your server, and make a few clicks. Keep reading to learn more about how to import your Microsoft Excel spreadsheets into WordPress.

 

 

How to import Excel files into WordPress

Importing Excel files into WordPress is not a nightmare. On the contrary, WP Table Manager makes it very easy to start working with Microsoft Excel files in the table manager. Let's dive in!


For this post, we are going to use a Microsoft Excel file containing some car-related expenses, aptly-called "Expenses". The spreadsheet's data looks like the following.

1-Excel

As you can see, it's not just an Excel file: it also has styling and other customization options. Don't remove any styling options because you can still work with them on WordPress.


There are two ways of importing spreadsheets. The first one requires that you copy and paste the Excel file anywhere on your server. For the sake of this example, we are going to create a folder called "Excel-Files" and paste the Excel file there.


Now that you have created a copy of the Excel file, head to Tables Manager and click on the button that says Create New and then choose Table. This button will lead you to a new, empty table, which is the container that will soon have the imported Excel spreadsheet. Name the new table "Expenses", like the local Microsoft Excel file.

 

2-New-table

 

With the newly-created table, click on the Import & Sync item in the menu and choose Excel.

 

3-Import--Sync-Excel

 

You should now see a pop-up window. If you have a direct link to the spreadsheet, you can insert the link directly under Excel link. Otherwise, click on Browse server to look for the Excel file that you copied onto your server.


When you click on the Browse server button, you will see a pop-up window, listing all the folders on your server. Navigate through the tree to the file's location. In our case, the path is wp-content > Excel-Files > Expenses.xlsx. Select the file and click on OK.

 

4-Browse

 

Before importing, there is one last option that you might want to toggle: Fetch Style. This option lets you import the style from the spreadsheet in addition to the data. For example, our spreadsheet had its own style, so we toggled the switch to avoid having to replicate the style on WordPress.

 

5-Fetch-style

 

Click on Fetch data and WP Table Manager will import the data as well as the style if you also ticked the Fetch Style option. Once the pop-up disappears, you should see your data and style in your WordPress table manager.

 

7-Imported

 

There is also a second, slightly quicker option to import Excel spreadsheets. From Import & Sync again choose Excel. This time, however, don't click on Browse Server, but click on Import Excel to upload the table. Remember to choose whether you want to import the data only or the style too from the first dropdown.

 

8-Import-Excel

As you can see, it is really easy to import Excel spreadsheets into WordPress. Now, you can work on the table as you would with any other table created in WP Table Manager, which also means embedding the spreadsheet in any WordPress post or page.

 

Next Step: Excel Synchronization in Wordpress

The next step after importing the table is to synchronize the Excel spreadsheet with WP Table Manager. In other words, if we edit the table in WP Table Manager, we want the file to change, and vice-versa. The best part is that this is even easier than importing the file, if such a thing is even possible!


To set up the synchronization, head to Tables Manager again, and open the table that you just imported. Now that you are in the table manager, again open the Excel option from the Import & Sync menu just like before and look for the synchronization option, Auto Sync.

 

 

9-Auto-sync

 

Like before, if you want to synchronize the style, make sure to tick the Fetch Style option. Finally, you can select the sync periodicity, or how often WP Table Manager will attempt to synchronize the WordPress table with the Microsoft Excel file.


To set the synchronization periodicity, go to Tables Manager > Configuration. Under the Main Settings tab, click on the dropdown next to Synchronization delay and choose a time. For example, if you choose 5 minutes, WP Table Manager will synchronize the WordPress table with the file on the server every five minutes. Choose No for instant synchronization.

 

10-Synchronization-delay

 

Finally, click on Save settings to conclude the synchronization process. WP Table Manager will handle synchronization behind the scenes, making sure that your WordPress table and Excel file are always aligned.


That's it! We have now converted our Excel file to a WordPress table in just a few simple steps. More importantly, you don't have to go back and forth between the WordPress table and your Excel file copying changes. Neither do you have to waste time copying the styling options because WP Table Manager does all the work for you. A day's work in just a few minutes.

 

Importing online Excel spreadsheets

Nowadays, you don't have to use Microsoft Office to create or edit spreadsheets. It's becoming more and more common to use cloud services, like Microsoft's own Office 365. If you do use Office 365 to collaborate on your spreadsheets, there's good news: WP Table Manager also supports Office 365 spreadsheets.

 

11-Import-Office-365

 

The process to import a OneDrive Excel spreadsheet is largely the same. This time, from the Import & Sync menu, choose OneDrive Excel instead of Excel. The biggest difference is that now you do not need to copy and paste the Office 365 spreadsheet onto your server.

 

12-Embed

Instead, now you just link the OneDrive spreadsheet with WP Table Manager. From Office 365, click on File > Share > Embed and find the Embed code from the bottom of the pop-up window. Copy this link into WP Table Manager and then click on Fetch data.

 

13-OneDrive-link

 

What are you waiting for? Start saving valuable time that you can spend on another, more productive job. Purchase your membership from here!

 

3
Using WP File Download to Sell Digital Files on Wo...
Presenting WordPress Latest Posts Elegantly with M...
 

Comments 8

Guest - Cristian on Wednesday, March 25 2020 14:28

Excelente truco! No sabía que se podía combinar las tablas entre y Wordpress! Ya lo voy a probar. Muchas Gracias

Excelente truco! No sabía que se podía combinar las tablas entre y Wordpress! Ya lo voy a probar. Muchas Gracias
Tristan on Tuesday, April 21 2020 10:25

Thanks for the feedback Cristian!

Thanks for the feedback Cristian!
Oscar on Saturday, July 25 2020 11:40

Hola! Muy buenas. Me ha servido de mucho esto.
Solo quiero consultar si hay forma de editar el Excel que tenemos subido, desde el Frontend de Wordpress y que se guarde.
Desde ya muchas gracias!

Hola! Muy buenas. Me ha servido de mucho esto. Solo quiero consultar si hay forma de editar el Excel que tenemos subido, desde el Frontend de Wordpress y que se guarde. Desde ya muchas gracias!
Tristan on Sunday, July 26 2020 07:00

Hi,

Yes the file imported can be modified by a user if you setup his access to the Excel file.
Note that the modifications won't be reflected on the Excel side, modification are only possible from Excel to WordPress (yet)

Hi, Yes the file imported can be modified by a user if you setup his access to the Excel file. Note that the modifications won't be reflected on the Excel side, modification are only possible from Excel to WordPress (yet)
Giuseppe Parlati on Sunday, April 11 2021 18:39

è possible creare una tabella da programma? cioè in maniera dinamica?

è possible creare una tabella da programma? cioè in maniera dinamica?
Tristan on Monday, April 12 2021 09:38

Hi, yes when you synchronize a WP Table Manager table with an Excel file, the table file data will be automatically synchronized (as an option).

Hi, yes when you synchronize a WP Table Manager table with an Excel file, the table file data will be automatically synchronized (as an option).
Helany Contreras on Monday, September 20 2021 14:03

Hola, quisieras saber si esta herramienta me sirve para sincronizar una tienda física con una online hecha en woocommerce

Hola, quisieras saber si esta herramienta me sirve para sincronizar una tienda física con una online hecha en woocommerce
Tristan on Tuesday, September 21 2021 05:26

Hi, yes you can, if your data are stored in a table on an Excel file or an Office 365 or a Google Sheets.

Hi, yes you can, if your data are stored in a table on an Excel file or an Office 365 or a Google Sheets.
Already Registered? Login Here
Guest
Sunday, September 26 2021

Captcha Image