Taking part of CSV file

csvmicrosoft excel

I have a very large CSV file which I should analyze.
It's too big so I can't even open it in Excel or Stata.
So I want to take first few rows of it and explore the data, and then select necessary columns.

What I need it a software which take specific rows or columns of a csv file and output it as a separate file.
(e.g. I want to take Row 1~2500 or Column A,B,C and E)
Which can do this?

Best Answer

Use PowerShell.

PS > get-content \Large.csv -totalcount 2500 > Output.txt

enter image description here

You put \Large.csv as the Path to your Csv.

You put Output.txt as where you want the output to go say C:/Usere/Documents/Output.txt

enter image description here