Simple powershell text to CSV convert issue This topic contains 5 replies, has 2 voices, and was last updated by Don Jones 2 months, 3 weeks ago. Author Posts March 1, 2018 at 5:35 pm #94909 TechGismoParticipant I have apparently misunderstood something about converting txt to csv through powershell My txt file looks like this: The original looks the same but is much larger. OS Users Win98 Admin1 Win7 Admin2 Win8 Admin3 Win8.1 Admin4 Win10 Admin5 I would like some help to conert the text file to csv with comma as a delimeter. Here is my code: Get-Content C:\PS-import\TXT-TO-CSV.txt | ConvertTo-Csv | Export-Csv C:\PS-import\News.csv -NoTypeInformation March 1, 2018 at 5:36 pm #94911 Don JonesKeymaster So, the only delimiter in the current file is a space between columns? March 1, 2018 at 6:05 pm #94912 TechGismoParticipant Hi Mr. Jones Yes it is. March 1, 2018 at 6:15 pm #94914 Don JonesKeymaster Then try: Import-Csv filename.txt -delim " " | Export-CSV filename.csv ConvertTo-CSV only works with structured objects, not text. Import-Csv can create structured objects, and you can give it delimiters other than a comma. March 1, 2018 at 6:27 pm #94915 TechGismoParticipant Hi Mr. Jones Now the csv file looks like this, also it uses tabulator as delimeter, I forgot. "OSUsers" "Win98Admin1" "Win7Admin2" "Win8Admin3" "Win8.1Admin4" "Win10Admin5" March 1, 2018 at 9:06 pm #94932 Don JonesKeymaster Well, if it's tab delimited, then you need to specify that as a delimiter. "`t" is a tab character. Author Posts You must be logged in to reply to this topic.