![]()

#### 

Few days ago, I saw a question on Sitecore #commerce Slack channel. The question is:

*Any idea on how we can forcefully download a csv file from a pipeline block?*In my previous blog post, I explained how to export Price Books. In case of Price Books, there was exported data in
zip extension. Therefore, it is not a big deal to implement the export of any custom data from Sitecore Commerce in csv
format. I have implemented a sample plugin and in the current blog post will share my knowledge how I did it.

The source code you can find here: [https://github.com/Frog911/Plugin.Sample.Commerce.ExportCsv](https://github.com/Frog911/Plugin.Sample.Commerce.ExportCsv)

First of all, you have to add reference to CsvHelper NuGet package.

Then we have to create *IExportDataPipeline* pipeline:

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/1.png?w=900&hash=F3E0526244193F186D2710239119691F)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/1.png)

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/2.png?w=900&hash=5396E063612F5558349EEC4578E16D62)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/2.png)

For this pipeline, we have to create *ExportDataBlock*:

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/3.png?w=900&hash=5AA1719C9C5400E0D4FBC598147950D3)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/3.png)

Here we are using *IStreamDataToCsvPipeline,* which we also have to implement.

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/4.png?w=900&hash=FFA7AE0DC2E753898089E61A83E4CA4D)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/4.png)

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/5.png?w=900&hash=5C82C2BDCE958E93CB6EAE30A1F065E2)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/5.png)

*IStreamDataToCsvPipeline* will contain *StreamDataToCsvBlock,* which will be responsible to build csv
    file for download.

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/6.png?w=900&hash=27981DA2C7085A693353F88D11A70553)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/6.png)

And, of course, we have to register our pipelines.

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/7.png?w=900&hash=CB413EADE78FBACD69EE928A5305ADBB)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/7.png)

How we are ready to use these pipelines in any custom endpoint and we can use Postman to test these logic.

[![Sitecore Commerce 9: Export csv](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/8.png?w=900&hash=215E5E27F9AB239D89BE0222C8E3581A)](https://www.brimit.com/-/media/project/brimit/blog/2020/apaliakou/post-7/8.png)

I hope this blog post will be useful for someone who wants to implement such export data feature.

Stay tuned!

###### More from author

[##### Sitecore OrderCloud: Restricting access to a custom middleware endpoints for Anonymous customers
August 13, 2024](https://www.brimit.com/blog/sitecore-ordercloud-restricting-access-to-custom-middleware-endpoints-for-anonymous-customers)[##### Sitecore OrderCloud: Cannot Create a Buyer and a Supplier with the Same ID
March 31, 2023](https://www.brimit.com/blog/sitecore-ordercloud-cannot-create-a-buyer-and-a-supplier-with-the-same-id)[##### Sitecore OrderCloud: How to Start Using “Me and My Stuff”
November 29, 2021](https://www.brimit.com/blog/sitecore-ordercloud-how-to-start-using-me-and-my-stuff)

###### Author

[!\[apaliakou\](https://www.brimit.com/-/jssmedia/feature/blogs/authors/apaliakou.jpg?h=216&iar=0&w=360&hash=5BE96F17AE5B47F66D9F684B87773675)
Andrei Paliakou
Sitecore MVP/ Lead Developer](https://www.brimit.com/blog/author?authors=Andrei%20Paliakou)

###### More By Categories

[#Events](https://www.brimit.com/blog?categories=#Events)[#How-to](https://www.brimit.com/blog?categories=#How-to)[#News](https://www.brimit.com/blog?categories=#News)[#Guides](https://www.brimit.com/blog?categories=#Guides)

###### More by Platform

[Data and AI](https://www.brimit.com/blog?platforms=Data%20and%20AI)[DXP](https://www.brimit.com/blog?platforms=DXP)[E-commerce](https://www.brimit.com/blog?platforms=E-commerce)[Internet of Things](https://www.brimit.com/blog?platforms=Internet%20of%20Things)[Sales and marketing automation](https://www.brimit.com/blog?platforms=Sales%20and%20marketing%20automation)

#### More on Sitecore

[!\[How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects\](https://www.brimit.com/-/jssmedia/project/brimit/blog/2024/vercel_cover-image.png)
#Guides#How-toDXPE-commerce
##### How Vercel Will Help You Save Effort When Deploying Sophisticated Sitecore Projects
Optimize and accelerate the development and deployment of complex multisite Sitecore projects.
Alexei Vershalovich on July 17, 2024](https://www.brimit.com/blog/how-vercel-will-help-you-save-effort-when-deploying-sophisticated-sitecore-projects)

[!\[Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story\](https://www.brimit.com/-/jssmedia/project/brimit/blog/2023/sitecore-mentoring---cover-image.png)
#How-toDXP
##### Training Up Tomorrow's Sitecore MVPs: a Mentoring Success Story
How to participate in the Sitecore Mentor program and help younger colleagues jump-start a career in Sitecore development.
Sergey Baranov on October 2, 2023](https://www.brimit.com/blog/training-up-tomorrows-sitecore-mvps)

[!\[Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)\](https://www.brimit.com/-/jssmedia/project/brimit/blog/2022/headless/adobestock_456986731.jpg)
#How-toDXPE-commerce
##### Going Headless. Part 2: When a Headless CMS Is Your Best Bet (if you have Sitecore)
Discover how a headless CMS can benefit organizations that use Sitecore.
Daniil Raschupkin, Palina Trokhautsava on September 15, 2022](https://www.brimit.com/blog/going-headless-part-2-when-a-headless-cms-is-your-best-bet-if-you-have-sitecore)

![](https://bat.bing.net/action/0?ti=187017043&tm=gtm002&Ver=2&mid=a1e43a64-61e0-4b64-820e-6561306d2148&bo=2&gtm_tag_source=1&pi=0&lg=en-US&sw=800&sh=600&sc=24&nwd=1&tl=Sitecore%20Commerce%209%3A%20Export%20csv&kw=Sitecore%20Commerce%209%3A%20Export%20csv&p=https%3A%2F%2Fwww.brimit.com%2Fblog%2Fsitecore-commerce-9-export-csv&r=&lt=327&evt=pageLoad&sv=2&asc=D&cdb=AQAY&rn=193070)