Large .csv files

Phillip Mathis · Post by **Phillip Mathis** » Mon Jul 08, 2013 2:59 pm

All,

Once again, the powers that be are dumping more and more data (1500 columns) into a .csv file. As you are aware, Excel cannot handle this much data. I only use a fraction of the data for analysis, but some of the information is past the 256th column.

Does anyone have any suggested programs that will allow me to sift out columns of data without corrupting the original file?

Post by **DPlotAdmin** » Mon Jul 08, 2013 6:36 pm

My best suggestion is to tell them to stop doing that

But a better suggestion might be to update Excel. Excel 2010 will work with 1,048,576 rows by 16,384 columns.

jsc · Post by **jsc** » Wed Jul 10, 2013 7:39 am

Not sure about this, but CSVFileView from Nirsoft might help you open the file, cut some columns, then resave what you need. From the developer, when I asked how many columns it could handle, "There is no official limitation for number of columns in CSVFileView. It depends on the 'ListView' control of Windows that is used to display the csv data."

Nirsoft is at www dot nirsoft dot net.

Phillip Mathis · Post by **Phillip Mathis** » Wed Jul 24, 2013 1:18 pm

I wish that I had that kind of power

They add sophisticated equipment to reduce operator workload, then add more equipment to increase capability. What happed to just aim and shoot.

jsc, I appreciate yor assitance. I will look at the link to see if it fits our needs.