cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Import data from excel or csv file to share point list.

Hi,

 

Is there any way by which I can add the data of a csv/excel file to the existing sharepoint 2013 list? In other words, I want to create a new item in the list for each corresponding row in the csv/excel file. This is a repeating process in which I need to create new items every time I upload the excel/csv file in the existing list.

 

Thanks,

Ratnesh Garg

Labels: (2)
0 Kudos
Reply
8 Replies
Not applicable

Re: Import data from excel or csv file to share point list.

Hi,

When you create your list there are possibility to create that list from spreadsheet:

0 Kudos
Reply
Not applicable

Re: Import data from excel or csv file to share point list.

Hi Donatas,

The feature you are talking about is for creating a new list. In my case, I already have a list and I need to create the new items in it at regular intervals from the excel file. In other words, I don't want to create a list but create the items in an existing list.

0 Kudos
Reply
Not applicable

Re: Import data from excel or csv file to share point list.

So use spreadsheet view.

0 Kudos
Reply
Not applicable

Re: Import data from excel or csv file to share point list.

You can use "Quick Edit" function in ribbon bar. Copy data in Excel file and paste to grid. It work for me.

0 Kudos
Reply
Not applicable

Re: Import data from excel or csv file to share point list.

Hi everyone,

 

I got my solution using papaparse.js and SPServices in javascript..

Thanks a lot for all your comments.. :-)

0 Kudos
Reply
Highlighted
Not applicable

Re: Import data from excel or csv file to share point list.

Hi Ratnesh, can you share your solution?

Thanks

0 Kudos
Reply
Not applicable

Re: Import data from excel or csv file to share point list.

Hi Lisbeth Duran​ I used a long Java Script code to achieve this functionality.

0 Kudos
Reply
kmccool
Nintex Newbie

Re: Import data from excel or csv file to share point list.

I know this is technically answered, but could this be done with the Query excel services action?

thanks

Kassie

0 Kudos
Reply