I've been sent a whole bunch of excel files from a client and I need to get that data out and make use of it in the app. The issue is the data is in excel, it's not consistent and has weird MS characters in it. The biggest issue is probably that the second column has everything from quotes to commas to newlines so if I try to export it as csv it breaks. I've tried exporting in ever type to see if there was a way I could parse it but I'm out of ideas. There must be a way, I mean excel and numbers both read the xsl and csv files correctly but I can't get anything else to. Is there a way I can export this from one of these programs into a meaningful portable way?