View original (French)

Splitting a large CSV file

hovanes Posted messages 9 Status Membre -  
berrayahkamel Posted messages 175 Registration date   Status Membre Last intervention   -
Hello,

I have a .csv file that is way too large to be opened with Excel, and even with Notepad++
I'm looking for a way to split this file in two (with a script, for example).
If someone has any idea!

Thanks in advance!

Configuration: Windows XP / Firefox 3.6.22

7 réponses

Réponse 1 / 7
hovanes Posted messages 9 Status Membre
 
Well, I tried with Word Pad, it works, I can split the content of my file in two, but the problem is that it would be way too long to rewrite everything into two different Excel files, lol
So that’s not the solution yet
I tried your software, unfortunately it didn't work either :(
1
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Hello,

Why rewrite everything if you can split it into 2 CSV files?
eric
0
hovanes Posted messages 9 Status Membre
 
Hello, well when I open it with Word Pad, it appears as text. So not in tables. And I'm not going to bother filling in two Excel files based on the Word Pad file created.
0
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
Excel can open a CSV and distribute the values into the cells...
Then you can save them in XLS format if you wish
eric
0
Squall18 Posted messages 91 Registration date   Status Membre Last intervention   7
 
Absolutely, the process to follow is if you manage to open your file, you cut/paste half into a new CSV file
Then you can open both separately in Excel, it will recognize the columns (separation ";" normally)
Keep us updated :)

PS: In Excel 2007, there is a max of 1,048,576 rows, so splitting it in two should work.
0
hovanes Posted messages 9 Status Membre
 
Yes, that's exactly what I would like, but I can't even open the document with Excel!
0
Réponse 2 / 7
antipolis a Posted messages 17152 Status Membre 2 916
 
Subject [Abandoned] or [Resolved]?
1
Réponse 3 / 7
berrayahkamel Posted messages 175 Registration date   Status Membre Last intervention   64
 
Hello

The following software does the job

https://www.gdgsoft.com/gsplit/
1
Réponse 4 / 7
Squall18 Posted messages 91 Registration date   Status Membre Last intervention   7
 
Hi!

I've never encountered a CSV that Excel couldn't open (even though I work with files of several thousand rows...)

That said, it's possible to split a file into several pieces with XTremsplit, for instance, but that's more for transport (like big ISOs or something like that...)

In my opinion, it won't be possible to save your file in two distinct (and readable!) parts without having opened it.

One last thing, when this CSV was created, it was indeed open somewhere, right?

--
~#| Don't forgive: Life is a Game! |#~
0
Samkillah
 
If you exceed 1,048,576 lines, you can no longer open it with EXCEL; for Notepad++, the limit is a bit further, but the truth is that these are files that are difficult to manipulate, which is why it's useful to split them into several...
0
Réponse 5 / 7
scaravenger Posted messages 2691 Registration date   Status Membre Last intervention   625
 
If it's a csv file, it should normally be readable by WordPad or Microsoft Doc.
Otherwise, try this:
http://www.commentcamarche.net/download/telecharger-34067213-file-splitter
0
Réponse 6 / 7
antipolis a Posted messages 17152 Status Membre 2 916
 
I haven't tested it, but maybe a lead here:
https://www.generation-nt.com/reponses/couper-un-fichier-csv-entraide-737091.html

And here, a site that seems interesting to me:
http://frederic.sigonneau.free.fr/
0
Réponse 7 / 7
hovanes Posted messages 9 Status Membre
 
Thank you for your response!
Actually, it's a file that was extracted directly from a database, and it contains over a million rows. Apparently, it would work with Excel 2010, but I only have Excel 2007!
So that's why I can't open it.
-3