2

I have to update my existing Sharepoint (2013) List with data from an Excel Sheet. I've only found an old Add-In for Sharepoint 2007. Which other possibilities do I have?

  • Can't you just do a simple copy and paste ? – a1mery Dec 1 '16 at 13:52
  • You can create a new list based on the excel sheet your'e having by Adding a Import SpreadSheet app into the site – Esaki Dec 1 '16 at 13:58
  • Hi @Nico I have a very thorough and tested solution on a related question that I believe will work for you. For SP2013+ you will be working with Quick Edit instead of Datasheet View. That should be the only difference if I'm not mistaken. Answer: Import/Copy/Paste Data from Excel into Existing SharePoint List. – Chiramisu Nov 14 '17 at 19:12
0

Options:

0

How long is the list you want to add? If it's not that long then i think the best way is to copy and then past in the 2013 list using edit mode. Using other ways may cause damage. The thing is that you should compare the two lists in order for them to have the same column in order then put your list on edit mode, copy any number of rows (or columns) using Ctrl + c, click once on the first box and then past using Ctrl + v. If it doesn't work the first time copy less and for the second time copy more.
Good Luck!

0

You can do this with third party tools: export your list to Excel, change whatever you need in Excel and sync your changes back to SharePoint.

I suggest having a look at SharePoint List Synchronizer (disclaimer: I work for SoftFluent, the company that developed this tool). If your need is one time only, this is doable within the trial period (= for free).

Worth noting that there is no server side setup. It's client only.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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