Sign in
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote
    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
    |