Import and synchronize Google Sheets with Joomla

The Droptables Google Sheets importer is quite advanced. You can import the data only and transform it as an editable HTML table or import the Google Sheets file with its style. Google Sheets-style includes colors, backgrounds, column size, links...

Manage your table from Google Sheet and automatically publish it on your Joomla website! You can upload an Excel file to Google Drive or create Google Sheets that will be used as a source for the table. From the table settings, paste the spreadsheet link, and activate the synchronization.

The synchronization between your Joomla table and the Google Sheet can be done automatically on a regular basis, between one minute and one day. The automatic synchronization delay can also be defined to avoid unwanted Joomla public table update or in order to save server resources in case of a very large table.

After importing a table, all the data can be edited, this is just a regular HTML table editable a Joomla spreadsheet like plugin!.

On the other hand, after creating a nice designed table with all the data you want, you can export it as a regular Excel file and, for example, re-run an import of the updated file as a Google Sheet later. The table export as an Google Sheets can also be executed on Joomla frontend, by your users (as an option).