Import Excel with date to sharepoint Calender

Posted on 2011-05-02
Last Modified: 2012-08-13
Hi, all.

I’m trying to import an excel spreadsheet with the dates and items to a SharePoint calendar, but I can’t get it to work.  I’ve added the spreadsheet as an Access database list item in one of my document libraries.  What am I doing wrong?

Question by:beesoo00
    LVL 9

    Expert Comment

    why not you create a list using that spreadsheet and create a calendar view for that.
    How are you trying to get it work and what is your problem?.

    Author Comment

    I saw this thread and tried to recreate it, but I couldn’t get it to work

    I willl appreciate your help if you show me how to import Excel spreadsheet to sharepoint calender step by step :(

    Thanks in Advance,

    LVL 9

    Accepted Solution

    Hi beesoo00,

    Here is a link on how to import your CSV file into a SharePoint Calendar.  Hope this helps.

    or try

            1 Open the Microsoft SharePoint 2007 application on your computer and then click on the "Create" option from the main page.
            2 Click on the "Import Spreadsheet" option below the "Custom Lists" section. The New page appears on the screen.
            3 Enter a name for the imported CSV file into the "Name" field and then enter a description for the file into the "Description" field.
            4 Click on the "Browse" button from the "File location" field and locate the CSV file on your computer. Click on the file and then click on the "Import" button.
            5 Select the "Table Range" option from the "Range Type" drop-down menu on the dialog box that appears. Select the range from the CSV file that you want to use from the "Select Range" drop-down menu.
            6 Click on the "Import" button and the CSV file data is imported to your SharePoint 2007 calendar.


    Author Closing Comment

    thanks. It works

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
    This collection of functions covers all the normal rounding methods of just about any numeric value.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now