Data export/import

ERPNext Stock/Inventory
1

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

2

I would even go for exporting to xlsx using:
https://openpyxl.readthedocs.io/en/default/

But the thing is it requires some customization and csv is just simplier :slight_smile: for the moment.

3

Sadly all above my paygrade, I’m an electronics guy not a software guy.

All and any advice or guidance much appreciated