none
Export-csv output maximum row size RRS feed

  • Question

  • Hi all. May I know the maximum row size that can output to .csv using 'export-csv'??

    Tuesday, September 2, 2014 7:55 AM

All replies

  • There's no limit on writing to a CSV file.

    You can try:

    # max rows to export to CSV:
    $i=0
    While ($true) { #Forever
        $i++
        $i
        "Some text" | Export-Csv -Path .\test12.csv -Append -NoTypeInformation
    }

    until you run out of disk space, which may take a while. A million lines using the above script makes a 5 BM file..

    Now reading it back is an entirely different story. Try Delimit..


    Sam Boutros, Senior Consultant, Software Logic, KOP, PA http://superwidgets.wordpress.com (Please take a moment to Vote as Helpful and/or Mark as Answer, where applicable)


    • Edited by Sam Boutros Wednesday, September 3, 2014 9:54 AM
    Wednesday, September 3, 2014 8:40 AM