sharepoint 2013 mass editing of lists

I have a list in sharepoint 2013.  I want to do a mass import from a spreadsheet.
Can someone tell me an easy way to do this.......
Who is Participating?
Rainer JeschorConnect With a Mentor Commented:
I think the best option is to use this tool:

Should be still free and should do all you need without coding.


You can use the drag and drop function in Sharepoint. That would be the easiest way.

You would click on Upload / Upload Multiple Document. Then, just drag and Drops all your wanted docs.

drag and drop
jamesmetcalf74Author Commented:
the list is already created though... I want to add content..
when I drag the file to the sharepoint page... internet explorer tries to open the file

am I missing something
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I'm not sure i understand when you say: add content.

When you drag and drop your files, it does not try to open the files. it just upload on SharePoint only.
jamesmetcalf74Author Commented:
yeah I had a very short explanation.
there is a list that is servers.....

columns are
servername | os |date installed | yadda yadda| yadda2 yadda2

I have a spreadsheet with the same columns with data.  I want to add the data to the list from the excel spreadsheet without actually manually inputting them
In this case, Rainer Jeschor as the answer for you on :
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.