The shop import/export feature lets you edit your category and product details in a spreadsheet application and then import the data into the shop. You can access the import/export feature by clicking Import/export in the shop management panel menu. You can then:
CSV files are the standard format used to import and export data into and out of spreadsheet applications. Unfortunately Microsoft Excel only supports a limited set of characters within CSV files, and charcters outside of this range will be lost. To prevent this happening, you need to save as Unicode text rather than CSV. To do this when saving from Excel, click on the Save as type… drop-down field and then select Unicode text (*.txt) as the file type.