Droptables: Excel and Google Sheets Sync

1. Excel file synchronization

It is possible to run a synchronization between a table you've created and an Excel file located on your server (anywhere). From the right tab named "Table", at the bottom you got a block to link an Excel file to the table. 

 

sync-excel-choice

 

On 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 (/images folder).

 

file-browse-excel

 

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

 

Note: Only the data will be taken from Excel, not the styles, so the global style of your table will remain untouched on import.

 

Warning: depending of your memory available on your server, you won't be able to import very large Excel files (more than 1000 rows for example).

 

2. Synchronization with Google Sheets

Droptables offers a Google Sheets synchronization possibility. Your Google Sheets need to be "published to the web" to be synchronized. First, open your sheet from Google Drive and publish it as web page using the File menu.

 

publish-to-web

 

On the Publish to the web pop-up, click on Publish button and confirmation to make sure you want to do it. Then, you will get access to Google Sheets file link, copy this link.

 

published-link

 

And paste it into Droptables “Table” tab. You're done! you can now fetch data from your Google Sheets.

 

google-sheet-data

 

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")

3. Automatic Excel and Google Sheets sync

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

 

sync-period

 

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

 

auto-sync-notification

 

The synchronization delay can be set in the Droptables configuration.