# Creating a Data Sheet

{% hint style="success" %}
*Check out the given walk-through on how to create a Data Sheet.*
{% endhint %}

<figure><img src="https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FZn60GOytLVcpbvibe2yx%2FCreateDataSheet.gif?alt=media&#x26;token=1a6152ca-8427-4376-b934-62f4f618d55a" alt=""><figcaption></figcaption></figure>

The section displays steps to create and list a Data Sheet.

* Navigate to the homepage of the Data Center module.
* Click the ***Data Sheet*** option from the ***New*** context menu.

![Accessing the Data Sheet option ](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2Fgyn68hgbK5HMMkszpZgJ%2Fimage.png?alt=media\&token=dfc51f6e-0ab2-4002-96c1-3d495d9f30c7)

* The Data Sheet Connector page opens.
* Provide a name for the Data Sheet.
* Provide the following information:
  * **Column Name**: Provide column names as per the data source.
  * **Input Type**: Select an option out of the provided choices (text/numeric/dropdown/autocomplete/checkbox/radio/calendar).
  * **Look Up:** This option is enabled only when the input type is dropdown. In this option, we select the datasheet whose value has to be listed in the dropdow&#x6E;**.**
  * **Column:** This option is enabled only when the input type is dropdown. In this option, we select the column of the datasheet (selected in Look Up) whose value has to be listed in the dropdown field.
  * **Data Restriction:** Defined Custom Fields get listed in the drop-down menu.
  * **Filter:** Enable the filter by putting a checkmark in the given box.
  * **Add/Update:** To add a new column/ Modify an existing column.
  * **Delete**: To remove the added data sheet information. &#x20;

![Defining a Column on the Data Sheet Connector.](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FFljymGRJccPru9UrYyuA%2Fimage.png?alt=media\&token=b231f05b-001b-4605-9421-5b99bf0374e3)

* By clicking the Add/Update option A new column gets added/to an existing column gets updated based on the entered details under the Data Sheet Preview space as displayed in the given image.
* The ***Save*** option gets enabled which the user can click to save the Data Sheet.

![Data Sheet Preview](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FGc8RJRdf56yM6IEkyFe3%2Fimage.png?alt=media\&token=7eb98083-8191-4a03-ad2e-e6255c8b7174)

* A success message appears.
* The newly created Data Sheet gets added to the Data Sheets list.

![A newly created Data Sheet get added to the Data Sheet List](https://972575688-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FRYq1HgffNfbnIMWPu1D5%2Fuploads%2FQNINmvrTgGkQv67Y3WvN%2Fimage.png?alt=media\&token=5160c421-6a81-4068-a14d-d7127406d88b)

{% hint style="info" %} <mark style="color:green;">Please Note:</mark>&#x20;

* *Click the **Refresh** icon to refresh the Column design fields. The data in the design area gets cleared.*
* *Click the **Delete**  icon to delete the selected column.*  &#x20;

{% endhint %}