A function that pulls your clipboard data as CSV and converts it to objects (try copying a block from Excel).

Get-ClipboardAsCsv.ps1

function Get-ClipboardAsCsv {
  param(
    [Parameter(Mandatory=$false)]
    [char]$Delimiter,
    [Parameter(Mandatory=$false)]
    [ValidateNotNullOrEmpty()]
    [string[]]$Header
  )
  [Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms") > $null
  $ms = [Windows.Forms.clipboard]::getdata([Windows.Forms.DataFormats]::CommaSeparatedValue)
  if($ms) {
    $sr = New-Object IO.StreamReader($ms)
    try {
    $Lines = while(!$sr.EndOfStream) {
      $sr.ReadLine()
    }
    $Lines | ?{![string]::IsNullOrEmpty($_) -and $_ -ne "`0"} | ConvertFrom-Csv @PSBoundParameters
    } finally {
      if($sr) {
        $sr.Close()
      }
    }
  }
}