# Excel

Frends offers seamless integration with [Micorosoft Excel](https://www.microsoft.com/en-us/microsoft-365/excel), enabling you to effortlessly connect and automate data flows involving Excel files.

Frends has tasks for performing all core Excel operations.

By leveraging Frends' task-based approach, you can configure and customize Excel integrations according to your specific requirements. Frends offers a wide range of tasks that facilitate integrations to a variety of systems and protocols.

## Use cases

Below you will find typical use cases for Excel integrations and how they are implemented in Frends.

### Retrieve Excel file from FTP and save to SQL database

By using the [`Excel ConvertToCSV`](https://docs.frends.com/tasks/tasks/excel/converttocsv) task we can create an integration that retrieves Excel files from an FTP server and saves the data to a database.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-d8b015b9afe982eca0eb72a81a39c70eb10ad867%2Fexcel-convert-to-csv.svg?alt=media" alt=""><figcaption><p>Convert to CSV</p></figcaption></figure>

### Validate Excel data with a set of rules

By using the [`Excel ConvertToJSON`](https://docs.frends.com/tasks/tasks/excel/converttocsv) task we can create an integration that checks that an Excel file conforms to certain validation rules.

<figure><img src="https://2096450325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FevBo49UTUjEN84O2WPl6%2Fuploads%2Fgit-blob-afc66eec4b7329467d1616671885d5a70ba647c2%2Fexcel-convert-to-json.svg?alt=media" alt=""><figcaption><p>Convert to JSON</p></figcaption></figure>