How to configure the splitted files to open them succesfully?

P

Penny

New member
I tried to split a CSV file to two pieces of files. But I can not open them. I want to know how to configure to ensure I can open them with such as Microsoft Excel?
1760505081688.webp
 
Solution
gdgsupport
By default, GSplit produces binary parts meant to be recombined using GSplit’s Self-Uniting feature — not opened directly.
That’s why Excel can’t open the resulting files — they’re not valid standalone CSVs.

Here’s how to configure GSplit so you get split CSV files that you can open individually in Excel:

Step-by-step guide

  1. Open GSplit
    Start the program and select your source CSV file.
  2. Under the “Type of Split” tab, select “Blocked Pieces” (not “Disk-Spanned Pieces”).

    Still in the “Type of Split”tab:
    • Choose “Split after line break (CR/LF)” or “Split after nth occurrence of pattern”.
      This ensures that each split happens at the end...
Sort by date Sort by votes
By default, GSplit produces binary parts meant to be recombined using GSplit’s Self-Uniting feature — not opened directly.
That’s why Excel can’t open the resulting files — they’re not valid standalone CSVs.

Here’s how to configure GSplit so you get split CSV files that you can open individually in Excel:

Step-by-step guide

  1. Open GSplit
    Start the program and select your source CSV file.
  2. Under the “Type of Split” tab, select “Blocked Pieces” (not “Disk-Spanned Pieces”).

    Still in the “Type of Split”tab:
    • Choose “Split after line break (CR/LF)” or “Split after nth occurrence of pattern”.
      This ensures that each split happens at the end of a line, not in the middle of one.

      You can choose by:
      • Size (e.g., 50 MB per piece), or
      • Number of lines (e.g., 100,000 lines per piece).
  3. Disable GSplit Tags
    • Go to “Additional Options” (the small wrench icon).
      Check: Do not add GSplit tags to piece files. GSplit normally adds binary tags to each piece for reassembly. Disabling this makes each split file a clean, standalone text file that Excel can open.

    ⚠️ Note: Once this option is enabled, you cannot rejoin the files using GUnite — but that’s fine if you just want to open them separately.

  4. Keep the CSV Header in Each File
    In the same “Additional Options”window:
    Check Insert additional header to pieces
    Choose: Copy all data prior to the first occurrence of line. This copies the first line (the column headers) from your original CSV into every split file. That way, each part opens in Excel with proper headers.
  5. Set Output File Names
    • Open the “Destination” tab. Choose where to save your split files.
      Use a file name pattern like: mydata_part#.csv
      The # will be replaced automatically by the part number (e.g., mydata_part1.csv).
  6. Start Splitting
    Click “Split!” to start the process.
    GSplit will create several .csv files like:
    mydata_part1.csv
    mydata_part2.csv
    mydata_part3.csv
 
Upvote 0 Downvote
Solution
You must log in or register to reply here.
Back
Top