Magento export order in csv price symbol ₹ . How to change into rupees symbol

  • Check your CSV encoding. And please enhance your question a little, one-liners are not welcome here. Commented Aug 22, 2016 at 7:21
  • My question is that when export order in csv. Order total amount currency symbol coming like ₹ when open csv file in excel. I got the solution now. I added these char chr(0xEF) . chr(0xBB) . chr(0xBF) to csv file an d now rupees symbol is coming with total amount. Commented Aug 22, 2016 at 9:44
  • @Shekhar could you please explain what do you mean by "add these char chr(0xEF) . chr(0xBB) . chr(0xBF) to csv file" is it like in my csv file i write rupeee symbol as " ₹chr(0xEF) . chr(0xBB) . chr(0xBF)" ?
    – Neha Singh
    Commented May 23, 2018 at 5:42
  • This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review Commented May 23, 2018 at 6:12

2 Answers 2


I think this is issue of UTF-8 encoding Decode UTF-8 when you import and your problem were solved

<?php echo utf8_decode(string); ?>

  • I used this one but know price symbol come like ? (question mark) this. price symbol ₹ is comming on excel. Commented Aug 20, 2016 at 11:10
  • @ShekharSuman because Rupee symbol is not iso-8859 compliant. Commented Aug 22, 2016 at 12:03

chr(0xEF) . chr(0xBB) . chr(0xBF) apped this to content of csv.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.