fbpx

WP Table Manager: Excel & Google Sheets Sync

1. Import Excel files

At any tables, you can import an excel file from your PC.  First, you should go to Menu Import & Sync > Excel button, then click on Import Excel button to pick an excel file in your PC to import.

 

import-excel-pc

 

Before import the file, you can select an option to import Data only or Data + styles.

 

import-excel-option

 

The tables can be imported from excel or open office documents. The format will be detected automatically and imported. Note that only the first Excel page will be imported.

 

2. Sync a table with an Excel file data

It is possible to run a synchronization between a table you've created and an Excel file located on your server (anywhere). After creating a new table or going to an existing table. Navigate to the Menu Import & Sync > Excel button, then a popup window will appear.

 

import-Excel

 

If you click on the Browse button, you'll be able to select an Excel anywhere on your server, here it's a file uploaded through the media manager (/uploads folder).

 

link-excel-file-table

 

Once your Excel file is linked to the table, you can hit the Fetch data button to import data from the Excel file.

 

fetch-excel-data

 

There are some options you can choose such as: Auto Sync or Fetch Style before clicking on Fetch data button.

Then here is the result of a data import.

 

sync-sheet

 

3. Synchronization with Google Sheets

WP Table Manager also offers some Google Sheets synchronization possibility. Your Google sheet has to be published to be synchronized. So first, open your sheet from Google Drive and publish it as web page using the File menu.

 

publish-web-google-sheets

 

Then you'll get access to the Google Sheets file link, copy this link.

 

link-sheet

 

After that, navigate to Menu Import & Sync, click on Google Sheets button. Then paste the url into Spreadsheet link field.

 

link-to-Excel

 

You're done! You can now fetch data for an instant synchronization and run an automatic synchronization too. The fetch style option is in case you also want to get Google Sheets spreadsheets styles.

 

4. Automatic Excel and Google Sheets sync

Above the file link you can also activate an automatic synchronization. WP Table Manager will fetch the data automatically at a regular interval.

Once it's activated a notification is displayed after the table title.

 

google-sheet-sync-notice

Note that only the first sheet page will be imported only.

The synchronization delay can be set in the WP Table Manager > Main settings.

 

sync-period

 

Note: When you import excel files or sync data from Google sheet, the link will be valid if you use the function: =HYPERLINK()
E.g:  =HYPERLINK("https://joomunited.com", "Joomunited")