How to import TSV file in MS Excel

I often export data from Matlab into TSV files for students and collaborators to use in other programs. It is not entirely straightforward to open these files in MS Excel, so here is a series of screenshots of how to do it. There are two tricks to make it work:

  • Remember to use “tab” as the delimiter between columns
  • On Norwegian and other systems that use “comma” as decimal separator, it is necessary to specify that the TSV file contains values with “dot” as the decimal separator.

TSV-import01

TSV-import02

TSV-import03

TSV-import04

TSV-import05

TSV-import06

TSV-import07

TSV-import08

TSV-import09

TSV-import10

TSV-import11

Published by

alexarje

Alexander Refsum Jensenius is a music researcher and research musician living in Oslo, Norway.