Skip to content
KernoHelp Center
    Open Kerno
    Help CenterImporting & Exporting DataSplit a large BOM file

    Importing & Exporting Data

    Split a large BOM file

    Split a BOM file when it has more than 2,000 rows. That's the limit you'll meet first: a BOM file runs about 60 to 85 bytes a row, so 2,000 rows is under 200…

    1 min readUpdated November 10, 2026

    On this page (4)
    • The rule
    • Split the file
    • Check the result
    • Related articles

    Split a BOM file when it has more than 2,000 rows. That's the limit you'll meet first: a BOM file runs about 60 to 85 bytes a row, so 2,000 rows is under 200 KB, far below the 5 MB size limit.

    The rule

    Every line of one BOM stays in the same file. Rows with the same product, variant and batch size form one BOM, and a second file for a product that already has a BOM makes the next version.

    Split the file

    1. Sort the file by product.
    2. Cut at a row where the product changes.
    3. Copy the header row to the top of each new file.
    4. Import the files one at a time.

    Check the result

    Open BOMs. You should see one draft for each product at v1.0. A product with two drafts was split across files.

    BOMs with one draft for each product (view larger)

    Related articles

    • My BOM came in as two versions
    • What you can import, and in what order
    More in Importing & Exporting Data

    Still need a hand?

    Our support team is here when you need a person.

    Contact support

    In this guide

    • The rule
    • Split the file
    • Check the result
    • Related articles

    Related guides

    • Export your data
    • Import materials from a spreadsheet
    • Move your business into Kerno
    • What you can import, and in what order
    © 2026 Kerno, Inc. All rights reserved
    Privacy Policy (opens in a new tab)Terms of Service (opens in a new tab)Cookies (opens in a new tab)