Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

How do 1 open a tsv file into excel?

How do I open a tsv file in Excel? 

Try the following.

  • 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)
  • Click Next
  • Check Tab delimiter box only (all other boxes unchecked)
  • Click Next
  • 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.


Question Info

Last updated June 18, 2020 Views 3,867 Applies to: