I have a list on SharePoint 2013 and I want to export the list items to excel file. How can I do export process?
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