Need to club all the CSV data into a single CSV

Welcome Forums General PowerShell Q&A Need to club all the CSV data into a single CSV

This topic contains 2 replies, has 2 voices, and was last updated by

 
Participant
5 years, 1 month ago.

  • Author
    Posts
  • #11233

    Participant
    Points: 0
    Rank: Member

    Need to club all the CSV data into a single CSV. Culumn headers are same for all the CSVs

    -Biswajit

  • #11234

    Member
    Points: 0
    Rank: Member
    $sources = '.\file1.csv','.\file2.csv','.\file3.csv'
    $sources | Import-Csv | Export-Csv '.\output.csv' -NoTypeInformation
    

    There's also an -Append switch to Export-Csv, but you don't need it if everything's in one pipeline like that.

  • #11289

    Participant
    Points: 0
    Rank: Member

    Thanks Dave.

The topic ‘Need to club all the CSV data into a single CSV’ is closed to new replies.