# Working with Spec

### Import a Canoa SIF file into Spec

You may export product data as a SIF file from both [<mark style="color:purple;">**Canvas**</mark> ](https://www.canoa.supply/canvas)and [<mark style="color:purple;">**My Catalog/Table View**</mark>](https://www.canoa.supply/catalog-pro)<mark style="color:purple;">**.**</mark>

* Follow steps for Canvas export in [<mark style="color:purple;">**How to export a SIF file from Canvas**</mark>](https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-export-a-sif-file-from-canvas) help doc
* Follow steps for My Catalog/Table View export in [<mark style="color:purple;">**How to export a SIF file from My Catalog/Table**</mark>](https://help.canoa.supply/docs/collect/my-catalog-cms/working-in-table-view/how-to-export-a-sif-file-from-my-catalog-table-view)[ <mark style="color:purple;">**View**</mark>](https://help.canoa.supply/docs/collect/my-catalog-cms/working-in-table-view/how-to-export-a-sif-file-from-my-catalog-table-view) help doc

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FnPrzMfnwtlkM7cEsbeld%2FScreen%20Shot%202024-11-25%20at%203.13.46%20PM.png?alt=media&#x26;token=f4cc0c9a-e611-41b8-aa84-010f76c51076" alt=""><figcaption><p>SIF Export in My Catalog/Table View</p></figcaption></figure>

### Import SIF file in Spec

Open or import SIF file from Canoa download. You may update product data against the Spec catalog to enable more option selection.

{% hint style="info" %}
The Export SIF feature is only available in beta, please contact <support@canoa.supply> for more information and access to Canoa's new feature.
{% endhint %}

##

## Exporting Product Data from Spec for import into Canoa

1. Open a **SIF** file in **Spec**
2. `Export` as a **CSV**
   * Export with **Combined Product Number** if available
3. Open [<mark style="color:purple;">**CanoaGPT**</mark>](https://chatgpt.com/g/g-dkB2IDXQ3-canoagpt)
4. Ask **CanoaGPT** to create a **CSV** from the file, with a record for every **PN or Part Number** with all of the associated data fields.&#x20;
5. `Import` your **CanoaGPT** formatted **CSV** into[ <mark style="color:purple;">**Canvas**</mark>](https://www.canoa.supply/canvas) (for less than 100 products) or [<mark style="color:purple;">**Catalog Pro**</mark>](https://www.canoa.supply/catalog-pro) (for 100 products or more)
   * Match the **CSV** fields with the Canoa formatted fields
   * \*Format your **CSV** before importing to save time matching fields.  Refer to the article for step-by-step instructions.
6. Add Images and 2D drawings to your products to use in future projects and to collaborate with your team.

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2F5tDFUymj1TAAWLfUlxrQ%2FScreen%20Shot%202024-08-28%20at%2010.26.26%20AM.png?alt=media&#x26;token=86927bcf-c294-4f17-b651-cfce71e4d6de" alt="" width="554"><figcaption><p>Match the Spec fields to Canoa fields</p></figcaption></figure>

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FMQMtdeAFPzzoWvBm16Iu%2FScreen%20Shot%202024-08-28%20at%2010.27.51%20AM.png?alt=media&#x26;token=b1bd114b-1f84-40f9-a4e0-8dbb76208a99" alt=""><figcaption><p>Your products are ready to add Images and 2D drawings</p></figcaption></figure>

##

## Import your Canoa Product List CSV into Spec

There are 2 ways to Export a **Product List** to a CSV from Canoa&#x20;

* [<mark style="color:purple;">**Canvas**</mark> ](https://www.canoa.supply/canvas)-Add a **Product List** to a Canvas, select products you wish to `Export` and select **CSV**
* [<mark style="color:purple;">**My Catalog/Table View**</mark>](https://www.canoa.supply/catalog-pro)**-**&#x53;elect the custom products you wish to Export, click the three dots and select `Export`.

{% hint style="info" %}
Head to [<mark style="color:purple;">**How to bring your Product List into Excel**</mark>](https://help.canoa.supply/docs/share/how-to-download-a-product-list/how-to-bring-your-product-list-data-into-microsoft-excel) for more detail.
{% endhint %}

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FiTHAIlDMDBxwMOWGxBgr%2FScreen%20Shot%202024-08-28%20at%209.10.28%20AM.png?alt=media&#x26;token=1b2a4223-d649-4faf-85e7-7a651711ca9e" alt=""><figcaption><p>Export your Product List from Canvas</p></figcaption></figure>

1. Open the **CSV** in Excel or GoogleSheets
2. `Save As` or `Download` a **XLS** extensions
   * Note: delete any lines that are above the column headers, unhide any columns, delete columns do not wish to import and delete other tabs that will not be used.

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2F4fykpgY1iNHugb1QqO1h%2FScreen%20Shot%202024-08-28%20at%209.12.43%20AM.png?alt=media&#x26;token=c0de8790-dedf-426e-b78e-8d963bd8e896" alt=""><figcaption><p>Open the CSV in Excel or GoogleSheets</p></figcaption></figure>

1. Open **Spec**
2. Click `File`>`Import`>`Microsoft Excel`
3. Assign columns from the Excel File list (first column) from the Spec list (second column) to create the list for import shown (third column)
   1. Example: Match **SKU** in the Excel List to **Part Number** in the Spec List

<figure><img src="https://2113117739-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FoXL90G447T7Arsje35d9%2Fuploads%2FRXz88c39jjK5upW30cPt%2FScreen%20Shot%202024-08-28%20at%208.56.18%20AM.png?alt=media&#x26;token=c7b8e3d3-a526-4a52-a222-b97ad7dc58f7" alt=""><figcaption></figcaption></figure>

1. When you are done matching all of your columns, click `Ok`
2. Congrats!  You imported your Canoa products into **Spec**.