{"id":703,"date":"2026-09-23T23:11:21","date_gmt":"2026-09-23T14:11:21","guid":{"rendered":"https:\/\/jim-jin.com\/?p=703"},"modified":"2026-10-08T09:10:02","modified_gmt":"2026-10-08T00:10:02","slug":"csv%e3%82%92%e6%8c%87%e5%ae%9a%e8%a1%8c%e6%95%b0%e3%81%a7%e5%88%86%e5%89%b2%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95%ef%bd%9c%e8%a6%8b%e5%87%ba%e3%81%97%e3%82%92%e6%ae%8b%e3%81%97%e3%81%a6%e5%8f%96","status":"publish","type":"post","link":"https:\/\/jim-jin.com\/en\/posts\/703","title":{"rendered":"Split CSV Files by Row Count | Keep Headers for Import"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Have you tried importing a CSV and received &#8220;The maximum number of records per import has been exceeded&#8221;?<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Growing product, customer, or sales CSVs may exceed an import system&#8217;s limits. Splitting them into a specified number of records per file lets you import in several batches.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Simply cutting a file can remove headers from later parts or create missing and duplicated records.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>For import files, align three things: data records per file, headers in each file, and the destination format.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This article explains splitting CSVs by row count while preserving headers with JIM-JIN&#8217;s Excel \/ CSV Merge and Split Tool.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What does splitting by row count do?<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/jim-jin.com\/en\/wp-content\/uploads\/english-art-20261008\/diagram-703-1.svg\" alt=\"Split CSV files by row count\" width=\"1200\" height=\"675\" loading=\"lazy\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">It divides CSV data from the beginning into files containing a fixed number of records.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, splitting 2,500 records into batches of 1,000 produces:<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Output file<\/th><th>Included records<\/th><th>Record count<\/th><\/tr><\/thead><tbody><tr><td>First file<\/td><td>Records 1\u20131,000<\/td><td>1,000 records<\/td><\/tr><tr><td>Second file<\/td><td>Records 1,001\u20132,000<\/td><td>1,000 records<\/td><\/tr><tr><td>Third file<\/td><td>Records 2,001\u20132,500<\/td><td>500 records<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Adding headers to each file gives every batch the same field structure.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">It is normal for the final file to contain fewer records. Do not add blank rows to fill it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This method suits tasks such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Import 1,000 records per batch to meet a limit<\/li>\n\n\n\n<li>Import a large product list in several batches<\/li>\n\n\n\n<li>Check import results using smaller files<\/li>\n\n\n\n<li>Narrow down the batch containing an error<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">However, <strong>splitting by row count does not produce equal file sizes.<\/strong> A CSV with long descriptions can be large even when it contains only 1,000 records.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/jim-jin.com\/en\/wp-content\/uploads\/english-art-20261008\/diagram-703-2.svg\" alt=\"A consistent header in every split file\" width=\"1200\" height=\"675\" loading=\"lazy\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Three things to check before splitting<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1. Does the import limit include the header?<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/jim-jin.com\/en\/wp-content\/uploads\/english-art-20261008\/diagram-703-3.svg\" alt=\"Count header rows separately\" width=\"1200\" height=\"675\" loading=\"lazy\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Even if the destination says &#8220;up to 1,000 rows per file&#8221;, check how those rows are counted.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Destination requirement<\/th><th>How to choose the data-record count<\/th><\/tr><\/thead><tbody><tr><td>Up to 1,000 data records<\/td><td>1,000 data records plus one header row<\/td><\/tr><tr><td>Up to 1,000 table rows including the header<\/td><td>999 data records plus one header row<\/td><\/tr><tr><td>Up to 5 MB per file<\/td><td>Check saved file size as well as row count<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">When JIM-JIN treats the first row as field names, the specified count excludes the header. Enabling headers in each output adds a header row to every file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>&#8220;1,000 rows&#8221; and &#8220;1,000 records&#8221; may differ, so follow the destination&#8217;s explanation.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Line breaks within cells can also make physical line counts differ from record counts, as explained below.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Does the original CSV&#8217;s first row contain headers?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Headers are field names such as &#8220;Product code&#8221;, &#8220;Product name&#8221;, and &#8220;Quantity.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, the following CSV has a header.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Product code<\/th><th>Product name<\/th><th>Quantity<\/th><\/tr><\/thead><tbody><tr><td>00123<\/td><td>Pen<\/td><td>10<\/td><\/tr><tr><td>00045<\/td><td>Notebook<\/td><td>5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A CSV starting directly with values such as &#8220;00123&#8221;, &#8220;Pen&#8221;, and &#8220;10&#8221; has no header.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Treating a headerless CSV&#8217;s first row as field names misidentifies the first record as a header. Inspect the initial data after loading.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">3. Do encoding and column order match the destination?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Splitting a CSV into smaller files cannot fix a format the destination rejects.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check these requirements before splitting.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Are headers required or prohibited?<\/li>\n\n\n\n<li>Are field names and column order specified?<\/li>\n\n\n\n<li>Is UTF-8, Shift_JIS, or another encoding required?<\/li>\n\n\n\n<li>Is UTF-8 with or without BOM required?<\/li>\n\n\n\n<li>Is a specific delimiter, such as a comma, required?<\/li>\n\n\n\n<li>Are required fields nonempty?<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If a sample import CSV is provided, compare its headers and column order.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Split a CSV by row count with JIM-JIN<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">JIM-JIN&#8217;s Excel \/ CSV Merge and Split Tool can split by a specified count and save each part with field names.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Output files are packaged in a ZIP for downloading and extraction.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Here is how to use <strong>The following example splits a CSV with headers into batches of 1,000 data records.<\/strong> We will use that example.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1: Choose splitting and add the CSV<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open the tool and choose &#8220;Split.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Select the CSV or drag and drop it into the indicated area.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Processing on your computer is the default. Server processing uploads files, so review the on-screen guidance and your organization&#8217;s data-handling rules before choosing it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Keep the original so you can compare it with the split files.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2: Check encoding and first-row handling<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After adding the CSV, check that Japanese text and column boundaries are correct.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For a CSV with headers, treat the first row as field names.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check these three points.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Field names such as &#8220;Product code&#8221; and &#8220;Product name&#8221; appear as headers<\/li>\n\n\n\n<li>Japanese text is not garbled<\/li>\n\n\n\n<li>Values appear in their intended columns<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">If text or columns are wrong, review input encoding and delimiters before proceeding.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3: Choose &#8220;By specified row count&#8221;<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Select splitting by a specified row count.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Enter the number of data records per file. For this example, enter &#8220;1000.&#8221;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the destination allows 1,000 rows including the header, adjust to 999 data records or otherwise follow its counting method.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4: Enable headers in every output file<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Enable &#8220;Include field names in every file&#8221; to add headers to all split CSVs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Check both treating the source first row as headers and including headers in each output.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For example, splitting four data records into batches of two produces:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>First output CSV<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Product code<\/th><th>Product name<\/th><th>Quantity<\/th><\/tr><\/thead><tbody><tr><td>00123<\/td><td>Pen<\/td><td>10<\/td><\/tr><tr><td>00045<\/td><td>Notebook<\/td><td>5<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Second output CSV<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>Product code<\/th><th>Product name<\/th><th>Quantity<\/th><\/tr><\/thead><tbody><tr><td>00067<\/td><td>Sticky notes<\/td><td>8<\/td><\/tr><tr><td>00089<\/td><td>File<\/td><td>3<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">The second CSV also has a header, so both files have the same structure for import.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the destination requires no header, choose not to output field names. Follow its specification.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5: Choose CSV and review output requirements<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Choose CSV as the save format when preparing import files.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Match encoding, delimiter, line endings, and UTF-8 BOM settings to the destination.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Settings convenient for Excel may differ from those accepted by the import system. Prioritize the destination&#8217;s guidance.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 6: Review the preview and save the split files<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Review output count, initial records, and warnings before running. Server previews cover only an initial portion, so also inspect saved files.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the preview is correct, run the split and save the result ZIP.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Extract the ZIP and inspect its CSVs. If the destination cannot import ZIPs, select the extracted CSV files.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Check record counts, headers, and boundaries afterward<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Inspect output files before importing them.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Does the total record count match the original?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If the source has 2,500 data records, the split files should also total 2,500.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For batches of 1,000, 1,000, and 500, the total is:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1,000 + 1,000 + 500 = 2,500 records<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Do not include added header rows in the data-record count.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Does every file have the correct header?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check later CSVs as well as the first for identical headers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Field order must also match.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check that headers have not appeared inside the data. Splitting alone does not remove repeated headers already embedded in the source.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Are records missing or duplicated at file boundaries?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Compare the first file&#8217;s last record and the next file&#8217;s first record with the original CSV.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Product codes or reference numbers make records easier to identify.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Identifiers are not necessarily sequential. Compare the same source positions rather than checking numerical sequence alone.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">CSV row counts are not always counts of line breaks<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Line breaks within cells need particular care when splitting CSVs.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A note or product description with a line break can make one record span several physical lines.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">RFC 4180, which describes a common CSV format, permits line breaks inside double-quoted fields.<a href=\"https:\/\/www.rfc-editor.org\/rfc\/rfc4180.html\">RFC 4180: CSV format<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Cutting mechanically at text line breaks can split a single record in the middle.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Use a CSV-aware method that handles quoted fields and embedded line breaks.<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">&#8220;1,000 data records&#8221; in this article means 1,000 parsed CSV records, not necessarily 1,000 lines in a text editor.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What to check if split files still cannot be imported<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">An error occurs even though record counts are within the limit<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Also check the file-size limit.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Fewer rows normally reduce size, but the characters per record determine actual file size.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">JIM-JIN also offers splitting by approximate file size. This is an option for size limits, but verify final sizes after saving because the target is approximate.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Japanese text is garbled<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check whether input was read correctly and output encoding matches the destination.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Splitting does not restore already damaged characters. Consider exporting again from the source system if the original CSV is damaged.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Product codes lose leading zeros<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When verifying or editing split files in spreadsheet software, check that product codes and postal codes are not imported as numbers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">CSV does not preserve cell display formats. The destination must also treat the relevant columns as text.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check values such as &#8220;00123&#8221; before splitting, afterward, and after import.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Only later files fail to import<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Check that every CSV starts with a header and has the same column structure as the first.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Also check any destination setting such as &#8220;Treat the first row as headers.&#8221;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Details of the same order end up in different files<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Splitting by fixed count does not guarantee that all details sharing an order number remain in one file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">To keep an order or customer&#8217;s data together, consider a method such as splitting by the values of a selected field.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If one group itself exceeds the import limit, check the destination system&#8217;s supported approach.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Points to consider when importing split CSVs<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Record how far you have imported to help prevent duplicate registration.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th>File<\/th><th>Import status<\/th><th>Check details<\/th><\/tr><\/thead><tbody><tr><td>First CSV<\/td><td>Done<\/td><td>Imported record count checked<\/td><\/tr><tr><td>Second CSV<\/td><td>Error<\/td><td>Import result under review<\/td><\/tr><tr><td>Third CSV<\/td><td>Not yet run<\/td><td>Run after reviewing the second file<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">An import error does not always mean no records were saved. Some systems save a portion of the data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check import history and error reports before retrying.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Use filenames that make order clear. Equal-width numbering such as &#8220;001&#8221;, &#8220;002&#8221;, and &#8220;003&#8221; preserves recognizable order when sorted.<\/p>\n\n\n\n<div class=\"swell-block-button -size-l is-style-btn_normal\"><a href=\"https:\/\/jim-jin.com\/en\/excel-csv-split\" class=\"swell-block-button__link\"><span>Excel \/ CSV Merge and Split Tool (Free)<\/span><\/a><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Frequently asked questions<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Can I split into 1,000-record files while keeping headers?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Yes. Treat the source first row as field names, select splitting by count with 1000, and enable field names in every output file.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Each file will contain at most 1,000 data records plus one header row.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Is it a problem if the final file contains fewer rows?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The final file contains the remainder when the total is not divisible by the batch size. This is normal and usable unless the destination specifies a minimum count.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Can I add headers to a headerless CSV?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Preserving headers in each output uses the source CSV&#8217;s headers. Correct field names cannot necessarily be inferred from a headerless CSV.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If the destination requires headers, add appropriate names in a CSV editor before splitting.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Does splitting also remove duplicates?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Splitting and deduplication are separate. Repeated source records remain in the output.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check or correct duplicates separately if needed.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Can I split without Excel?<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">JIM-JIN&#8217;s tool splits CSVs without opening them in Excel and copying and pasting sections.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For import files, configure headers and save format as well as the row count.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Have you tried importing a CSV and received &#8220;The maximum number of records per import has been exceeded&#8221;? Growing product, customer, or sales CSVs may exceed an import system&#8217;s limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":918,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"swell_btn_cv_data":"","footnotes":""},"categories":[19],"tags":[],"class_list":["post-703","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-csv-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"Have you tried importing a CSV and received &quot;The maximum number of records per import has been exceeded&quot;? Growing product, customer, or sales CSVs may exceed an import system&#039;s limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"\u4e8b\u52d9\u4eba\u904b\u55b6\u4e8b\u52d9\u5c40\"\/>\n\t<meta name=\"msvalidate.01\" content=\"743da3919f7a476585593d5a05a21adf\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/jim-jin.com\/en\/posts\/703\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"JIM-JIN | Online Tools for Everyday Work - Free tools for CSV, Excel, images and text\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work\" \/>\n\t\t<meta property=\"og:description\" content=\"Have you tried importing a CSV and received &quot;The maximum number of records per import has been exceeded&quot;? Growing product, customer, or sales CSVs may exceed an import system&#039;s limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/jim-jin.com\/en\/posts\/703\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/07\/Gemini_Generated_Image_7u5jq37u5jq37u5j-1.png\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/07\/Gemini_Generated_Image_7u5jq37u5jq37u5j-1.png\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-09-23T14:11:21+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-10-08T00:10:02+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Have you tried importing a CSV and received &quot;The maximum number of records per import has been exceeded&quot;? Growing product, customer, or sales CSVs may exceed an import system&#039;s limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/07\/Gemini_Generated_Image_7u5jq37u5jq37u5j-1.png\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#blogposting\",\"name\":\"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work\",\"headline\":\"Split CSV Files by Row Count | Keep Headers for Import\",\"author\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/author\\\/dcm83491#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#organization\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/wp-content\\\/uploads\\\/english-art-20261008\\\/article-703.svg\",\"width\":1200,\"height\":675,\"caption\":\"Split CSV Files by Row Count | Keep Headers for Import\"},\"datePublished\":\"2026-09-23T23:11:21+09:00\",\"dateModified\":\"2026-10-08T09:10:02+09:00\",\"inLanguage\":\"en-US\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#webpage\"},\"articleSection\":\"CSV \\\/ Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media#listItem\",\"name\":\"Media\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media#listItem\",\"position\":2,\"name\":\"Media\",\"item\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media\\\/csv-excel#listItem\",\"name\":\"CSV \\\/ Excel\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media\\\/csv-excel#listItem\",\"position\":3,\"name\":\"CSV \\\/ Excel\",\"item\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media\\\/csv-excel\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#listItem\",\"name\":\"Split CSV Files by Row Count | Keep Headers for Import\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media#listItem\",\"name\":\"Media\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#listItem\",\"position\":4,\"name\":\"Split CSV Files by Row Count | Keep Headers for Import\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/category\\\/media\\\/csv-excel#listItem\",\"name\":\"CSV \\\/ Excel\"}}]},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#organization\",\"name\":\"JIM-JIN | Online Tools for Everyday Work\",\"description\":\"Free tools for CSV, Excel, images and text\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/\\u30b9\\u30af\\u30ea\\u30fc\\u30f3\\u30b7\\u30e7\\u30c3\\u30c8-2026-09-06-16.54.44.png\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703\\\/#organizationLogo\"},\"image\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703\\\/#organizationLogo\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/author\\\/dcm83491#author\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/author\\\/dcm83491\",\"name\":\"\\u4e8b\\u52d9\\u4eba\\u904b\\u55b6\\u4e8b\\u52d9\\u5c40\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#authorImage\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/wp-content\\\/uploads\\\/ultimatemember\\\/1\\\/profile_photo.jpg?1792563623\",\"width\":96,\"height\":96,\"caption\":\"\\u4e8b\\u52d9\\u4eba\\u904b\\u55b6\\u4e8b\\u52d9\\u5c40\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#webpage\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703\",\"name\":\"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work\",\"description\":\"Have you tried importing a CSV and received \\\"The maximum number of records per import has been exceeded\\\"? Growing product, customer, or sales CSVs may exceed an import system's limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/author\\\/dcm83491#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/author\\\/dcm83491#author\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/wp-content\\\/uploads\\\/english-art-20261008\\\/article-703.svg\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703\\\/#mainImage\",\"width\":1200,\"height\":675,\"caption\":\"Split CSV Files by Row Count | Keep Headers for Import\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/posts\\\/703#mainImage\"},\"datePublished\":\"2026-09-23T23:11:21+09:00\",\"dateModified\":\"2026-10-08T09:10:02+09:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/\",\"name\":\"JIM-JIN | Online Tools for Everyday Work\",\"description\":\"Free tools for CSV, Excel, images and text\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/jim-jin.com\\\/en\\\/#organization\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work","description":"Have you tried importing a CSV and received \"The maximum number of records per import has been exceeded\"? Growing product, customer, or sales CSVs may exceed an import system's limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later","canonical_url":"https:\/\/jim-jin.com\/en\/posts\/703","robots":"max-image-preview:large","keywords":"","webmasterTools":{"msvalidate.01":"743da3919f7a476585593d5a05a21adf","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/jim-jin.com\/en\/posts\/703#blogposting","name":"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work","headline":"Split CSV Files by Row Count | Keep Headers for Import","author":{"@id":"https:\/\/jim-jin.com\/en\/author\/dcm83491#author"},"publisher":{"@id":"https:\/\/jim-jin.com\/en\/#organization"},"image":{"@type":"ImageObject","url":"https:\/\/jim-jin.com\/en\/wp-content\/uploads\/english-art-20261008\/article-703.svg","width":1200,"height":675,"caption":"Split CSV Files by Row Count | Keep Headers for Import"},"datePublished":"2026-09-23T23:11:21+09:00","dateModified":"2026-10-08T09:10:02+09:00","inLanguage":"en-US","mainEntityOfPage":{"@id":"https:\/\/jim-jin.com\/en\/posts\/703#webpage"},"isPartOf":{"@id":"https:\/\/jim-jin.com\/en\/posts\/703#webpage"},"articleSection":"CSV \/ Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/jim-jin.com\/en\/posts\/703#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/#listItem","position":1,"name":"Home","item":"https:\/\/jim-jin.com\/en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/category\/media#listItem","name":"Media"}},{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/category\/media#listItem","position":2,"name":"Media","item":"https:\/\/jim-jin.com\/en\/posts\/category\/media","nextItem":{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/category\/media\/csv-excel#listItem","name":"CSV \/ Excel"},"previousItem":{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/category\/media\/csv-excel#listItem","position":3,"name":"CSV \/ Excel","item":"https:\/\/jim-jin.com\/en\/posts\/category\/media\/csv-excel","nextItem":{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/703#listItem","name":"Split CSV Files by Row Count | Keep Headers for Import"},"previousItem":{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/category\/media#listItem","name":"Media"}},{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/703#listItem","position":4,"name":"Split CSV Files by Row Count | Keep Headers for Import","previousItem":{"@type":"ListItem","@id":"https:\/\/jim-jin.com\/en\/posts\/category\/media\/csv-excel#listItem","name":"CSV \/ Excel"}}]},{"@type":"Organization","@id":"https:\/\/jim-jin.com\/en\/#organization","name":"JIM-JIN | Online Tools for Everyday Work","description":"Free tools for CSV, Excel, images and text","url":"https:\/\/jim-jin.com\/en\/","logo":{"@type":"ImageObject","url":"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/09\/\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8-2026-09-06-16.54.44.png","@id":"https:\/\/jim-jin.com\/en\/posts\/703\/#organizationLogo"},"image":{"@id":"https:\/\/jim-jin.com\/en\/posts\/703\/#organizationLogo"}},{"@type":"Person","@id":"https:\/\/jim-jin.com\/en\/author\/dcm83491#author","url":"https:\/\/jim-jin.com\/en\/author\/dcm83491","name":"\u4e8b\u52d9\u4eba\u904b\u55b6\u4e8b\u52d9\u5c40","image":{"@type":"ImageObject","@id":"https:\/\/jim-jin.com\/en\/posts\/703#authorImage","url":"https:\/\/jim-jin.com\/en\/wp-content\/uploads\/ultimatemember\/1\/profile_photo.jpg?1792563623","width":96,"height":96,"caption":"\u4e8b\u52d9\u4eba\u904b\u55b6\u4e8b\u52d9\u5c40"}},{"@type":"WebPage","@id":"https:\/\/jim-jin.com\/en\/posts\/703#webpage","url":"https:\/\/jim-jin.com\/en\/posts\/703","name":"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work","description":"Have you tried importing a CSV and received \"The maximum number of records per import has been exceeded\"? Growing product, customer, or sales CSVs may exceed an import system's limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/jim-jin.com\/en\/#website"},"breadcrumb":{"@id":"https:\/\/jim-jin.com\/en\/posts\/703#breadcrumblist"},"author":{"@id":"https:\/\/jim-jin.com\/en\/author\/dcm83491#author"},"creator":{"@id":"https:\/\/jim-jin.com\/en\/author\/dcm83491#author"},"image":{"@type":"ImageObject","url":"https:\/\/jim-jin.com\/en\/wp-content\/uploads\/english-art-20261008\/article-703.svg","@id":"https:\/\/jim-jin.com\/en\/posts\/703\/#mainImage","width":1200,"height":675,"caption":"Split CSV Files by Row Count | Keep Headers for Import"},"primaryImageOfPage":{"@id":"https:\/\/jim-jin.com\/en\/posts\/703#mainImage"},"datePublished":"2026-09-23T23:11:21+09:00","dateModified":"2026-10-08T09:10:02+09:00"},{"@type":"WebSite","@id":"https:\/\/jim-jin.com\/en\/#website","url":"https:\/\/jim-jin.com\/en\/","name":"JIM-JIN | Online Tools for Everyday Work","description":"Free tools for CSV, Excel, images and text","inLanguage":"en-US","publisher":{"@id":"https:\/\/jim-jin.com\/en\/#organization"}}]},"og:locale":"en_US","og:site_name":"JIM-JIN | Online Tools for Everyday Work - Free tools for CSV, Excel, images and text","og:type":"article","og:title":"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work","og:description":"Have you tried importing a CSV and received &quot;The maximum number of records per import has been exceeded&quot;? Growing product, customer, or sales CSVs may exceed an import system's limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later","og:url":"https:\/\/jim-jin.com\/en\/posts\/703","og:image":"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/07\/Gemini_Generated_Image_7u5jq37u5jq37u5j-1.png","og:image:secure_url":"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/07\/Gemini_Generated_Image_7u5jq37u5jq37u5j-1.png","article:published_time":"2026-09-23T14:11:21+00:00","article:modified_time":"2026-10-08T00:10:02+00:00","twitter:card":"summary_large_image","twitter:title":"Split CSV Files by Row Count | Keep Headers for Import - JIM-JIN | Online Tools for Everyday Work","twitter:description":"Have you tried importing a CSV and received &quot;The maximum number of records per import has been exceeded&quot;? Growing product, customer, or sales CSVs may exceed an import system's limits. Splitting them into a specified number of records per file lets you import in several batches. Simply cutting a file can remove headers from later","twitter:image":"https:\/\/jim-jin.com\/wp-content\/uploads\/2026\/07\/Gemini_Generated_Image_7u5jq37u5jq37u5j-1.png"},"aioseo_meta_data":{"post_id":"703","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"focus_keyword":null,"additional_keywords":null,"truseo_locale":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_custom_url":null,"og_image_custom_fields":null,"og_image_url":null,"og_image_width":null,"og_image_height":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_image_url":null,"twitter_title":null,"twitter_description":null,"schema_type":"default","schema_type_options":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"breadcrumb_settings":null,"seo_analyzer_scan_date":null,"created":"2026-09-23 14:11:23","updated":"2026-10-08 07:58:57"},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jim-jin.com\/en\/\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jim-jin.com\/en\/posts\/category\/media\" title=\"Media\">Media<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/jim-jin.com\/en\/posts\/category\/media\/csv-excel\" title=\"CSV \/ Excel\">CSV \/ Excel<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tSplit CSV Files by Row Count | Keep Headers for Import\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/jim-jin.com\/en\/"},{"label":"Media","link":"https:\/\/jim-jin.com\/en\/posts\/category\/media"},{"label":"CSV \/ Excel","link":"https:\/\/jim-jin.com\/en\/posts\/category\/media\/csv-excel"},{"label":"Split CSV Files by Row Count | Keep Headers for Import","link":"https:\/\/jim-jin.com\/en\/posts\/703"}],"_links":{"self":[{"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/posts\/703","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/comments?post=703"}],"version-history":[{"count":5,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/posts\/703\/revisions"}],"predecessor-version":[{"id":1016,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/posts\/703\/revisions\/1016"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/media\/918"}],"wp:attachment":[{"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/media?parent=703"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/categories?post=703"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jim-jin.com\/en\/wp-json\/wp\/v2\/tags?post=703"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}