excel to plist or xml

[ragnar117]

Hello, I'm very new to the game here, any help would be greatly appreciated. I am generating a quiz using a platform on Xcode. With roughly 7,000 questions that I have pre-generated in excel format I am trying to find a script which can convert my simple excel spreadsheet into appropriate plist.

My spreadsheet all follows this pattern: http://imgur.com/qIhdVWy

Here's what I'm looking to have the plist turn out as: http://imgur.com/b7MS25E

I've had some people tell me that I can use the excel formula concatenate to get to an xml format. I'm hard pressed to figure out how to generate an array from the four answers; while having the question show as a string.

If anyone could point me in the general direction of how to figure this out I'd be so grateful!

 

[campyguy]

Long-time Excel user here, with some input. What do you mean by "Excel format"? What version of Excel?

A few bits FYI. A "portable" file format for moving data from one workbook-based application (KSpread, OpenOffice Calc, Microsoft Excel/Word) or import that data is the CSV format (Comma Separated Values), although I suspect this isn't what you're seeking here.

What most users of MS Office apps don't realize is that the .***X (PPTX, XLSX, DOCX) files are really archive files, like ZIP files. In the .***X file is an XML (likely formatted for your region) file plus other application-specific files. Simply right/Control-clicking on a .XLSX file and choosing the "Show Package Contents" option might reveal an XML file that you're looking for - you just didn't know it was right there already...