# Spreadsheet Data Preparation

{% embed url="<https://app.supademo.com/demo/cmlapbo4w34g2vhwz8khv34l2?utm_source=link>" %}

### Review the Sample Format &#x20;

* Do not change column headers

{% embed url="<https://app.supademo.com/demo/cmoijrswk001sx60k0d6aw8lv?utm_source=link>" %}

* Refer to the sample data provided in the second row

{% embed url="<https://app.supademo.com/demo/cmoijv3sc0013yw0jgyxhyacq?utm_source=link>" %}

* Enter data only in the specified columns

### Mandatory Data Guidelines &#x20;

**Mobile Number Format** &#x20;

{% embed url="<https://app.supademo.com/demo/cmoijyoev0016yw0jz190yx9p?utm_source=link>" %}

* Prefix the country code before the number
* Do not use “+” symbol

Example:\
91XXXXXXXXXX (Correct)\
+91XXXXXXXXXX (Incorrect)

#### Tags Column &#x20;

* You can add a tag in the first customer row
* The same tag will automatically apply to all contacts in the spreadsheet

Example:\
If you enter the tag **“1st Customer”** in the first row, the system will apply this tag to all uploaded contacts.

{% embed url="<https://app.supademo.com/demo/cmoik1l76043mz10j67k1k3s3?utm_source=link>" %}

After upload, this tag will be automatically added and updated in the **Tags** section.\
This helps in easy identification and segmentation of the uploaded contacts.

#### AllowBroadcast Column &#x20;

* Enter true in the **AllowBroadcast** column
* This will enable broadcast messaging for all uploaded contacts

{% embed url="<https://app.supademo.com/demo/cmoik4uat00zv0o0juh0zowc1?utm_source=link>" %}

If not specified, broadcast settings may remain disabled.

### Save the File &#x20;

After entering all data:

1. Click **Save As**

{% embed url="<https://app.supademo.com/demo/cmoik6n8h002lx60kux3pxr7o?utm_source=link>" %}

2. Select file format as **CSV**

{% embed url="<https://app.supademo.com/demo/cmoik844103962m0j6b0c5rxq?utm_source=link>" %}

3. Save the file

The system accepts only CSV format for bulk upload.


---

# Agent Instructions: 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:

```
GET https://docs.ownchat.app/contact-screen/spreadsheet-data-preparation.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.