# CSV get cutted export

**URL:** <https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967>\
**Category:** Ignition\
**Tags:** scripting\
**Created:** [April 23, 2021, 4:55pm UTC](https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967 "2021-04-23T16:55:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin\_DLeon](https://avatars.discourse-cdn.com/v4/letter/k/c4cdca/32.png) [@Kevin\_DLeon](https://forum.inductiveautomation.com/u/Kevin_DLeon)\
**Post date:** [April 23, 2021, 4:55pm UTC](https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967/1 "2021-04-23T16:55:46Z")

</div>

hello  
i have some columns and rows to export as csv file to my computer but i have a problem, imagine the table:  
COL1 | COL2 | COL3 | COL4 | COL5  
data data data data data  
data data data data  
data data  
data data  
data data

my CSV file got cut in a 1x5 file, how can i fix that to get all my 5x5 file or an nxm file? is the system.exportexcel better for this than csv?

thanks you

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [April 24, 2021, 11:43am UTC](https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967/2 "2021-04-24T11:43:36Z")

</div>

- What version of Ignition?

- Vision or Perspective?

- Where is the data coming from? If it’s a dataset from a table component, all the columns should be there.

- Show your code. Paste it, highlight it, then use the preformated text button. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/3/73c363f7c10282953db9de8efabb0cee899f58d8.png)

---

<div class="post-metadata">

**Author:** ![Kevin\_DLeon](https://avatars.discourse-cdn.com/v4/letter/k/c4cdca/32.png) [@Kevin\_DLeon](https://forum.inductiveautomation.com/u/Kevin_DLeon)\
**Post date:** [April 27, 2021, 5:07pm UTC](https://forum.inductiveautomation.com/t/csv-get-cutted-export/45967/3 "2021-04-27T17:07:04Z")

</div>

Hello Jordan! i fixed it in a way, idk if there is someone with the same problem but this was mine:

zip python function only performs to the shortest array; so make a substract of columns to see how many cells with “—” i gonna append and then the cells with no data are functional to make a list of lists.