Powershell import-csv not recognized

Question

I'm trying to make a bat file script that appends the information of a csv to another already existing csv file. I want to use the import-csv command, but I keep getting the error that says:

'import-csv' is not recognized as an internal or external command, operable program or batch file.

I was using Powershell 5.1, so I tried downloading and using Powershell Core 6. That isn't working either. Am I missing a library somewhere?

my code:

import-csv "tinyTesterB.csv"

pause

You're trying to run a built-in powershell.exe cmdlet inside cmd.exe — Compo
– Compo, Commented Feb 4, 2020 at 22:19

AdminOfThings · Accepted Answer · 2020-02-04 21:57:43Z

5

Inside of a bat file or in the cmd shell, you need to start PowerShell to gain access to its commands. Add the following to your bat file instead:

For Windows PowerShell:

Powershell.exe -Command "Import-Csv 'tinyTesterB.csv'"

For PowerShell Core:

Pwsh.exe -Command "Import-Csv 'tinyTesterB.csv'"

answered Feb 4, 2020 at 21:57

AdminOfThings

25.2k4 gold badges22 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

SaroyanDynamite Over a year ago

Thank you for explaining why this is the case. Do I need to add this prefix to every line? is there a way to make it so that I don't have to add it to every line?

AdminOfThings Over a year ago

I would create a .ps1 file with the Powershell commands. Then I would call the file Powershell.exe -File 'c:\file.ps1'

Collectives™ on Stack Overflow

Powershell import-csv not recognized

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related