combine multiple text files into one excel spreadsheet powershell

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

  • Author
    Posts
  • #20547
    Profile photo of Mohamed Naguib
    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
    Profile photo of Robert Prüst
    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.