I would guess that you need to replace:

$OutputObj | Add-Member -MemberType NoteProperty -Name DriveName -Value $DriveSize.Name

$OutputObj | Add-Member -MemberType NoteProperty -Name DriveSizeTotal -Value $DriveSize.Size

$OutputObj | Add-Member -MemberType NoteProperty -Name DriveSizeFree -Value $DriveSize.FreeSpace

with something like (NOTE: only partially tested):

$DriveNumber = 1

foreach ($Drive in $DriveSize)

{

$driveNameTitle = "DriveName_$DriveNumber"

$OutputObj | Add-Member -MemberType NoteProperty -Name $driveNameTitle -Value $Drive.Name

$driveSizeTotalTitle = "DriveSizeTotal_$DriveNumber"

$OutputObj | Add-Member -MemberType NoteProperty -Name $driveSizeTotalTitle -Value $Drive.Size

$driveSizeFreeTitle = "DriveSizeFree_$DriveNumber"

$OutputObj | Add-Member -MemberType NoteProperty -Name $driveSizeFreeTitle -Value $Drive.FreeSpace

$DriveNumber += 1

}

As for the "2.49952E+11" issue, I believe that it is a display in spreadsheet issue i.e. change the cell's format.

HTH!!!