> For the complete documentation index, see [llms.txt](https://docs.ownchat.app/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.ownchat.app/contact-screen/spreadsheet-data-preparation.md).

# 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.