# Google Sheets

{% hint style="info" %}
Good to know

* Your data feed URL **must be in an accessible online location**.
* Channable supports compressed file formats:
  * XML, JSON, CSV, text, and Google spreadsheet files in the `.gz` format
  * XML and JSON files in the `.zip` format.
* The data feed has to be updated on the same URL (recommended at least once a day) with the latest product information (e.g. available stock, prices).
  {% endhint %}

### Step 1: Set up import

{% stepper %}
{% step %}
{% hint style="warning" %}
Important: Before you start, make sure your Google sheet is [shared and publicly available](https://helpcenter.channable.com/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets/share-a-google-sheet-make-publicly-available).
{% endhint %}

* In Channable, go to **Setup > + Setup import**.
* Select the Google sheets file type.
* Provide the requested information:
  * For **Name**, give your import a descriptive name (e.g., "Webshop Google import").
  * For **Google sheets url**, add the URL to fetch your live product data.
* Click **Start import**. You will be directed to the **Edit mapping** page to import your product data.
  {% endstep %}
  {% endstepper %}

### Step 2: Map your products

This page displays fields retrieved from your data feed (e.g. price, description, title).

* Import field: Fields from your import data.
* Project field: Corresponding project fields in Channable. Our system will automatically detect and link most fields to standardized fields.

Match (map) your imported fields to a corresponding project field. Channable does most mapping automatically, but review and adjust before importing.

Note: We create new project fields if we can't assign your import field to a standardized field. These fields will have a project field with the same name as your import field.

{% hint style="info" %}
Before you continue

1. Compare and adjust mapping:
   * Review your **Import fields** against Channable's matched **Project fields**. If a field was matched incorrectly, click on the field to select a different field.
2. Check and correct field types:
   * Check that the right field type is assigned to your project fields. If a field has the wrong type, click **Edit** next to the field, select the correct type in the dropdown, and click **Save & Import**.
3. Exclude fields (optional):
   * To exclude a field from being included in your product data, click the checkbox in the **Select** column for that field and click **Do not import selected fields**.

Once you've finished mapping, click **Save & Import** to start importing your product data. Depending on how much data you're importing, it can take a while to finish.

Note: Check the **Status** column in **Setup** to check your import progress. Your product data is fully imported when the Status is **Finished**.
{% endhint %}

### Step 3: Review your imported items

After your product data has finished importing:

* Go to the **Items** page to view your imported products.
* Click on an item to see detailed information.

<figure><img src="https://3042294697-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZa0iYflHeXmKWGnfFMAN%2Fuploads%2F5Qa1JCnncyMFdawV1SKP%2F27763916049938?alt=media&#x26;token=d0753fc6-2b91-4ba0-a555-4bce4ea363e7" alt=""><figcaption></figcaption></figure>

Your import is now successfully set up! You can now use this product data to create and optimize Feeds, Marketplaces, Shopping Ads, and more in Channable.

#### Read next

{% content-ref url="../../combine-multiple-imports" %}
[combine-multiple-imports](https://helpcenter.channable.com/import-data/import-how-to/combine-multiple-imports)
{% endcontent-ref %}

{% content-ref url="google-sheets/share-a-google-sheet-make-publicly-available" %}
[share-a-google-sheet-make-publicly-available](https://helpcenter.channable.com/import-data/import-how-to/import-your-product-data/import-via-a-data-file/google-sheets/share-a-google-sheet-make-publicly-available)
{% endcontent-ref %}