While it might stick in Microsoft's proverbial craw, I would like to have Streets and Trips and AutoRoute have a data import option that accepts data in the Open Office spreadsheet format - *.ods.
Can't you just save the spreadsheet as an Excel spreadsheet and import it into Streets? I thought one of Open Office's claims to fame was that it can use the MS Office document formats.