I exported the data from Manager to .tsv format and then extracted to .xlxs format in order to bulk edit. The issue is that data i.e. the key is collapsing under header Telephone. I tried copy>paste method, used .tsv extractors, and text conversion using tab headers in excel as well. All programs are representing as above attachment.
Likewise I extracted 5300+ Sales Invoices using all the methods and haven’t faced such problem as customer data bulk update.
Data wrapped because of space issues which I intentionally had to manipulate so that everything fits in while I take the screenshot.
I hope I am clear this time. Trust me, it’s definitely a bug in Manager and has nothing to do with excel options.
I think a user out there also posted similar issue which were marked as bug later. Here’s the link: Employee batch update bug