View original (French)

Splitting a large CSV file

hovanes Posted messages 9 Status Member -  
berrayahkamel Posted messages 175 Registration date   Status Member 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 answers

  1.
    hovanes Posted messages 9 Status Member
     
    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
    1. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      Why rewrite everything if you can split it into 2 CSV files?
      eric
      0
    2. hovanes Posted messages 9 Status Member
       
      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
    3. eriiic Posted messages 24581 Registration date   Status Contributor 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
    4. Squall18 Posted messages 91 Registration date   Status Member 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
    5. hovanes Posted messages 9 Status Member
       
      Yes, that's exactly what I would like, but I can't even open the document with Excel!
      0
  2. antipolis a Posted messages 17152 Status Member 2 917
     
    Subject [Abandoned] or [Resolved]?
    1
  4. Squall18 Posted messages 91 Registration date   Status Member 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
    1. 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
  6. scaravenger Posted messages 2691 Registration date   Status Member 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
  8. hovanes Posted messages 9 Status Member
     
    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