Just pop it in LibreOffice and save an Excel file. Not 100 but I do need to find a way to automate the process best I can. Unfortunately I only have a starter version of Excel and it doesn't have that feature. It get's generated from a program and there is no option to change the format when it's generated. I do not have any control over the report. You going to say you've got 100s of these to convert now aren't you :( Then just import into Excel, using convert text to columns, without even using powershell.Īnd since you are ultimately going to be using Excel to turn the CSV to an XLSX it shouldn't add too much over head to the process. free text? If so it's going to be really hard to separate out into a CSV file.ĭo you have any control over the original report? If you do you could introduce a lesser used symbol (like ^) to separate the column data. Where you have 'info' in the column data can this be 'anything' so contain commas, spaces, etc i.e. I was hoping powershell might be able to help me. I need to convert a text report.to a csv so I can send it in.

At least if everything is comma delimited I might be able to work with it a little easier. This is why I'm trying to convert it so I can work with it in excel. No but it does contain a 'header' and 'body' that are formatted differently. It's a rather large report and that would just take too long.Ī CSV file is technically a text file, but with a different name, so why not simply rename the file?ĭoes your text file actually contain a string that says '' and '?'

When I try to rename it doesn't format it to anything I'll be able to use without re-typing the whole thing. The issue here is that I don't have a version of excel that will allow me to do text to columns. Well, this isn't using PowerShell, but you could suck it into Excel using column positions and then put it out as a.

Save txt as csv