Tag: CSV

Converting output from a NoSql database to joined and structured CSV in Powershell

I was tasked to export data from Microsoft Graph about users to CSV in order to build reports in Qlickview. The problem I had was that the user object in Microsoft Graph are polymorphic, meaning that the output we get are not required to have the same properties for each of the user object we…



How to handle multiple spreadsheets from Excel in Powershell

Background Most of us working with Powershell has encountered imports and exports of a CSV-file in Powershell, and most of the times this works seamlessly. This is because the Import-CSV function is a great way to get the single Excel sheet imported in to Powershell. However, I got a request to merge several spreadsheets from…



extensionAttributes – add values via Powershell + CSV file

It is common to have one or multiple extensionAttributes in an Azure AD environment for use with Intune for example. These extensionAttributes can be handled in a couple of different ways when it comes to managing the values set for each of those. For simplicity I’ve created a Powershell script that can add values to…



Automating delimiter selection when working with Csv cmdlets

Recently I walked passed a collegue with an error on his Powershell console which peaked my interest. He quickly noted that he had chosen the wrong delimiter for the Csv he imported which resulted in errors in the code, I then jokingly said ”Why don’t you just use the ’Get-CsvDelimiter’ cmdlet?” and we had a…