Welcome to Office & SharePoint Pro Sign in | Join | Help
in Search

SUBSCRIBE to Windows IT Pro Magazine & SAVE 30%      FREE Email Newsletters Vista UPDATE, Windows IT Pro UPDATE & More

Can I import an excel spreadsheet into SharePoint as a list

Last post 04-02-2008, 12:43 AM by bryceu. 1 replies.
Sort Posts: Previous Next
  •  03-26-2008, 8:00 AM 29457

    Can I import an excel spreadsheet into SharePoint as a list

    Senario

    A previously created spreadsheet to gather information from many, now needs more information.  Is there a way to import that spreasheet, turn it into a list and add two more fields?

    Platform XP SPoint 2007, Office 2007, with users on Office 2003

    Thanks in advance

  •  04-02-2008, 12:43 AM 29484 in reply to 29457

    Re: Can I import an excel spreadsheet into SharePoint as a list

    Yes, you can create a Sharepoint list from your spreadsheet. As for adding more fields, you can do it before or after you import the spreadsheet. I'd probably do it beforehand in Excel. Just add your additional column headings that you need and save the XLS.

     

    To create your Sharepoint list, go the the Site Actions menu on your site and select Create.  On the create page you'll find "Import Spreadsheet" under the Custom Lists category.  Once you select it step 1 of a 2 step process will appear where you enter the preferred name for your List and specify where the spreadsheet is. Step 2 occurs in Excel after it opens your file. A dialog will be on screen asking you to select the desired range of cells. Be sure to specify a range where the first row is your desired column names.  Click OK and in short order you'll have your list.

View as RSS news feed in XML
SPONSORED LINKS FEATURED LINKS

Order Your Fundamentals CD Today!Get up to speed quickly and learn how to uncover rich information management and deployment capabilities with this free SharePoint CD. You’ve Deployed SharePoint…Now What?This one-day free online conference delivers the technical knowledge needed to kick MOSS up a notch. In one information-packed day, independent SharePoint experts will present practical, real-world information and provide take-away, ready-to-use solutions Ease Your Scripting Pains with the Flexibility of PowerShell!Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer! Protecting Sharepoint with Double-Take for Windows 5.0Providing SharePoint recoverability is a two step process. Learn those steps now. Vendor protection solutions for SharePoint are incomplete at worst and unreliable at best. So what’s an Administrator to do? Read More… Maximize Your SharePoint Investment This web seminar discusses how true bi-directional replication of SharePoint content from one server to another enables branch offices to maintain access to current SharePoint content.