Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Excel Import

  Asked By: Antoinette    Date: Jul 27    Category: Sharepoint    Views: 1618

Anyone have an easy method for importing excel data into an existing list?



4 Answers Found

Answer #1    Answered By: Stephon Valentine     Answered On: Jul 27

There's an import  from excel  spreadsheet option when you go to create
list  - it's grouped with the custom list creation options.

Answer #2    Answered By: Leif Cardenas     Answered On: Jul 27

As far as I can see, the import  From Excel option is
available to create a new list. The original poster
wants to import data  into an existing  list.

Answer #3    Answered By: Jasper Hatfield     Answered On: Jul 27

The only easy  way to import  data from Excel into an existing  list is by
cutting and pasting the Excel Records into the data  Sheet View of the

Of course you could also do it programmatically, but most people don't
rate that as an easy way.

Answer #4    Answered By: Martin Haglund     Answered On: Aug 31

In SP 2007, possibly take the list  into data  sheet (Excel) view, add the rows of new data, then go back to normal view of the list. Have not tried it because I can't even get the data sheet view working because we use an older verison of Excel.

Or, export the current SP list to Excel, update it with new data. Creata a new list with that spreadsheet and trash the original SP list. But if you have anything fancy going on in your list such as lookups, attachments they could get lost. It may also add another ID column on the import  that needs to be cleared out.

Didn't find what you were looking for? Find more on Excel Import Or get search suggestion and latest updates.