Avatar of ndr-itsolutions
ndr-itsolutions
 asked on

Using Powershell to Convert PFX to PEM

Hi,

I'm looking for a code snippet to do the following, I've created a bit of the code:

1. Read a list certificates - $certs gci c:\certs -include *.pfx -name
2. For each certificate name run the following command against it
     openssl pkcs12 -in <certificate name.pfx> -out <certificate name.pem> -nodes -password pass:<Password>
3. The password has to be extracted from an excel spreadsheet with two columns, certificate name and password.

I essentially want to be able to convert a load of pfx certs to pem certs and retrieve the associated passwords from a spreadsheet, the certificate name in the spreadsheet will be identical to the one in step 1

Any help appreciated.
Powershell

Avatar of undefined
Last Comment
Qlemo

8/22/2022 - Mon
Qlemo

Does it really need to be an Excel file? A CSV is much easier to handle.
ndr-itsolutions

ASKER
CSV is fine.
ASKER CERTIFIED SOLUTION
Qlemo

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Your help has saved me hundreds of hours of internet surfing.
fblack61