SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

As you may know SharePoint's default export to excel only exports the columns of that current view to excel. Is there anyway to export all columns, without adding all columns to that current view.

share|improve this question
The export to Excel feature will export only those fields which are added in current view. What is your purpose to export SharePoint list to Excel? – Viraj Gorajia Jan 28 '13 at 8:18
For reporting purposes. Some users need to get the Excel report of the Employee List with all data (columns). I cannot put all those columns to the current view, because there is a lot of column. Putting them to the current view; page is not displayin well because of the width of all columns. – ozdogan Jan 28 '13 at 8:58
I have not tried but ,It is possible to export list within all fields programatically. – Viraj Gorajia Jan 28 '13 at 9:48
up vote 3 down vote accepted

Why don't you make another personal view with all columns?

share|improve this answer
if there is no alternative way, that will be, i think, the only solution. thanks. – ozdogan Jan 28 '13 at 9:11

You can create another view (Export to excel) from create view and add all the columns to the view for export.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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