[wiki:Haiti]
== Spreadsheet Importer ==
We have access to a lot of relatively unstructured data in Spreadsheets which we need to import into Sahana. Currently this is done via a laborious Data Entry process.

We really need to be able to do Bulk Imports.

Options:
 * CSV Import
  * Limited access through Web at: /admin/import_data
  * Problems with the file format (e.g. MS Excel chews)
  * Hard work to get reference fields lined up
 * [http://code.google.com/apis/spreadsheets/ Google Spreadsheets API]
 * [http://pypi.python.org/pypi/xlrd xlrd]
  * [SpreadsheetImporterExample Example Code] - not the cleanest

----
[wiki:Haiti]