+ Reply to Thread
Results 1 to 5 of 5

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

  1. #1
    Registered User
    Join Date
    11-11-2019
    Location
    Charleston, SC
    MS-Off Ver
    Office 365 Business
    Posts
    3

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

    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.
    Last edited by redfish_matt; 11-11-2019 at 11:57 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,005

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

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

    Pete

  3. #3
    Registered User
    Join Date
    11-11-2019
    Location
    Charleston, SC
    MS-Off Ver
    Office 365 Business
    Posts
    3

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

    Quote Originally Posted by Pete_UK View Post
    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.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,005

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

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

    Pete

  5. #5
    Registered User
    Join Date
    11-11-2019
    Location
    Charleston, SC
    MS-Off Ver
    Office 365 Business
    Posts
    3

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

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. from Excel to Google Calendar
    By h224g in forum Excel General
    Replies: 0
    Last Post: 09-30-2019, 04:22 PM
  2. from Excel to Google Calendar
    By h224g in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 09-30-2019, 04:22 PM
  3. Using Excel VBA to Add events into Google Calendar
    By AV114 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-22-2018, 06:10 AM
  4. Excel to CSV - Google Calendar
    By JAy3k1 in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 07-21-2018, 02:59 AM
  5. Create event in google calendar by one click
    By stanshow in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2017, 04:36 PM
  6. Google Calendar bulk import tool with recurring events.
    By Hindrik in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-30-2016, 09:12 AM
  7. [SOLVED] Automatically Create Tasks From Calendar Events
    By jesika in forum Outlook Formatting & Functions
    Replies: 2
    Last Post: 04-06-2009, 05:34 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1