General

Re: RE: Export to excel - Hidden columns should be shown- Help

Hilary Stoupa — Thu, 14 Oct 2021 14:44:08 GMT

So, I tried this in a SharePoint online list in modern view. When I export to Excel, any column not displayed in the view (excluding, as you mention, some internal columns) is not included. So I just can't repro this at all. Are you using SharePoint on-prem or online? If online, you may want to open a support case with Microsoft.

Re: RE: Export to excel - Hidden columns should be shown- Help

Keerthi06 — Wed, 13 Oct 2021 06:06:49 GMT

Hi Hilary, Sorry for late reply. I was referring to this one as highlighted in image which i could see in Modern experience. In this i have unchecked the calculated columns which i have used in my SharePoint list. But when i am exporting to excel, I could still see that columns. For example: In my list - i have unchecked the calculated column - Financial Period Start Date Original under edit view. But when I exported to excel, still i could see the same column after the system default columns (item, modified, Path,....)

Re: RE: Export to excel - Hidden columns should be shown- Help

Hilary Stoupa — Wed, 06 Oct 2021 22:33:56 GMT

I'm not sure what the "edit view" is you are mentioning. Is this the same thing as the list view where the user is clicking export to excel? And this is SharePoint on prem 2013? I just tried adding a calculated column to my list and as long as it is not in the list default view, it isn't included in the export.

Re: RE: Export to excel - Hidden columns should be shown- Help

Keerthi06 — Tue, 05 Oct 2021 11:59:31 GMT

HI Hilary, Thanks again for your response! When i export to excel, I am getting the calculated columns whichever created in sharepoint (for date formatting - calculated date fields) along with my view columns. Ihave unchecked those calculated columns in edit view and saved, but still i am getting those along with my view ones. Sample example of my query: In below example, Until company Name is my current view. After that along with system columns (Modified, Modified By) , i am getting the calc fields financial period start date original) ....... Company Code Company Name Created Created By Modified Modified By Content Type Item Type Path Financial Period Start Date Original Financial Period End Date Original

Re: RE: Export to excel - Hidden columns should be shown- Help

Hilary Stoupa — Mon, 04 Oct 2021 17:47:07 GMT

I can't repro this. When I export to Excel, only the columns in the view are included. So, perhaps you need to not display those columns in your list view? I tested in both SharePoint Online and a SharePoint 2013 list and in both cases, only the columns from the current view (along with two system columns, Item Type & Path) were included.

RE: Export to excel - Hidden columns should be shown- Help

Keerthi06 — Mon, 27 Sep 2021 15:32:05 GMT

Hi Folks, I have created an list using SharePoint 2013 InfoPath which is an web-browser enabled form. I have certain many columns along with calculated columns in my list for the customizing the multiple date fields. When i export to excel, I am seeing the hidden columns (unchecked the columns in Edit view) along with required columns. I need only the specific columns as output. Please help out with your suggestions to resolve this.