Open a blank workbook or just go to a blank worksheet.
Select Data ribbon
Select "From text" icon in the "Get External Data" block at left of Data ribbon
Select the file from the dialog and then click Import
In the Text Import Wizard select "Delimited" (Probably will be default)
Check Tab delimiter box only (all other boxes unchecked)
The next dialog allows you to specify the type of data in the tsv columns. If you have any Dates then select the column of Dates at the bottom and then Select "Date data format". To the right of the date select the date format that is in the tsv file (NOT
the date format you want to finish up with because Excel needs to know what date format is in the tsv file so that it can convert to your regional date format).
You can also select any other columns and set the data type. eg if you have numbers that are in text format and you want them to remain in text format so as to preserve leading zeros then select the column and set to Text format.
Click finish .
At this point the data is connected to the source. If you want to break the connection and keep the data then click "Connections" icon in the Connections block and Remove the connection.
3 people were helped by this reply
Did this solve your problem?
Sorry this didn't help.
Great! Thanks for marking this as the answer.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response?
Thanks for your feedback.
Last updated June 18, 2020