SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Are there solutions available for importing an Excel to SharePoint with SharePoint column types? Or has someone tried this with the help of OpenXml (with a custom import web part with default values, for example)? Or should I somehow combine existing oob features with something extra?

The problem I see with pure SharePoint is: - Import from Excel does not support SharePoint column types - Copy-paste using datasheet provides bad error messages (ie 1 letter wrong in 1 excel cell causes an error which is very time-consuming to solve: "error occurred in one of 1000000 cells you tried to import. Please try to find the error. Have a nice day!")

share|improve this question

Your Answer


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

Browse other questions tagged or ask your own question.