How to Merge, Split and Convert Excel and CSV Files

By the DocEpic team · Updated 10 November 2026 · 2 min read

Monthly reports from every branch to combine into one, a 50,000-row list too big for the system you upload it to, a CSV that turns phone numbers into 9.87E+09 when opened in Excel: these are everyday spreadsheet chores. This guide shows how to merge and split sheets properly and convert between formats without losing data.

Merge several files into one sheet

Merge Excel & CSV stacks several files — or every sheet of a workbook — into one sheet.

1. Open Merge Excel & CSV and add your files.
2. Choose how to line up the columns: by column name, so files with columns in a different order still match, or by position.
3. Tick Add a Source column to record which file each row came from, and Every sheet of each workbook if your data is spread over several sheets.
4. Save as Excel or CSV and download.

Split a big sheet

Many portals and email tools limit imports to a few thousand rows. Split Excel & CSV cuts a long sheet into files of a fixed number of rows, or into a number of equal parts. Every file gets the header row, and they download together as a ZIP.

CSV to Excel without broken numbers

Opening a CSV directly in Excel often mangles it: long numbers become 9.87E+09, codes like 007 lose their zeros, dates flip between formats. CSV to Excel converts it properly — numbers and dates become real Excel values while codes such as 007 stay as text — and makes the header row bold, frozen and filterable. Several CSVs can become one workbook with a sheet each.

Excel to CSV, and JSON

Excel to CSV saves a sheet, or every sheet, as CSV with the separator you need — comma, semicolon or tab — and an Excel-friendly encoding that keeps Hindi and other scripts readable. Choose Raw values for importing into other software and databases, or As shown to keep the formatting you see in Excel.

Developers and anyone with exported app data can use JSON to Excel & CSV: each record becomes a row and nested fields become columns such as address.city. Numbers longer than 15 digits, such as IDs, are kept as text so no digit is lost.

Questions people ask