Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Update Sharepoint list from Excel

  Asked By: Jill    Date: Jan 02    Category: Sharepoint    Views: 37237

Is it possible to update a Sharepoint list from an Excel spreasheet? I imported
the SS into a SP list, but don't see a way to keep the list updated.



4 Answers Found

Answer #1    Answered By: Cory Brooks     Answered On: Jan 02

Not from an Excel spreadsheet. Importing from Excel into SharePoint is a one
time operation with out of the box tools.

You can link a SharePoint list  to an Access database and keep it up to date
using a linked table. Modifying the data in Access will modify the data in

You could also create a linked table from the Excel spreadsheet in the database
and then run a query which would update  the records in the SharePoint linked

Answer #2    Answered By: Ruth George     Answered On: Jan 02

Yes You can synchronize list  via Excel.
You must go to this site: http://www.softfluent.com/wsslists.htm
Then click: Wss excel  2007 Tables synchronizer install
Then export list to excel , make some changes and click right button on the
table in Excel 2007
then choose table and synchronize with list

This is easy and free solution for sharepoint  users!

Answer #3    Answered By: Peter Peterson     Answered On: Jan 02

Use the list  as the excel  sheet and export to an excel spreadsheet when
needed when you need it. If there are different people working on the
spreadsheet you can put permissions on the list. You can use the data sheet view
to make it look more like excel.

Answer #4    Answered By: Kalyan Pujari     Answered On: Jan 02

Yes of course , You should go to this link and accept to install activex cookie
http://www.softfluent.com/wsslists.htm . After this You can synchronize excel
list with sharepoint  list via context menu (right click on the table in excel
2007 and choose table then synchronize with sharepoint list. This solution is
very easy and free!

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