How to export data to CSV in PowerShell?

This solution creates a psobject and adds each object to an array, it then creates the csv by piping the contents of the array through Export-CSV.

$results = @()
foreach ($computer in $computerlist) {
    if((Test-Connection -Cn $computer -BufferSize 16 -Count 1 -ea 0 -quiet))
    {
        foreach ($file in $REMOVE) {
            Remove-Item "\\$computer\$DESTINATION\$file" -Recurse
            Copy-Item E:\Code\powershell\shortcuts\* "\\$computer\$DESTINATION\"            
        }
    } else {

        $details = @{            
                Date             = get-date              
                ComputerName     = $Computer                 
                Destination      = $Destination 
        }                           
        $results += New-Object PSObject -Property $details  
    }
}
$results | export-csv -Path c:\temp\so.csv -NoTypeInformation

If you pipe a string object to a csv you will get its length written to the csv, this is because these are properties of the string, See here for more information.

This is why I create a new object first.

Try the following:

write-output "test" | convertto-csv -NoTypeInformation

This will give you:

"Length"
"4"

If you use the Get-Member on Write-Output as follows:

write-output "test" | Get-Member -MemberType Property

You will see that it has one property – ‘length’:

   TypeName: System.String

Name   MemberType Definition
----   ---------- ----------
Length Property   System.Int32 Length {get;}

This is why Length will be written to the csv file.

Update: Appending a CSV Not the most efficient way if the file gets large…

$csvFileName = "c:\temp\so.csv"
$results = @()
if (Test-Path $csvFileName)
{
    $results += Import-Csv -Path $csvFileName
}
foreach ($computer in $computerlist) {
    if((Test-Connection -Cn $computer -BufferSize 16 -Count 1 -ea 0 -quiet))
    {
        foreach ($file in $REMOVE) {
            Remove-Item "\\$computer\$DESTINATION\$file" -Recurse
            Copy-Item E:\Code\powershell\shortcuts\* "\\$computer\$DESTINATION\"            
        }
    } else {

        $details = @{            
                Date             = get-date              
                ComputerName     = $Computer                 
                Destination      = $Destination 
        }                           
        $results += New-Object PSObject -Property $details  
    }
}
$results | export-csv -Path $csvFileName -NoTypeInformation

Related Posts:

  1. How to upgrade PowerShell version from 2.0 to 3.0
  2. Copy file remotely with PowerShell
  3. How to find the Windows version from the PowerShell command line
  4. Powershell: GetType used in PowerShell, difference between variables
  5. Connect-AzAccount – how to avoid azure device authentication?
  6. How do I concatenate strings and variables in PowerShell?
  7. PowerShell equivalent to grep -f
  8. How do you comment out code in PowerShell?
  9. Running a command as Administrator using PowerShell?
  10. Setting Windows PowerShell environment variables
  11. How do I concatenate strings and variables in PowerShell?
  12. Replace substring in PowerShell
  13. Echo equivalent in PowerShell for script testing
  14. Echo equivalent in PowerShell for script testing
  15. PowerShell says “execution of scripts is disabled on this system.”
  16. How to use the curl command in PowerShell?
  17. PowerShell and the -contains operator
  18. Change directory in PowerShell
  19. How to handle command-line arguments in PowerShell
  20. Splitting a string into separate variables
  21. How to split string by string in Powershell
  22. How to split string by string in Powershell
  23. Downloading a file with PowerShell
  24. Terminating a script in PowerShell
  25. How to run an EXE file in PowerShell with parameters with spaces and quotes
  26. How to run an EXE file in PowerShell with parameters with spaces and quotes
  27. Terminating a script in PowerShell
  28. Prompt for user input in PowerShell
  29. How do I concatenate strings and variables in PowerShell?
  30. Array.Add vs +=
  31. PowerShell and the -contains operator
  32. PowerShell string interpolation syntax
  33. How to write to the console in PowerShell?
  34. Function return value in PowerShell
  35. PowerShell ‘Or’ Statement
  36. powershell -Or operator not working
  37. How to decode a Base64 string?
  38. Read file line by line in PowerShell
  39. Path to Powershell.exe (v 2.0)
  40. Azure Powershell Select-AzureSubscription with subscription id
  41. How to unzip a file in Powershell?
  42. You cannot call a method on a null-valued expression
  43. How can I replace every occurrence of a String in a file with PowerShell?
  44. Unix tail equivalent command in Windows Powershell
  45. Create directory if it does not exist
  46. Copy-Item is overwriting by default
  47. The term ‘Get-ADUser’ is not recognized as the name of a cmdlet
  48. How to print environment variables to the console in PowerShell?
  49. The term ‘nmake’ is not recognized
  50. Ternary operator in PowerShell
  51. Get-WmiObject : The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
  52. Call PowerShell script PS1 from another PS1 script inside Powershell ISE
  53. Does PowerShell has something like “echo off” and “echo on” trigger?
  54. Convert a string to datetime in PowerShell
  55. LDAP query in PowerShell
  56. PowerShell: Comparing dates
  57. Press any key to continue
  58. accessing the $args array in powershell
  59. Create a function with optional call variables
  60. How do I do ‘dir /s /b’ in PowerShell?
  61. Create Log File in Powershell
  62. What does the & symbol in powershell mean?
  63. What does the double asterisks mean?
  64. How to enter a multi-line command
  65. How to break lines in PowerShell?
  66. How to tell PowerShell to wait for each command to end before starting the next?
  67. How to convert string to integer in PowerShell
  68. One Powershell Script calling another with parameters
  69. Concatenate files using PowerShell
  70. Passing multiple values to a single PowerShell script parameter
  71. Upload files with FTP using PowerShell
  72. Powershell send-mailmessage – email to multiple recipients
  73. Sometimes PowerShell stops sending output until I press enter. Why?
  74. In a PowerShell script, how can I check if I’m running with administrator privileges?
  75. What is the literal escape character in Powershell?
  76. PowerShell says “execution of scripts is disabled on this system.”
  77. How do I start PowerShell from Windows Explorer?
  78. Extract a substring using PowerShell
  79. How to run a PowerShell script
  80. How to run powershell script from .ps1 file?
  81. How to use operator ‘-replace’ in PowerShell to replace strings of texts with special characters and replace successfully
  82. How to use _CRT_SECURE_NO_WARNINGS
  83. Check if a file exists or not in Windows PowerShell?
  84. How to run a PowerShell script
  85. How can I pass an argument to a PowerShell script?
  86. Powershell: A positional parameter cannot be found that accepts argument “xxx”
  87. Equivalent of *Nix ‘which’ command in PowerShell?
  88. What does the “@” symbol do in PowerShell?
  89. Upload file to SFTP using PowerShell
  90. How to assign multiple lines string in Powershell Console
  91. How to run PowerShell in CMD
  92. How can I test that a variable is more than eight characters in PowerShell?
  93. How do I get the current username in Windows PowerShell?
  94. Difference between $? and $LastExitCode in PowerShell
  95. How do I force Robocopy to overwrite files?
  96. Install-Module : The term ‘Install-Module’ is not recognized as the name of a cmdlet
  97. Simple PowerShell LastWriteTime compare
  98. Get file version in PowerShell
  99. How do I diff two text files in Windows Powershell?
  100. How to zip/unzip files in Powershell?

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedueduedueduseduseduseduedusedu