Read Excel Files in and Export CSVs

ExcelToCsv.ps1

# Source for xlsx files
$SourceFolder = 'C:\Folder'

# Destination folder for where the csvs will go
$DestFolder = 'C:\Folder\csv'

# Foreach Excel file, read it in and then export to CSV with the same name.
Get-ChildItem $SourceFolder -Filter *.xlsx | 
ForEach-Object { Import-Excel  $_.FullName | Export-Csv -Path ("{0}\{1}.csv" -f $DestFolder, $_.basename) -NoTypeInformation }