Inport and format a very large .csv file

[AussieExcelUser]

I am stuck trying to resolve an issue that I perceive to be a problem that could be solved with a macro.

I need to alter the format of a.txt file in Excel so that it can be inported into another program (Surpac).

The .txt file needs to be imported into Excel, where it will come in as a single row .csv import.
The .txt file is over 1gb in size, so the method I would normally use in excel isn’t adequate as there aren’t enough columns/rows to place the data in excel.

The change that I need to make is to import the large file into Excel as a manageable .csv (can it be split up?) and then change the single row of data into rows of three columns.

So basically I need to take the first three values that are seperated by commas and insert them into seperate columns, then the next three values on another row into the same columns and repeat until all values are included.

I have attached a (small) sample of the file I need to repair labelled "errant data" and a sample of what I need to achieve, "corrected data".

Any suggestions would be appreciated.

correct data.txterrant data.txt

[watersev]

hi AussieExcelUser, a bit of Googling and here is the option to split it to a chunks of any size you want. Link: http://www.freewaregenius.com/how-to...of-lines-rows/
As soon as it is done the result you want can be achieved using VB and Excel

[AussieExcelUser]

Thanks very much for the assistance Watersev, GSplit worked a treat. All files now split imported and saved, I ended up with just under 37 million rows with 3 columns of data!