# Export data using XLSX vs. CSV files

**URL:** <https://connective.celigo.com/t/export-data-using-xlsx-vs-csv-files/1063>\
**Category:** Integrator.io\
**Tags:** xlsx, csv, export\
**Created:** [December 13, 2021, 7:05pm UTC](https://connective.celigo.com/t/export-data-using-xlsx-vs-csv-files/1063 "2021-12-13T19:05:42Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kathyanaqueeman](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/kathyanaqueeman/32/9122_2.png) [@kathyanaqueeman](https://connective.celigo.com/u/kathyanaqueeman)\
**Post date:** [December 13, 2021, 7:05pm UTC](https://connective.celigo.com/t/export-data-using-xlsx-vs-csv-files/1063/1 "2021-12-13T19:05:42Z")

</div>

If you're exporting data from a spreadsheet, follow these rules:

**XLXS** – Used to export one sheet in a workbook. The exported sheet must be last in the workbook. For example, if you want to export data in sheet 1 out of 3, Sheet1 should be the last tab.

 ![5301043caa20740200000001-1ee0f0d0f5e54b1abd4a366cfe5b0745.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/3/3a754d2f8c94d2e75a2d8e2ee58e2dcd0e712139.png)

**CSV** – Used to export all the available data. If you're exporting everything, your data should be in one worksheet in a CSV file.

 ![5301043caa20740200000001-a620966c7960473a9172988fc31cb8cf.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/8/87aeb9f516be6818b020fa42129333c58bc17811.png)
