Help me recover a badly messed up CSV

Hi

So I have received a CSV where all the data is in the first column without any visible delimiter. However, when I copy the content of a cell into a text editor, I see that the different fields are separated with TABS but I am unable to split them in an excel spreadsheet.

The data would need to be separated into different columns.

Please find sample files attached for the messed-up csv & the sample text file (TAB delimited)

Kindly advise how I can salvage this data. There are over 17K total records in file


Many many thanks in advance