combine multiple text files into one excel spreadsheet powershell

Welcome Forums General PowerShell Q&A combine multiple text files into one excel spreadsheet powershell

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

 
Participant
4 years, 2 months ago.

  • Author
    Posts
  • #20547

    Participant
    Points: 0
    Rank: Member

    I' am a new in Power Shell world and i need to create a poweshell script which combine multiple text files into one excel spreadsheet With PowerShell
    is it possible?
    1 – Convert text files from .txt/.tsv to .csv/xlsx

  • #20548

    Participant
    Points: 21
    Rank: Member

    Hey Mohamed,

    You can try the following commands to get you started:

    Get-Command *-CSV
    Get-Content

    That should get you started on creating a .csv file which you can easily import into Excel.

The topic ‘combine multiple text files into one excel spreadsheet powershell’ is closed to new replies.