다음을 통해 공유

Importing an Excel spreadsheet

  • 아티클

Question: I have been taking a look at the ticket request form sample that you posted. It has helped me quite a bit in a solution that I am putting together for my company. However, I don’t understand how you initially imported your data from Excel into the SharePoint list? Can you show how that was done?

 

Answer: One of the great things about SharePoint is that it is built on the idea of a list metaphor. This has been extended to include both custom and imported lists. Take a look at this short video example located here, to see how you can import this type of data into a SharePoint list.

 

Watch the video

Comments

  • Anonymous
    April 14, 2005
    Great demo, thanks!

    Is it possible to take that imported list and turn it into a real Events list? That is, one that has a 'Link to Outlook' button?

    I have an Excel spreadsheet that was an export of another Events list (so it has start end end times/dates, etc). I am able to create a calendar view for the imported list, but the 'Link to Outlook' button is missing. There seems to be something magical about a real Events list that I can't figure out.

    Thanks.
  • Anonymous
    April 14, 2005
    Unfortunately, I don't know of any easy way to do it. The easiest way that I found without coding is really -
    1. Create the list (ie. events)
    2. Export it to Excel
    3. Copy and paste into the Excel sheet.

    If anyone else has an easier answer would love to hear from them.