0

I have a list on SharePoint 2013 and I want to export the list items to excel file. How can I do export process?

  • you mean you want to do it through code? or just from list – Akshay Randive Mar 30 '15 at 6:03
  • I don't want code of list. I want to get list items only. @inferno – zengel Mar 30 '15 at 6:33
1

Go to List and in the ribbon bar you will see an export to excel button. Click on that will save data in excel. save the file with the default "owssvr.iqy".

Open it by double clicking, it will open in excel and then make some edit in the file like writing some text and then if you want delete it again and then save the file with .xlsx or xls extension. Now it will be and Excel file

0

Go to List and on top of List you will see an export to excel button. Click on that will save data in excel.

  • I tried this but it export file as "owssvr.iqy". The file can't open. So I saved as excel this file and when I open the file I got this error "Excel cannot open the file.. Because the file format or file extension is not valid.." How can I export as excel? – zengel Mar 30 '15 at 6:30
  • Please refer to answer by @maos – Amit Mar 30 '15 at 9:25

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.