How do 1 open a tsv file into excel?

How do I open a tsv file in Excel? 
 

Question Info


Last updated October 14, 2019 Views 2,413 Applies to:

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.
Regards,

OssieMac

2 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.