Tools

Website SEO AuditBroken Link CheckerSchema Markup ValidatorAI Crawler CheckerInternal Link CheckerKeyword Cannibalization CheckerKeyword ClusteringKeyword SuggestionsKeyword GapSEO Content CheckerReadability CheckerKeyword DensityAI HumanizerWriting Pattern IndicatorSearch Console Regex GeneratorLong-Tail Keyword IdeasSERP Snippet PreviewMeta Tag GeneratorURL Slug GeneratorRobots.txt GeneratorMeta Title GeneratorMeta Description GeneratorOpen Graph GeneratorTwitter Card GeneratorHTML Meta TagsMeta Tags for WordPressMeta Tags for ShopifyMeta Tags for BloggerMeta Tags for WebflowMeta Tags for ReactMeta Tags for Next.jsCore Web Vitals CheckerImage CompressorHTML MinifierCSS MinifierJavaScript MinifierVideo & Image SpecsQR Code GeneratorCurrency ConverterScientific CalculatorLoan / EMI CalculatorMortgage CalculatorCompound Interest CalculatorSalary to Hourly CalculatorAge CalculatorDate Difference CalculatorJSON Formatter & ValidatorWord CounterMerge PDFSplit PDFRotate PDFDelete PDF PagesRearrange PDF PagesExtract PDF PagesCrop PDFJPG to PDFPNG to PDFPDF to JPGPDF to PNGResize ImageCrop ImageImage ConverterWebP to JPGHEIC to JPGProfile Photo MakerImage to Text (OCR)MOV to MP4MKV to MP4WebM to MP4AVI to MP4MP4 to MP3Extract Audio from VideoTrim VideoMute VideoVideo to GIFResize VideoCompress VideoM4A to MP3WAV to MP3OGG to MP3AAC to MP3Split CSVSplit ExcelCSV to ExcelExcel to CSVExcel to XMLXML to ExcelXML to CSVXML to JSONJSON to CSV
Data & File toolsFree, no sign-upRuns in your browser

Split Excel

Turn one workbook into several files: one file per sheet, or a large sheet broken into parts by rows.

—Rows
—Columns

Your converted file will appear here.

What gets copied

Each new file keeps the cell values from the original sheet, with the header row repeated when splitting by rows. Formulas are saved as their calculated values, and formatting such as colours and merged cells isn’t carried over, so the result is a clean data file that imports reliably.

How to use the Split Excel: step by step

  1. Choose an Excel workbook.
  2. Choose to split into one file per sheet, or one sheet into parts by rows.
  3. Set the rows per file if splitting by rows.
  4. Split and download the files.

A real example

A CRM accepts imports of up to 5,000 rows, and your contacts sheet has 18,000. Split by 5,000 rows and you get four files, each with the header row, ready to import.

Tips for better results

  • The header row is repeated in every part when splitting by rows.
  • Formulas are saved as their calculated values.
  • Formatting such as colours isn’t copied.

More questions

Can I split a CSV?

Use Split CSV for CSV files.

Frequently asked questions

Is my file uploaded anywhere?

No. The file is read and converted by your own browser, so it never leaves your device. That makes it safe for customer lists, finances and other private data.

Which Excel formats are supported?

Modern .xlsx and .xlsm files, older .xls files and OpenDocument .ods spreadsheets. The split files are saved as .xlsx.

Are formulas kept?

Formulas are converted to their current values. That keeps each part self-contained, because formulas often refer to rows that end up in a different file.