[Closed] EXCEL gurus in the room?

I would use Python to do this

https://dzone.com/articles/splitting-csv-files-in-python

Wordpad?

If it is a one off I would just do it in NotePad++ manually.

Edit

Depends how you want to split it. If it's by rows, then any text editor should do it.
If by columns, then I'd import it into Google Sheets or just use Excel on the big file.

A huge csv file that needs splitting down so you can handle it you say? This isn't track and trace details for the 615k people pinged this week is it?

How huge is huge? Excel can handle pretty mahoosive files these days.

To not answer your question, I’ve never enjoyed the way excel likes to mess with the data in .csv files so I’d suggest importing to a database table instead.

Try this https://www.splitcsv.com/ but please be aware that the data in the file will be out of your control and my not be secure.

Notepad++ cannot open files that are larger than 2GB so that may be an issue.

Apropos of nothing both Notepad++ and Wordpad may not be suitable for this as it's possible to have a CR or CRLF in a CSV file (embedded in quotes) and this can cause a problem when working in text editors.

Install the x64 version of Excel and stop fannying about. (-:

Failing that,

If it helps your googling any, a CSV is just a text file. So you're not looking for a CSV splitter per se, you're simply looking for something that can slice text files.

Are you opening the file from within Excel (Data/From text csv) rather than double clicking on the file.  That can make a huge difference in Excel's ability to open it

Data > Manage Model
and then once in the model manager > Add data from other sources > your CSV

(or there abouts)

Import the CSV into a datamodel, which i think wont have the same limitations as the main sheet.
Then excel should connect into the model and you can get at it as a pivot table.