# Data reading problems of CSV files

**URL:** <https://forum.inductiveautomation.com/t/data-reading-problems-of-csv-files/35645>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [June 15, 2020, 8:28am UTC](https://forum.inductiveautomation.com/t/data-reading-problems-of-csv-files/35645 "2020-06-15T08:28:24Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [June 15, 2020, 3:36pm UTC](https://forum.inductiveautomation.com/t/data-reading-problems-of-csv-files/35645/3 "2020-06-15T15:36:15Z")

</div>

I think it's safe to assume the values are separated by commas 😁

Does this help?

> [@Reading from .csv file to table](http://forum.inductiveautomation.com/t/reading-from-csv-file-to-table/19614):
>
> Is there a way to open a file and transfer it directly into a table on a timed script every 1 minute or so. I have a constantly updating .csv file and need to import the values so I can use them as temperature readings in my project. I am using the following script to access the file which works but I need an automatic system that is constantly updating. # Import Python's built-in csv library. import csv # Ask the user to find the CSV in the local file system. path = system.file.openFile("csv…

To extract just a single column, you can use:

```auto
dataList = [item[2] for item in dataList] 

```

Where dataList is the csv data as a list of lists, and 2 is the column index to extract

---

_[View the full topic](https://forum.inductiveautomation.com/t/data-reading-problems-of-csv-files/35645)._