How to Convert XML to Excel Using PowerShell

Convert XML to Excel Using PowerShell

Last month, our monitoring vendor started dropping daily inventory exports as XML files onto a file share. Finance wanted them in Excel. For two weeks, someone on my team opened each file, copied nodes by hand, and pasted them into a workbook. It took an hour a day, and the numbers were wrong twice. I … Read more

How to Convert String to Path in PowerShell

Convert String to Path in PowerShell

Last month I inherited a file server cleanup script from a colleague who’d left the company. It read folder names from a CSV, glued them together with plain string concatenation, and then failed on half the rows. Some paths had double backslashes. Others had trailing spaces. A few used relative paths like ..\Archive that never resolved correctly. … Read more

How to Convert PDF to Word Using PowerShell?

Convert PDF to Word Using PowerShell

Last month, our HR team dumped 240 scanned policy PDFs on my desk. They needed each one as an editable Word document so they could update the 2026 wording. Opening each file by hand in Word would have eaten a full week. I wrote a short script instead. It finished in about twenty minutes while … Read more

How to Convert PNG to ICO Using PowerShell

Convert PNG to ICO Using PowerShell

I have lost count of how many times I have needed a favicon at short notice and ended up on some random online converter, uploading a company logo I probably shouldn’t be handing to a stranger’s server. It works, but it always feels wrong. The confusing part is that Windows has no built-in ICO cmdlet. … Read more

How to Find Folders by Partial Name Using PowerShell

Find a Folder by Partial Name Using PowerShell

When you know only part of a folder name—such as Finance, Archive, or Project-A—PowerShell can search a local drive, mapped drive, or file share and return the matching folder paths. The recommended approach is Get-ChildItem with -Directory, followed by a wildcard filter such as -like ‘*Finance*’. This is useful in IT administration when you need … Read more

Windows Terminal vs PowerShell: Which One to Use

Windows Terminal vs PowerShell

I’ve seen this confusion come up a lot in real admin work. Someone opens Windows Terminal, types a PowerShell command, and then assumes both tools are the same thing. They are not the same, and that difference matters when you build scripts, run admin tasks, or set up a better workflow. Once you understand it, … Read more

How to Get Folder Size in PowerShell Including Subfolders

Get the Size of Folder in PowerShell

A file server’s free space can disappear faster than expected. I have seen a small company’s D:\CompanyData drive fill up because old application logs, user exports, and archived project files kept growing unnoticed. The Windows folder Properties dialog works for one quick check, but it does not scale when you need to inspect multiple folders … Read more

How to Convert Boolean to Int in PowerShell

Convert Boolean to Int in PowerShell

When I build server inventory scripts, I often collect values such as whether BitLocker is enabled, a service is running, or a disk is online. PowerShell returns these values as Boolean data: $true or $false. That works well in an if statement, but it becomes a problem when a CSV file, database field, or API … Read more

PowerShell: Move Files from One Folder to Another If Not Exists

PowerShell Move Files from One Folder to Another If Not Exists

I’ve seen this problem a lot in file server cleanup work: one folder fills up with reports, and the destination folder already has some of those files. If you move everything blindly, you overwrite good files or create a messy duplicate situation. A simple PowerShell script solves it cleanly. You check whether each file already … Read more

100 PowerShell cmdlets download free

100 POWERSHELL CMDLETS E-BOOK

FREE Download an eBook that contains 100 PowerShell cmdlets with complete script and examples.