Using Excel to create Google Calendar (or Perhaps Asana Calendar) Events?

[redfish_matt]

Good day all,

I manage a busy cabinet manufacturing facility in Charleston, SC and we are using Office 365 Excel. In the coming days I am going to be gifted with a new capability from our cabinet design software (a CSV file) that will contain data for each of our upcoming jobs. This CSV will be imported into Excel to calculate labor times, basically.

I'm confident in my ability to use Excel to get that data.

My next step will be using the labor times from that CSV file to create a small MOUNTAIN of Google Calendar entries that are production scheduling. Currently I'm calculating these labor times by hand and making these calendar entries by hand.

Is there a way to link Excel on my PC to the Google Account I'm using so that Excel can create calendar entries for me?

I would want excel to create the calendar entry, name the event using data from the data file, and place the task on the calendar on a date that is based off of date in that data file.


For example, to help clarify. Let's consider cabinet assembly. The data file will already know the following (in cell data)

Job Task-- Assembly
Job Name-- Smith
Job Room --- Kitchen
Cabinet count-- 15 cabinets
Cabinet assembly hours-- 18 labor hours
Job Begin Date: March 1, 2020
Cabinet assembly begins 10 days after Job begin date.

Thus, Excel would create an event on Google Calendar named " Assembly Smith Kitchen 15 cabinets 18 hours" on March 10th.


This sounds like I'm asking a lot, and I know I can do SOME of this in FileMaker (I've integrated FileMaker and Asana for certain tasks) but I'm hoping to avoid spending days writing a database in Filemaker to do this. Other than the creation of Google Calendar entries, the Excel spreadsheet is by FAR the simplest way to handle this data.

[Pete_UK]

You could probably generate the calendar view within the same Excel file - how wedded are you to Google Calendar?

Pete

[redfish_matt]

You could probably generate the calendar view within the same Excel file - how wedded are you to Google Calendar?

Pete

Probably not going to suffice.

I have to be able to see all the job tasks from all other jobs going on at the same time. I think using a calendar view in Excel would only show me that one job's spread of tasks. Trying to draw in all the data from all the other jobs in the shop (each having it's own data file) sounds like it would be quite tedious to set up.

Every cabinet job will have upwards of 20 calendar entries (tasks) and I need to be able to drag and drop them around as the job progresses (or people call out sick, or a machine breaks, or an install date changes, etc).

With Google, I open up the "Month" view and I can see every job we are doing and can manipulate the entries and drag them around to "reschedule" as needed.

[Pete_UK]

Okay, well I thought I'd ask. My calendar files don't have all those capabilities.

Pete

[redfish_matt]

Hmmm.

This looks interesting. I have not explored this option. I can't post the Youtube link yet because I'm new here but I found a video showing how to import via a CSV file.

If Google Calendar can import a CSV then probably what I need to do is format the results of my labor calculations in whatever column/row format that Google Calendar needs and export from Excel, Import to Google Calendar.



Even if the spreadsheet isn't formally doing the "creating" via a script or whatever, this could be a "one step and done" thing, assuming it can create multiple events from a single imported CSV file.