Have a ginormous CSV file with a bad line in it? Use this rather than some stupid program like excel which will take 5 minutes to open the file and then only gives you access to a small portion of it.

badlines.pl

#!/usr/bin/perl

open (FOO, "file_with_bad_line.csv") ||
    die "ERROR Unable to open test: $!\n";

open (BAR, ">badlines.csv");

$rowcount=0;
while (<FOO>) { 
  $rowcount++;

  if ($rowcount == 1448571){
  	print BAR $_,"\n";
	}	
}
close FOO;
close BAR;