title: Appengine: Best way to read a CSV file into app inventor
body: <p>I have a csv file and I'd need to get it into a list object in app inventor.</p>
  
  <p>I'm not sure if there is a better / simpler method, but I've looked at the following methods and I'm not really sure the best route.
  Also I'm using python but I could switch to use java app engine.</p>
  
  <ul>
  <li><a href="http://code.google.com/apis/fusiontables/docs/developers_reference.html" rel="nofollow">Google Fusion Tables (gft)</a></li>
  <li><a href="http://ai.kittywolf.net/index.php/TinyGSdb" rel="nofollow">Google Docs &amp; TinyGSdb</a></li>
  <li><a href="http://appinventorapi.com/program-an-api-python/" rel="nofollow">App Engine &amp; Python</a></li>
  </ul>
  
  <p>Down in the comments there is an example on how to update the app.yaml to include some code to parse a csv file.</p>
  
  <pre><code>import csv
  reader = csv.reader(open(‘efile_newestSFO_8354d71d-e3fb-4864-b9bf-5312a89e24d7_2010.csv’,”rU”), delimiter=’,')
  for row in reader:
  print row[0],row[1]
  </code></pre>
  
  <p>I'd rather not go out to the web every time the app loads to retrieve the list.
  Thoughts?</p>