create csv from xls using powershell

Question

I want create powershell script which create me csv file from .xls file but I don't know excacly how to use powershell wihout vba.

So far i have this :

ConvertTo-Csv "C:\Users\Me\TestsShella\test.xlsx"  | Out-File Q:\test\testShella.csv

But it doesn't working.

Possible duplicate of [How to export a CSV to Excel using Powershell](https://stackoverflow.com/questions/17688468/how-to-export-a-csv-to-excel-using-powershell) — Echoinacup, Jan 31 '19 at 13:10
Take a look at the great module from Doug Finke [ImportExcel](https://www.powershellgallery.com/packages/ImportExcel/5.4.0) — Olaf, Jan 31 '19 at 14:04

score 2 · Answer 1 · answered Jan 31 '19 at 14:55

With Excel present on the running machine use it as a COM-object:

## Q:\Test\2019\01\31\SO_54461362.ps1

$InFile = Get-Item "$($Env:USERPROFILE)\TestsShella\test.xlsx"
$OutFile= $InFile.FullName.replace($InFile.Extension,".csv")

$Excel = new-object -ComObject "Excel.Application"
$Excel.DisplayAlerts = $True
$Excel.Visible = $False # $True while testing

$WorkBook = $Excel.Workbooks.Open($InFile.FullName)
$WorkBook.SaveAs($OutFile, 6) # 6 -> type csv
$WorkBook.Close($True)

$Excel.Quit()
[void][System.Runtime.Interopservices.Marshal]::ReleaseComObject($Excel)

Depending on the locale (decimal point/comma) the csv file will either be comma or semicolon seperated.

Without Excel being installed, use the already suggest module ImportExcel

$InFile = Get-Item "$($Env:USERPROFILE)\TestsShella\test.xlsx"
$OutFile= $InFile.FullName.replace($InFile.Extension,".csv")

Import-Excel $Infile.FullName | Export-Csv $OutFile -NoTypeInformation

This yields a .csv file with all fields double quoted and comma seperated.

score 0 · Answer 2 · answered Jan 31 '19 at 14:22

0

There is a prebuilt library for this:

https://www.powershellgallery.com/packages/ImportExcel/5.4.4

You will then have the import-excel function/cmdlet available to you and will be able to import, convert to csv and then export

answered Jan 31 '19 at 14:22

Fazer87

1,072
1
10
14

score 0 · Answer 3 · edited Aug 11 '20 at 11:13

0

Maybe this could work:

rename-item -Path "C:\Users\Me\TestsShella\test.xlsx" -NewName "item.csv"

you will get a message when open the CSV, but the format of CSV is like XLSX.

edited Aug 11 '20 at 11:13

iknow

8,358
12
41
68

answered Jan 31 '19 at 14:42

LCabaAres

15
1
10

create csv from xls using powershell

3 Answers3