CMS Made Simple Forums

Posted: **Mon Mar 14, 2016 2:50 pm**

Hi all,

does anyone of you know if it's possible to use a spreadsheet to as a database for a calendar (a list of events)? I.e. have a spreadsheet with columns like date, time, event, artist etc and translate that information into an online calendar.

Thanks!

Posted: **Mon Mar 14, 2016 4:23 pm**

If you are using CGCalendar it most likely has an import function like a lot of his modules do...

Posted: **Mon Mar 14, 2016 6:27 pm**

You could make a UDT to read the spreadsheet and fill Smarty variables than process a Smarty template (either from CGCalendar or own you make yourself).

Reading from a CSV would be the easiest, but there are libs for reading an Excel file, and Google has an API to enable reading from a Google Spreadsheet.

Yes it is possible, depending on your time and/or budget.

Posted: **Tue Mar 15, 2016 9:25 am**

Thanks Jeff and Dr.CSS!

CMS Made Simple Forums

Calendar based on spreadsheet (Google or Excel)

Calendar based on spreadsheet (Google or Excel)

Re: Calendar based on spreadsheet (Google or Excel)

Re: Calendar based on spreadsheet (Google or Excel)

Re: Calendar based on spreadsheet (Google or Excel)