> For the complete documentation index, see [llms.txt](https://help.canoa.supply/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.canoa.supply/docs/collect/how-to-format-data-with-canoagpt.md).

# How to format data with CanoaGPT

## What is CanoaGPT?

CanoaGPT is a specialized AI assistant designed to help interior designers and other professionals streamline the process of formatting and preparing data for uploading to Canoa. It ensures data organization, consistency, and compliance with Canoa's requirements, making it easier for interior designers to manage their project data efficiently.

## How do I access CanoaGPT?

{% embed url="<https://chatgpt.com/g/g-dkB2IDXQ3-canoagpt>" fullWidth="false" %}
CanoaGPT is free to use but does require you create an OpenAI account
{% endembed %}

### Supported File Types

CanoaGPT can handle various file types, including:

* HTML
* XLS
* CSV
* PDF
* XML
* SIF

### Features

1. **Upload Your Files**
   * To get started, upload the files you need assistance with. CanoaGPT supports HTML, XLS, CSV, PDF, XML, and SIF files.
2. **Verify Data Against a Specified Template**
   * CanoaGPT checks your data against a standard template to ensure consistency and completeness. This includes:
     * Identifying and correcting missing fields
     * Ensuring correct data types
     * Highlighting formatting inconsistencies
3. **Check for Proper Image URL Inclusion**
   * If your data includes product images, CanoaGPT verifies the inclusion of proper image URLs and ensures they are correctly formatted.
4. **Suggest Improvements for Data Optimization**
   * CanoaGPT provides suggestions to optimize your data, such as:
     * Correcting common issues like missing information or incorrect data types
     * Ensuring proper image URL inclusion for embedded images
     * Improving overall data organization and presentation
5. **Generate an Improved CSV File for Upload into Canoa**
   * CanoaGPT can automatically implement improvements where feasible and generate an improved CSV file for you to download.
6. **Manual Corrections with Detailed Guidance**
   * For any issues that require manual adjustments, CanoaGPT provides clear, step-by-step guidance to help you make the necessary corrections, especially for image management and format conversion.

### File Conversion

CanoaGPT can convert files from one format to another, ensuring they meet Canoa's requirements and are ready for upload. Here are the possible conversions:

* CSV to SIF
* XLS to CSV
* XLS to SIF
* XML to CSV
* XML to SIF
* HTML to CSV
* HTML to SIF
* PDF to CSV
* PDF to SIF

### Converting a **SIF**

## Why should I use CanoaGPT?

{% content-ref url="/pages/iZWnpw329bKvO3gL0XSs" %}
[How to create Custom Products](/docs/collect/how-to-create-custom-products.md)
{% endcontent-ref %}

{% content-ref url="/pages/S9Scoyn39wZg7DLH5uDq" %}
[Broken mention](broken://pages/S9Scoyn39wZg7DLH5uDq)
{% endcontent-ref %}

{% content-ref url="/pages/4vJzNgcmc2AdGQjQFx8k" %}
[How to export or print your Canvas](/docs/share/how-to-export-or-print-your-canvas.md)
{% endcontent-ref %}

{% content-ref url="/pages/amDPfuuVKhF5DuDkUFCS" %}
[How to export data from a Dashboard](/docs/share/how-to-export-data-from-a-dashboard.md)
{% endcontent-ref %}

{% content-ref url="/pages/NJ57BwzkpKoZ08d7Lbs5" %}
[Working in Table view](/docs/collect/my-catalog/working-in-table-view.md)
{% endcontent-ref %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://help.canoa.supply/docs/collect/how-to-format-data-with-canoagpt.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.