I am trying to export / import Item data via excel - I am a Mac user with 2011 excel.
The problem seems to be that we use > and the degree symbol etc as our data has things like temperature and beam angles. ASC11 does not include these however I find that mac numbers will handle the degree symbol but not the > symbol. Open office has a similar issue. UTF-8 is used in open office.
I would prefer xls export / import as I feel it would allow greater control but I am no programmer so there may well be issues beyond my thinking.
Any suggestions appreciated