# Import Data

URL: https://cutlistevo.com/guide/import

> Import parts and stock into Cutlist Evolution from CSV, OBJ, DXF or a spreadsheet.

Before you import any data, ensure that your number format are set correctly in the **Options** panel.

You cannot use notation (e.g. [ **'** ] or [ **"** ]) in your data, and you must use a single type of unit throughout.

Your browser will detect your locale and your thousands and decimal separators will be set accordingly. If you choose to use separators, please use the detected separators in your data.

Once the data has been parsed, it will be converted to use decimal separators as [ **.** ] and no thousand separators. Read more about [number format](/guide#number-format).

## Import CSV

CSV is a common format which can be exported from any spreadsheet software.

The CSV import method attempts to automatically recognise your column headers and match them to the correct fields. There are a few rules you need to follow to make the process work.

- You must have a separate sheet for stock and parts and import them individually - indicate which type you're importing using the radio buttons.
- Each sheet must have column headers, and they should be the top row of the sheet.
- Trim and banding must be in a single cell, separated by a comma (format is Y,N,Y,N for banding and 10,10,10,10 for trim). The order is L1, L2, W1, W2 - read more about [side references](/guide#side-references).
- Rotation expects 'L' for length (long side) horizontal and 'W' for width (short side) horizontal.
- Grain expects 'L' or 'W'. If grain is not provided, it will be assumed to be 'L' for the long side.

You do not have to use all of the available column headings if you don't use them.

The tool will try and automatically detect and map your column headings to the correct field - if this is not successful, you can manually map the columns.

After you've dropped your CSV file you will be shown a preview of the data. If it looks ok, click the **Import** button and the data will be imported to the **Inputs** panel.

## Import OBJ

Officially supported:

- Autodesk Fusion 360
- Shapr3D

OBJ files can be exported from the free and online versions of Fusion 360 and from all versions of Shapr3D.

First hide / remove any bodies you don't want to be included in the export, then export as OBJ.

### Options

**Create stock for all material & thickness variations** - this will create stock for each unique material and thickness combination. This is useful if you have multiple materials or thicknesses in your model.

**Exported from** - select the software you used to export the file. This is used to format the part names correctly and to help with duplicate detection.

### Supported Part Types

All parts in your model **must be cuboid** and **axis aligned**. If you have for example hollowed out a box to create a cabinet shape, then we won't be able to detect the individual parts.

### Drop the File

Then simply drop in the OBJ file and a preview of the data will be shown in the table. Not all parts will be shown in the list.

The length, width, thickness, name and material will be extracted from the file as supported by the software you're using.

### Precision

If using a decimal unit format, select an appropriate **precision** value. This can be useful if you need to clean up the precision of the export.

### Unit Conversion

If you need to convert the number format used in the exported file, select a value from the **Exported number format** and **New number format** dropdowns.

Shapr3D automatically converts to meters when exporting, so use the **Exported number format** dropdown to select 'Meters'.

Fusion can export with any number format, so select the unit you used in the export.

Both the rounding and original unit settings can be updated after the import, and will automatically update the table. Ensure the number format in the table look correct before importing.

### Detection of Part Names & Materials

When using Fusion, part **names** are detected from the body name.

**Materials** are defined using the 'appearance' functionality. If you have not set an appearance, material will not be set.

### Stock & Materials

For materials to work correctly, stock with the corresponding material must be created first in the **Inputs** panel. There is the option to add these stock automatically, which is offered as an option during the import process.

In Autodesk Fusion, materials are defined using the 'appearance' functionality.

### Thickness

Thickness is always assumed to be the smallest of the dimensions - if this is not the case, you may need to tweak these imported parts.

### Part Quantity Detection

The quantity of each part is detected based on identical dimensions, material and name. For Fusion, the name is detected from the body name. For example 'Body1' and 'Body1:1' will be considered as identical names. If you're using a colon plus a number at the end of your part names, please consider a different naming convention to avoid issues.

### After Import

You can edit / bulk edit the parts once they have been imported via the **Inputs** panel.

## Import DXF

DXF is a format commonly used in CAD software.

This functionality has been tested with the multi-file exports from CabinetSense and Pro100, but it should work with other exports. One part per file is required for the import to work correctly.

### Supported Part Types

The import will attempt to extract parts from the file. Any parts which are not rectangular will be converted to a rectangle using a bounding box. Parts must be **axis aligned**.

### Precision

If the detected bounding boxes are not accurate enough or too accurate, you can adjust the precision of the import.

### Store Files for Editing

If you would like to create an optimized DXF using these imports as the source, check this option.

### Grain

Grain can be set to the long or short side of the stock. By default, the longer size of the stock / part is oriented horizontally.

**If using CabinetSense or other software, ensure the grain is set accordingly (long side horizontal = grain horizontal).**

### Drop the File

Then simply drop in the DXF file and a preview of the data will be shown in the table. Not all parts will be shown in the list.

The length, width, thickness, quantity, name and material will be extracted from the file as supported by the software you're using.

## Paste from Spreadsheet

Importing from spreadsheets such as Excel is quick and straightforward. You can copy data from your spreadsheet and paste it directly into the **Import** panel.

Ensure you create a sheet with all the columns indicated in the Import panel - leave them blank if not needed.

Copy all the values directly from the spreadsheet and paste them into the input field, leaving out any column labels. A preview of your data is generated - if it looks ok then click the **Import** button. Your parts & stock will now be ready to view in the **Inputs** panel.

If you're using materials, ensure the stock is imported first with the material specified. Import the parts next, and the materials will be matched to the existing stock items.

Once the data has been parsed, it will be converted to use decimal separators as **.** and no thousand separators so make sure your imported data looks correct.
