0

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them though in a view all columns. I understood there are Lookup columns.

How can I get rid of these columns as I don't need them anymore ? (I think they were created when I was playing/learning how to make some workflows)

Thank you.

0

Go to: List Settings:

enter image description here

Go to: Columns>search for any lookup columns (See under 'Type' column)>select & delete

enter image description here

  • The columns i am trying to delete do not appear in my list of columns. – Catalin Dec 21 '17 at 14:39
  • Are the columns called 'Item Type' and 'Path'? If so, Sharepoint always exports these to Excel. They are not actually columns that can be deleted. If they are related to workflows, then you could try deleting the workflows in order to get rid of these columns; do you still need the workflows? – Tally Dec 21 '17 at 14:55
  • The name of columns are "3" and "XXX" which i think i put them when created some workflows. I deleted all workflows , but the columns still appear. – Catalin Dec 22 '17 at 10:31
  • What happens if you try to modify the view? Can deselect these columns to stop them showing up in your View? – Tally Dec 22 '17 at 10:39
  • in the view i can deselect them, but my issue is when making extraction to msaccess, they appear in the file. ( of if i link msaccess to Sharepoint, when the data is imported to msaccess , these columns appear ) – Catalin Dec 22 '17 at 10:48
0

When you export a SharePoint list to Excel using the built-in functionality, it also exports two columns called Item Type and Path that OOB behaviour of the list. And if your export is routinely done then you can hide the columns by using connection with the workbook . For you reference

0

The lookup field also display in the excel file when you export SharePoint list to excel.

I suggest you provide more detailed information and screenshots for further research.

Or we can export SharePoint list to excel using Client Object Model(C#) to achieve it.

Article: Export SharePoint online List all data to excel Programmatically using csom code

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.