Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

Are there tools available for importing an Excel file to a SharePoint list so that the various column types would be supported, and that the importing data would be synchronized based on an a value in an id field, for example? I am interested on a customizable solution ie preferrably not a commercial app with non-public APIs.

share|improve this question

3 Answers

up vote 0 down vote

There isn't an option to do this out of the box. Check out using the BDC?

share|improve this answer
Datasheet view should be supported, and the data is not linked to a specific table: users should also be able to import other files (or excels) to the list. – thomius Feb 13 '12 at 8:11
you can copy and paste rows from an excel file into a datasheet view. You were asking for a synchronized solution, datasheet view isn't it. – David Lozzi Feb 13 '12 at 13:29
up vote 0 down vote

Have you looked at this option: (Requires an Excel plugin)

Publishing and Synchronizing Excel 2007 Tables to SharePoint Lists
http://msdn.microsoft.com/en-us/library/bb462636(v=office.11).aspx

It supports having Date and Text columns as per my memory. More column types may be supported, but I am not sure.

share|improve this answer
Thanks but this Excel 2003 related solution was not an option for us.. – thomius Jul 30 '12 at 19:35
up vote 0 down vote

Option 1: A free solution that requires that you create the SharePoint list in Excel, requires an Excel plug-in (released by Microsoft) and requires that you save in the 2003 xls format to retain the sync.

Option 2: A very inexpensive solution similar to the first but does not require you to create the SharePoint list in Excel first. Has an API.

Option 3: A wildly effective solution with nearly no limitations. Unfortunately, it is comparatively very expensive. Has an API.

share|improve this answer
We ended up doing a custom import/export/synchronize solution. – thomius Jul 30 '12 at 19:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.