Export to Excel SharePoint List - Remove default column Item Type and Path RRS feed

  • Question

  • When I export a SharePoint list to Excel using the built-in functionality, it exports two extra columns called Item Type and Path. Is there a way to exclude these column from the export. ?
    Monday, October 16, 2017 5:52 AM

All replies

  • This is default behaviour. It's telling you the location from which it was exported and its type, you'll have to create a PowerShell script if you want to remove them. Or open in Datasheet view and cut and paste the data

    If this is helpful please mark it so. Also if this solved your problem mark as answer.

    • Proposed as answer by croute1 Monday, October 16, 2017 6:40 PM
    Monday, October 16, 2017 7:21 AM