First I would like to preface I found a work around for my issue but I am curious if anyone knows what might be causing it.
So in my case I have tab delimited data in VS and I pasted it into excel. As soon as it's pasted in to excel the tabs are condensed to spaces. (Fixed it by saving the my data as a CSV file and copy and pasting back into my excel doc) I tried moving the data in to textedit and the same thing occurred. So I am wondering is this an OS setting on Mac? what would be causing this?