+ Reply to Thread
Results 1 to 3 of 3

How to convert Text to spreadsheet to Google Calendar

  1. #1
    Registered User
    Join Date
    11-17-2014
    Location
    na
    MS-Off Ver
    0.0
    Posts
    2

    Unhappy How to convert Text to spreadsheet to Google Calendar

    the company posts all employee info as one GIGANTIC spreadsheet. it takes a long time to load, and is very unorganized.

    I'm trying to import events from IXE Toal view

    which looks like this before posting
    http://www.qpc.com/Eu/Images/IEXTota...eduler-lge.gif

    into a
    Google Calendar readable format

    which would look like this
    https://docs.google.com/spreadsheet/...UE&usp=sharing

    following this guide
    http://n8henrie.com/2013/05/spreadsheet-to-calendar/

    right now i have copied all info from {nonadmn} as a txt file. here it is times.txt

    also the ''Open Time TIME PM TIME PM'' serves no purpose to me

    I'm trying to
    export to a readable format for Google Calender and have had no luck for two weeks. so finally, I'm turning to people who understand macros, spreadsheets, and data editing.

    Any ideas guys?

    How to read it.

    Agent name Agent id

    Date Start End Scheduled Activity Start End <-- this line shows as headers in the spreadsheet.

    11/16/14 Off Off means do not work on that day.

    11/18/14 1:00 PM 9:30 PM Open Time 1:00 PM 2:45 PM

    Date- Time start, time stop, open time1:00 PM 2:45 PM is again, pointless.

    Break Time start time end
    and so on.

    I'm trying to get each item to show as a Google Calender event.
    Last edited by wasp; 11-17-2014 at 01:25 AM. Reason: more details

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,391

    Re: How to convert Text to spreadsheet to Google Calendar

    Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
    Also, not all members can upload picture files (Company firewalls and stuff)

    Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    11-17-2014
    Location
    na
    MS-Off Ver
    0.0
    Posts
    2

    Re: How to convert Text to spreadsheet to Google Calendar

    the picture was pulled from Google for search of IXE Toal view.
    i do not have a way to show the actual file due to firewalls and such

    the txt file i have is all i can provide, it was created by copying the company schedule. I'm definitely not concerned about pictures. if this isn't the correct forum, let me know if you have any ideas.
    also, thanks for the quick reply!

+ 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. Export Shifts from Excel to outlook or Google Calendar
    By jeffstu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2013, 03:02 AM
  2. Parse Google calendar for addresses in appointments
    By sellenwood in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2011, 03:50 AM
  3. Replies: 0
    Last Post: 03-27-2008, 04:36 PM
  4. [SOLVED] convert excel spreadsheet to a calendar?
    By convert excel spreadsheet to a calendar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2005, 06:20 PM
  5. convert excel spreadsheet to a calendar?
    By convert excel spreadsheet to a calendar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-02-2005, 06:17 PM

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