# Simple powershell text to CSV convert issue
**URL:** https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224
**Category:** PowerShell Help
**Created:** [March 1, 2018, 12:05pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224 "2018-03-01T12:05:35Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@simon-boyle](https://forums.powershell.org/u/simon-boyle)
#### Post date: [March 1, 2018, 12:05pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/1 "2018-03-01T12:05:35Z")
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
```
---
### Author:  [@donj](https://forums.powershell.org/u/donj)
#### Post date: [March 1, 2018, 12:06pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/2 "2018-03-01T12:06:47Z")
So, the only delimiter in the current file is a space between columns?
---
### Author:  [@simon-boyle](https://forums.powershell.org/u/simon-boyle)
#### Post date: [March 1, 2018, 12:35pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/3 "2018-03-01T12:35:59Z")
Hi Mr. Jones
Yes it is.
---
### Author:  [@donj](https://forums.powershell.org/u/donj)
#### Post date: [March 1, 2018, 12:45pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/4 "2018-03-01T12:45:42Z")
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.
---
### Author:  [@simon-boyle](https://forums.powershell.org/u/simon-boyle)
#### Post date: [March 1, 2018, 12:57pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/5 "2018-03-01T12:57:01Z")
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”
---
### Author:  [@donj](https://forums.powershell.org/u/donj)
#### Post date: [March 1, 2018, 3:36pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/6 "2018-03-01T15:36:01Z")
Well, if it’s tab delimited, then you need to specify that as a delimiter. “`t” is a tab character.
---
### Author:  [@dotnVo](https://forums.powershell.org/u/dotnVo)
#### Post date: [May 16, 2024, 8:36pm UTC](https://forums.powershell.org/t/simple-powershell-text-to-csv-convert-issue/10224/7 "2024-05-16T20:36:19Z")