> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncspider.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# How to Integrate Custom CSV - Help Center - SyncSpider

## TABLE OF CONTENTS

* [Description](#Description)
* [Entities](#Entities)
* [Steps](#Steps)
* [Step 1.](#Step-1.)
* [Step 2.](#Step-2.)
* [Step 3.](#Step-3.)
* [Step 4.](#Step-4.)

---
## Description

A Comma Separated Values (CSV) file is a plain text file that contains a list of data. These files are often used for exchanging data between different applications. For example, databases and contact managers often support CSV files.

---
## Entities

| Source | Target |
| --- | --- |
| Custom CSV | Custom CSV |

---
## Steps

### Step 1.

Either while **Creating a Task** or in the Integrations menu.

Enter the name of the integration in the search bar.

![Selecting the Custom CSV integration](https://storage.crisp.chat/users/helpdesk/website/-/1/0/b/3/10b38ef4384a1c00/bca3f4d3-d215-4c41-9ee7-1122d6_1v3rxaw.png)

### Step 2.

Enter the Name of the Integration.

You can optionally also enter a description.

![Naming the Integration\](https://storage.crisp.chat/users/helpdesk/website/-/f/d/7/1/fd71aeaa2e1cf800/3f510d3b-671f-4d4d-a377-14a169_gatgvr.png)

### Step 3.

You will be prompted for the **Storage Type****.**

****

When storage type is Local:

![Storage type local](https://storage.crisp.chat/users/helpdesk/website/-/3/1/2/8/31285a41f9f43600/e7a201a6-d8db-4bc7-8114-ba818a_2dq0wa.png)

When you import CSV file through the “Local” storage type:

![import CSV in local storage](https://storage.crisp.chat/users/helpdesk/website/-/e/c/c/4/ecc48fc55161c000/3919ed7d-87c3-4296-8c7f-fd88d5_1jkcwlt.png)

If you choose “Feed (URL)” storage type

![Feed URL storage type](https://storage.crisp.chat/users/helpdesk/website/-/f/c/f/8/fcf83e2822847000/d69c0c6f-589d-492b-b4c4-4c89c7_skghca.png)

You can update the CSV file (created on cloud as a spreadsheet and saved as CSV file if needed offline):

![Update CSV file ](https://storage.crisp.chat/users/helpdesk/website/-/9/0/7/f/907fa5b5cac77000/f7ea9e38-ce45-4a48-ada1-a2db04_fka43r.png)

When you choose “Google Drive” as a storage type

![Google Drive storage type](https://storage.crisp.chat/users/helpdesk/website/-/a/1/3/5/a1353b961d2ff000/1bf259fb-0b1c-49ca-a1fb-28633f_c5hou.png)

You can sign in via google account, enter your email address and click the “next” button in order to connect.

![Google Drive sign in](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3101753145/original/vS_QKp5QQ5fjYHpNV9w_hMpompJHE1ohSw.png?1700056134)

Upload your CSV file to a FTP / SFTP server:

![SFTP storage type](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3101753148/original/qg6W6NYAVClVybiOQkey61xQDD-7nyzhRg.png?1700056135)

![FTP storage type](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3101753143/original/VXf4bk-0rN_HfpCV8uIrgNJwrBeja_rDoQ.png?1700056134)

First, you need to create a link to the CSV file on your FTP / SFTP Server:

1. Please make sure that your CSV file meets the requirements. For example, the CSV file needs to be comma (,), semicolon (;) or tab separated and include a header row. Also make sure that your file doesn’t include any other information than the headers and the values below (such as descriptive lines of text in the first rows or totals at the bottom row). If so, remove these rows before saving the file to your FTP / SFTP server.

2. Upload your CSV file to your FTP / SFTP server.

3. To directly link this CSV to Syncspider you will need to generate a URL using the following information:

a) Username: The name of a user that can access the file on your server.

b) Password: The user password for authentication.

c) Port: This is the port number used to access the FTP / SFTP server. In case you haven’t defined a port number for your server use the default port 22 for SFTP and port 21 for FTP.

Storage type “SyncSpider SFTP” is publicly available to select, but it can only be used according to your Syncspider plan:

![Syncspider SFTP](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/3101753144/original/t2cRWcsiAEqV6VKoUrwSCMipO1-kLhKS1Q.png?1700056134)

###

Choose one of the **Storage Types and click Finish!**

---

**Custom CSV** is just one of the tools we support!

To check the list of the tools and features we support please click [here](https://syncspider.com/integrations/)!

If you don't see your favorite tool on our list, please take the time and send us the request [here](https://roadmap.syncspider.com/boards/integrations?sort=cached_votes_up) to create an integration for you or UP-vote if it's already on the list :)

We develop integrations based on the requests and up-votes :)

We hope that this covers everything. If you have any further questions or need additional clarification please reach out to us via [[email protected]](/cdn-cgi/l/email-protection#32414742425d404672414b5c5141425b5657401c515d5f) or our chat widget!