Importing and processing a spreadsheet on Google App Engine

Question!

I have a spreadsheet full of information and one time only I need to put this data into the Datastore by reading the rows and creating model entities out of all of the data. Each row is an entity and each column is a different property.

I am a little confused how exactly I can put the data into a form that is process-able by GAE and then what I should use to process the spreadsheet in python. I can easily move my data, which is currently in Excel, to Google Docs if that makes things easier but I am still not sure what to do from there.

By : clifgray


Answers

An easy way is to publish the spreadsheet. See this blogpost: http://blog.pamelafox.org/2010/08/importing-data-from-spreadsheets-to-app.html

Another method is to download the the spreadsheet as a CSV and upload this CSV with the app engine bulkloader.

By : voscausa


This video can help you solving your question :)
By: admin