Sign up ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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.