# Creating a new Report by Uploading an Excel File

{% hint style="success" %}
*Check out the walk-through to create a new Story and save a View using the Upload Excel option.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FxZF8YGlESz97qqyTOJvz%2Fuploads%2FPNelcAkYdUmY8WBpHYZb%2FCreating%20an%20Excel%20Report.mp4?alt=media&token=18122832-0aa8-4bf8-80c9-5bac1138074e>" %}
***Creating an Excel based Report***
{% endembed %}

* Access and click the ***Report*** module icon.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/e4pKtkLBuGgsM38MMcf3/image.png" alt=""><figcaption><p><em><strong>Accessing the Report Module</strong></em></p></figcaption></figure>

* The ***Create New Report*** page opens.
* Provide a name for the report.
* Describe the report.
* Click the ***Upload Excel*** option.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/DkkZP5z6MOwyWBaXFzsq/image.png" alt=""><figcaption><p>Creating a New Report by uploading an Excel File </p></figcaption></figure>

* Provide the Data Store Name.
* Use the Choose File option to upload a file.    &#x20;
* Select a specific Sheet by selecting a Sheet from the drop-down menu.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/aHquE0kx1gnb5mkgzSfg/image.png" alt=""><figcaption></figcaption></figure>

* A notification flashes suggesting the user wait till the file gets uploaded.&#x20;
* The Choose a File option turns blue suggesting the successful upload of the selected file.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/kQkp8itRNvJqF5F1J56v/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears to ensure the completion of the file upload action.
* The ***File Uploaded*** option gets a blue tick mark after the file is uploaded.&#x20;
* The **Data Store Details** tab opens by default (as displayed in the image).

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/SHnc1y4qJYjv8GRcZuIS/image.png" alt=""><figcaption></figcaption></figure>

* Open the ***Variable Types*** tab to get the variable types with count.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/NlOeLeU1FOwGzcxWwoEl/image.png" alt=""><figcaption></figcaption></figure>

* Navigate to the ***Examples*** tab to display the sample data from the uploaded file.
* Click the ***Create Story*** option given below.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/iiQZU43DeBdoV3iMmjaO/image.png" alt=""><figcaption></figcaption></figure>

* A notification message appears to ensure that the Datastore creation has been started.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/SJDmFcyDdMzgdtFHb4PH/image.png" alt=""><figcaption></figcaption></figure>

* The report gets created based on the selected Data Store and the user gets redirected to the Design page of the newly created Report.

<figure><img src="https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/04jwvJYh5MwkOWeTZOF4/image.png" alt=""><figcaption></figcaption></figure>

<details>

<summary>Try it out yourself</summary>

As explained above Creating a New Story with BDB Story module is so easy and gets completed in less than 3 minutes. If you don't believe this, here is a sample Excel file for you to try it out yourself.

</details>

{% file src="<https://content.gitbook.com/content/qcRKh6n896BG051TWTp3/blobs/u9HwBMRpXMSj95eGWaB6/Sample%20Data_Decomposition.xlsx>" %}

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark> Kindly change the name of the **Sample File** while using it for your trial each time*.
{% endhint %}