EXCEL gurus in the room?
Hello – There’s a huge csv file that needs to be split to manageable chunks to open in excel.Posted 2 months ago
Can anyone recommend a safe free csv file splitter download not riddled with malware, viruses, etc ?
I would use Python to do this
Wordpad?Posted 2 months ago
If it is a one off I would just do it in NotePad++ manually.Posted 2 months ago
Depends how you want to split it. If it’s by rows, then any text editor should do it.Posted 2 months ago
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?Posted 2 months ago
How huge is huge? Excel can handle pretty mahoosive files these days.Posted 2 months ago
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.Posted 2 months ago
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.Posted 2 months ago
Install the x64 version of Excel and stop fannying about. (-:Posted 2 months ago
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.Posted 2 months ago
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 itPosted 2 months ago
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.Posted 2 months ago
Then excel should connect into the model and you can get at it as a pivot table.
You must be logged in to reply to this topic.