ConvertIntoCSV.ps1

<#
    .SYNOPSIS
    Converts files to CSV, from either JSON or Excel
 
    .DESCRIPTION
    Target either a JSON or Excel file and it will be converted to the CSV format. Note: The Excel file works only if there is a sheet named `Sheet1`
 
    .EXAMPLE
    Convert-IntoCSV C:\Temp\testData.xlsx
 
    .EXAMPLE
    Convert-IntoCSV C:\Temp\testData.json
#>

function Convert-IntoCSV {
    param(
        $Path
    )

    # Needs test-path
    # Needs requires for ImportExcel
    $ext = [System.IO.Path]::GetExtension($path)

    switch ($ext) {
        '.json' {$fileContents = Get-Content $Path | ConvertFrom-Json}
        '.xlsx' {$fileContents = Import-Excel -Path $Path}
    }

    $fileContents | ConvertTo-Csv -NoTypeInformation
}