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

I'm trying to paste the contents of an Excel sheet into a list in Datasheet view. This list has several multiline columns, and the Excel data items i'm trying to paste in are quite large--in some cases, up to 35000 characters in one cell. There are about 7000 rows of data in the sheet and 30 columns. When I select all the data in the Excel sheet and try to paste it into the Datasheet, I get this message:

31879 cells could not be pasted.
Some data was truncated because the pasted data contained more characters than the destination column allows.
Do you wish to continue with the operation and accept the changes?

When I click "yes", I end up with truncated data in the multiline fields. But if I copy the data, then click so that the cursor is in an individual mutiline cell, and then pasted the data, all the data for that cell is successfully pasted.

How can I paste the whole data set without it getting truncated?

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.