Convert excel .xlsx to .csv using Powershell

Question

Hi All,

I am getting and excel report with file extension .xlsx and I want to convert the file to .csv using Powershell 

Can this be done ? I alreay tried but did not find any concrete way/method to do so

Please guide

---

Thanks in Advance, Jiniv Thakkar

Answer 1

Hi Jiniv Thakkar,

You could try the following PowerShell:

Function ExcelCSV ($File)

{

    $pwd = "C:\Users\Administrator.CONTOSO\Desktop"

    $excelFile = "$pwd\" + $File + ".xlsx"

    $Excel = New-Object -ComObject Excel.Application

    $Excel.Visible = $false

    $Excel.DisplayAlerts = $false

    $wb = $Excel.Workbooks.Open($excelFile)

    foreach ($ws in $wb.Worksheets)

    {

        $ws.SaveAs("$pwd\" + $File + ".csv", 6)

    }

    $Excel.Quit()

}

$FileName = "excel2"

ExcelCSV -File $FileName

Note: Don’t forget to change the file name and the location.

Best Regards,

Linda Zhang

---

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [e-mail]

Answer 2

Hi Linda,

I tried this and got the following error : 

class not registered com object 

Do I need to install office on server to run the script and over come the error ? 

---

Thanks in Advance, Jiniv Thakkar

Answer 3

Hi

My Suggestion would be you can use PSExcel option to achieve this without installing Office on the server.

https://github.com/RamblingCookieMonster/PSExcel

https://github.com/RamblingCookieMonster/PSExcel/issues/21

http://vipinvasudevan.blogspot.in/2014/03/powershell-script-to-convert-excel-file.html

Thanks,

Pons

Answer 4

Hi Jiniv Thakkar,

Yes, you should run this cmdlet on the server which has Excel application. Otherwise, we cannot use the Excel comObject.

Another workaround, you could try the following cmdlets.

https://blogs.technet.microsoft.com/pstips/2014/06/02/get-excel-data-without-excel/

Best Regards,

Linda Zhang

---

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact [e-mail]

Answer 5

It worked great for me, I am using this with Excel 2019.

I sometimes get the "frown" on 2019, never on 2016.