combine multiple text files into one excel spreadsheet powershell

This topic contains 1 reply, has 2 voices, and was last updated by  Robert Prüst 2 years, 10 months ago.

  • Author
    Posts
  • #20547

    Mohamed Naguib
    Participant

    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

    Robert Prüst
    Participant

    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.

You must be logged in to reply to this topic.