How to Import Excel & CSV Cut Lists into a Nesting Optimizer

If you already have a parts list in Excel, Google Sheets, or exported from design software, manually re-entering every piece into a nesting optimizer wastes time and invites errors. Importing your cut list directly eliminates double data entry, reduces mistakes, and gets you to optimized cutting layouts faster.

Whether you're a cabinet maker with a spreadsheet from SketchUp OpenCutList, a fabricator with an export from CutList Plus, or a hobbyist tracking pieces in Excel—you can import that data directly into EZNESTING and start optimizing immediately.

This guide covers everything you need to know about importing spreadsheet data into a nesting optimizer: supported formats, required columns, automatic mapping, and tips for seamless imports.

EZNESTING accepts the most common spreadsheet formats:

CSV Files (.csv) - Universal format supported by all spreadsheet applications - Comma, semicolon, tab, or pipe-delimited (auto-detected) - Best for simple data without formatting - Export from Excel, Google Sheets, LibreOffice, or any database

Excel Files (.xlsx, .xlsm) - Modern Excel format (Excel 2007 and later) - Preserves formulas—calculated values are imported automatically - Multi-worksheet support—choose which sheet to import - Handles merged cells and complex formatting

What about older formats? If you have an older .xls file (Excel 97-2003), simply open it in Excel and save as .xlsx before importing. Google Sheets exports directly to both .csv and .xlsx formats.

Your spreadsheet needs specific columns for the import to work. The good news: EZNESTING auto-detects most column names, so you often don't need to change anything.

Required Columns (Sheet Materials) - Part Name — The name or identifier for each piece - Quantity — How many of this piece you need (defaults to 1 if missing) - Width — The width dimension of the piece - Length — The length dimension of the piece

Required Columns (Linear Materials) - Part Name — The name or identifier for each piece - Quantity — How many of this piece you need - Length — The length of the piece

Optional Columns - Thickness — Material thickness (useful for organizing by material) - Material — Material type or name (plywood, MDF, etc.) - Grain Direction — Whether the piece has a grain that must be aligned - Edge Banding — Which edges need banding (top, bottom, left, right) - Notes — Any additional notes or comments

Column Name Flexibility Don't worry if your columns are named differently. EZNESTING recognizes common variations:

Importing your cut list takes just a few clicks:

Step 1: Open the Import Dialog In EZNESTING, click the "Import CSV/Excel" button above your parts list. This opens the import dialog.

Step 2: Upload Your File Drag and drop your file onto the upload area, or click "Browse" to select it from your computer. EZNESTING automatically detects whether it's CSV or Excel.

Step 3: Select Worksheet (Excel only) If your Excel file has multiple worksheets, choose which one contains your cut list.

Step 4: Review Column Mapping EZNESTING attempts to match your column headers to the required fields. Review the mapping and adjust if needed. Green checkmarks indicate successful matches.

Step 5: Confirm Units The importer auto-detects whether your dimensions are in inches or millimeters. Verify this is correct, or override if needed.

Step 6: Preview and Import Review the preview showing your first few rows. Check for any validation warnings. Click "Import" to add the pieces to your project.

That's it! Your cut list is now ready for optimization.

EZNESTING uses intelligent detection to minimize manual setup:

Automatic Column Mapping The importer analyzes your column headers using: - Exact matching (case-insensitive) - Alias recognition (matching common variations) - Fuzzy matching (finding close matches)

Automatic Unit Detection Your measurement units are detected by: - Header indicators: "(mm)", "(in)", "(inches)" in column names - Value suffixes: dimensions ending in "mm", "in", or '"' - Fractional format: "24 1/2" indicates imperial measurements - Value ranges: typical imperial vs. metric dimension ranges

Fractional Inch Support Working in fractional inches? No problem. EZNESTING handles: - Standard fractions: 24 1/2, 12 3/4 - Hyphenated: 24-1/2, 12-3/4 - Unicode fractions: 24½, 12¾ - Mixed formats within the same file

EZNESTING is optimized to work with exports from common woodworking and design tools:

SketchUp OpenCutList The popular SketchUp extension exports cut lists in CSV format that imports directly into EZNESTING: 1. In SketchUp, generate your cut list with OpenCutList 2. Export as CSV 3. Import directly—column names are auto-recognized

CutList Plus CutList Plus fx exports are fully compatible: 1. Export your project from CutList Plus 2. Choose CSV or Excel format 3. Import into EZNESTING for nesting optimization

Cabinet Vision Cabinet Vision parts lists work seamlessly: 1. Export your parts list from Cabinet Vision 2. Save as Excel or CSV 3. Import for optimized nesting layouts

Other Software Any software that exports a parts list with dimensions will work. This includes: - 2020 Design - KCD Software - Mozaik - Google Sheets - Microsoft Excel - LibreOffice Calc

Before importing, EZNESTING validates your data and highlights potential issues:

Critical Errors (Block Import) - Missing required columns (part name, dimensions) - Non-numeric dimension values - Negative dimensions

Warnings (Import Continues) - Very small dimensions (< 0.1 inches) - Unusually large dimensions (> 1000 inches) - Zero or negative quantities - Missing optional fields

Row-by-Row Feedback The preview shows which rows have issues, so you can decide whether to: - Fix the data in your spreadsheet and re-upload - Proceed with import (valid rows are imported, invalid rows are skipped)

Validation Summary Before finalizing, you see a summary: - Total rows found - Rows that will import successfully - Rows with warnings - Rows with critical errors

Follow these best practices for trouble-free importing:

Format Your Spreadsheet - Put column headers in the first row - One piece per row (no merged cells in data) - Remove any summary rows or totals at the bottom - Keep dimensions as numbers (not text formatted as numbers)

Be Consistent with Units - Use the same unit throughout (don't mix inches and mm) - If using fractional inches, keep consistent format - Consider adding unit indicator to header: "Width (in)"

Clean Your Data - Remove blank rows between data - Delete any footer rows or notes below the data - Ensure quantities are whole numbers

Name Your Columns Clearly While auto-detection handles many variations, clear names help: - "Part Name" instead of "A" or "Column1" - "Width" instead of "X" or "Dim1" - "Quantity" instead of "Q" or "#"

Test with a Sample First For large lists, export a few rows first to test the import before uploading your entire cut list.

Can I import from Google Sheets? Yes! In Google Sheets, go to File > Download > either "Comma-separated values (.csv)" or "Microsoft Excel (.xlsx)". Then import that file into EZNESTING.

What if my columns aren't recognized? If auto-detection misses a column, you can manually map it in step 4 of the import process. Use the dropdown menus to assign each column to the correct field.

Can I import multiple worksheets at once? Currently, you select one worksheet per import. For multiple sheets, import them one at a time or combine them in your spreadsheet first.

Does it work with formulas? Yes! Excel formulas are evaluated, and the calculated result is imported. For example, if your length is "=A1*2", EZNESTING imports the calculated value.

What's the maximum file size? There's no strict limit, but files with thousands of rows may take longer to process. For very large files (5,000+ rows), consider splitting into smaller batches.

Can I undo an import? Yes. Use your browser's undo (Ctrl/Cmd + Z) immediately after import, or simply delete the imported pieces from your parts list.

What if my dimensions include unit text? EZNESTING strips common unit suffixes automatically. "24 inches", "24"", "24 in", and "24mm" are all parsed correctly.

Do I need to match the exact column order? No. Column order doesn't matter—only the column names (headers). Your spreadsheet can have columns in any order, and extra columns are simply ignored.

Here's what a properly formatted cut list looks like:

Simple Format ``` Part Name,Quantity,Width,Length Top Panel,1,24,48 Shelf,4,23.5,47.5 Side Panel,2,24,36 Back Panel,1,47.5,35 Drawer Front,4,6,22 ```

With Fractional Inches ``` Part Name,Quantity,Width,Length,Material Top Panel,1,24,48,Maple Plywood Shelf,4,23 1/2,47 1/2,Maple Plywood Side Panel,2,24,36,Maple Plywood Drawer Front,4,5 3/4,22,Maple Plywood ```

With All Optional Fields ``` Part Name,Quantity,Width,Length,Thickness,Material,Grain,Notes Top Panel,1,24,48,0.75,Maple Ply,Yes,Visible surface Shelf,4,23.5,47.5,0.75,Maple Ply,Yes,Adjustable Side Panel,2,24,36,0.75,Maple Ply,Yes,Left and right Back Panel,1,47.5,35,0.25,Maple Ply,No,Hidden ```

Copy any of these formats into a spreadsheet, modify with your own dimensions, and import into EZNESTING.

Importing your cut list from Excel or CSV is the fastest way to go from design to optimized cutting layout. No more re-typing dimensions, no more data entry errors, no more wasted time.

With EZNESTING, you can: - Import spreadsheets in seconds - Auto-detect columns and units - Work with files from any design software - Validate data before importing - Get optimized layouts immediately

Whether you have 10 pieces or 1,000, importing beats manual entry every time. Try it now with your existing cut list and see how much time you save.