> For the complete documentation index, see [llms.txt](https://endash-guidance-docs.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://endash-guidance-docs.gitbook.io/docs/connect/upload-csv-xlsx-file.md).

# Upload CSV/XLSX file

* You can upload your CSV/XLSX file without using any data services.

## Set up

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FDRMDgka0PNTdVSEk6Ml3%2Fimage.png?alt=media&amp;token=b02806aa-278d-4130-86a9-f209a87d6e1d" alt=""><figcaption></figcaption></figure>

* To begin, click on the Upload file option on the Connect page.

<div data-full-width="true"><figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F7KPQtyRMxXPgLAj3t7sW%2Fimage.png?alt=media&amp;token=5fe21de4-e3e5-4455-a3cf-c185b3e4c29b" alt="" width="533"><figcaption></figcaption></figure></div>

* Click on the Connection name file and type the name.

{% hint style="info" %}

* The name should not contain any space or special character.
* The name should be unique to other connection names.
  {% endhint %}

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Fr8uvZgexl11bNhs3r9UL%2Fimage.png?alt=media&amp;token=b82569cc-0c3d-48a5-b84c-0e465fb9e1be" alt="" width="536"><figcaption></figcaption></figure>

* Continue to add a name for the column.

{% hint style="info" %}
The column name should be unique.
{% endhint %}

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F2flC2AUnrN5GmioFRRhb%2Fimage.png?alt=media&amp;token=a97d2b57-a09c-447a-a3f9-7aea910a4fb7" alt="" width="563"><figcaption></figcaption></figure>

* Click on the Type dropdown and select the available data type for your column.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FKN0iMXMz2aquJIoqWfVw%2Fimage.png?alt=media&amp;token=e43e21d9-2946-4047-b11e-d3824dbf8112" alt="" width="551"><figcaption></figcaption></figure>

* Click the X button to delete a column item.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F3t221G93l8uVtZfq1UZs%2Fimage.png?alt=media&amp;token=40dda774-9372-403f-bed1-b193a3b4ede5" alt="" width="535"><figcaption></figcaption></figure>

* Click the + Add column to add a column item.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FBmsld4DeaOybAYSiiY37%2Fimage.png?alt=media&amp;token=24ff79b9-60cf-4eab-b727-1de5b0156acd" alt="" width="551"><figcaption></figcaption></figure>

* There 2 methods:
  * Add: As a method of adding data, all data in uploaded files are added independently.
  * Replace: All data from the most recently uploaded file will be replaced.
* Select the method that suits your needs.
* If all setup has been completed, click the Continue button.

***

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2Fr9Xg0P7whY3qPi7CwC6y%2Fimage.png?alt=media&amp;token=8220f81e-e22c-4b48-95be-0a2dede6bf0f" alt=""><figcaption></figcaption></figure>

* The upload file setup will display in the Connection list.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FnH09Nyi6zqS1mDxhfJm7%2Fimage.png?alt=media&amp;token=0a8c50fe-adff-4655-9962-1b567cc2a021" alt=""><figcaption></figcaption></figure>

* Click on the Upload file on the left of the page to upload a file from your device.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2F28YOKm1lPGMfXplwMmu4%2Fimage.png?alt=media&amp;token=5dc86524-b6ac-48fb-ac53-a6c39e240d12" alt=""><figcaption></figcaption></figure>

* Simply follow through the pages.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FhfOjuxPwlIvcVkx6E5NK%2Fimage.png?alt=media&amp;token=b649b315-b17a-4510-b1dd-690228a2ecfd" alt=""><figcaption></figcaption></figure>

* Click on the Download button to download it or delete it by clicking its X button.

## Edit

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FnVbHiQvSAj7jWIKUkNGp%2Fimage.png?alt=media&amp;token=53e1779c-29f9-4fcc-8780-f5ab54cc18e0" alt=""><figcaption></figcaption></figure>

* To Edit the Schema, open the tab and click on the Edit button.

<figure><img src="https://1608311007-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FSr8m3Ldc2W7Qqq1jsjgC%2Fuploads%2FnWAT3ld3lDlFzsJOWOHV%2Fimage.png?alt=media&amp;token=3d880294-2aa4-4264-aaf1-5a1f38fb13be" alt=""><figcaption></figcaption></figure>

* Simply add or delete then save the change.

{% hint style="info" %}
You can only be able to change the Schema if there is no file uploaded.
{% endhint %}
