Overview

Sheet Swiper converts spreadsheets containing linguistic data to Standard Format (for use with Linguist's Toolbox, Phonology Assistant, Lexique Pro, etc.). The rules for how to do the conversion come from the first rows of the spreadsheet itself, so subsequent, repeated conversions are easy for non-computer savvy users to do.

Requirements

Any Microsoft Windows with Microsoft .Net Framework v2.

Download

Downloads

Screen Shots

Given this input from Excel:

The "review" tab shows this:

How to use

To use this, make the first row of the spreadsheet contain the sfm markers you want to use for the data in that column. Omit markers from columns you don't want to include in the sfm. The first marker (usually in column A) will be used as the record marker.

Save the file (make sure it is saved as ".xls"), and close it.

Now run Sheet Swiper and use one of its options to locate the file, convert it, and save it. I like to just drag files onto the SheetSwiper? window.

Sheet swiper can only read .xls spreadsheet format. We have tested Sheet Swiper using Excel XP, 2007, and Open Office's Calc program.

Credits

By John Hatton, SIL International & SIL Papua New Guinea. Written in c#. Source is here: https://code.google.com/p/sheetswiper/

The real work, the reading of the xls, is done via code from Liu JunFeng's Excel Reader project.

Members

Manager: john hatton