Hi Edward,

Like Mike, I have some existing tools that do this in perl - though very 
hack-ish.

Basically, I set the Windows default field separator to pipe (because I 
hate comma separated data) and save the spreadsheet as .csv, though a 
pipe delimited one.

My perl then reads that in, and maps columns to DC elements and 
OAI-header elements and spits out an XML file per row of the spreadsheet.

I'd be happy to pop a version of one of these into git-hub if you're 
interested.

-corey

On 3/1/2011 3:59 PM, Edward M. Corrado wrote:
> Hi Mike,
>
> Yes, by Dublin Core, I mean OAI Dublin Core XML.
>
> Edward
>
> On Tue, Mar 1, 2011 at 3:34 PM, Michael J. Giarlo
> <[log in to unmask]>  wrote:
>> Edward,
>>
>> Because I already have some code lying around that does more or less
>> the same thing, I'd probably sling some Python using the xlrd library
>> (N.B. works on xls files but not xlsx files). �It'd look similar to
>> this method, perhaps a little simpler, though this method doesn't
>> write out a DC file:
>>
>> � � https://github.com/MaxFisher/caps/blob/master/pilot/views.py#L87
>>
>> By "Dublin Core," I assume you mean OAI Dublin Core XML?
>>
>> -Mike
>>
>>
>> On Tue, Mar 1, 2011 at 14:53, Edward M. Corrado<[log in to unmask]>  wrote:
>>> Hello all,
>>>
>>> I have an excel file that I need to map to Dublin Core. I can think of
>>> a number of ways to do this, but was wondering if anyone else who has
>>> done it has a suggestion before I dust off my old sed/awk skills or
>>> otherwise reinvent the wheel. I looked at Terry Reese's MarcEdit and I
>>> probably can use that, but it looks like I'd have to intermediately
>>> convert it to MARC. Either a windows-based program or *nix tool is
>>> fine.
>>>
>>> Edward
>>>
>>

-- 
Corey A Harper
Metadata Services Librarian
New York University Libraries
20 Cooper Square, 3rd Floor
New York, NY 10003-7112
212.998.2479
[log in to unmask]