excel to plist or xml

Discussion in 'Mac Basics and Help' started by ragnar117, Apr 22, 2016.

  1. ragnar117, Apr 22, 2016
    Last edited: Apr 22, 2016

    ragnar117 macrumors newbie

    Apr 22, 2016
    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!
  2. campyguy macrumors 68040

    Mar 21, 2014
    Portland / Seattle
    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...

Share This Page