Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Shawn_Eary
Advocate V
Advocate V

Fabric Doesn't Like TSV Extension?

I often give my Tab Separated Values files a TSV extension. Fabric doesn't seem to want to allow me to open the file:

Shawn_Eary_1-1751307855778.png
Should I stop giving my Tab Separated Values files a TSV extension and instead give them a CSV extension?

 

1 REPLY 1
Shawn_Eary
Advocate V
Advocate V

Interestingly, I renamed the file mentioned above from a TSV extention to have a CSV extention. Then when I tried to load it, the Separator Input Box would not let me enter a tab character:

Shawn_Eary_0-1751308743785.png

 

So now, I technically have two questions. 

  1. The question above regarding if it's approprite to end Tab Separated Values files with a TSV extension when using MS Fabric.
  2. The question here were I ask how I can specifiy the tab as the separator for Tab Specified Values files.

I guess the workaround for both questions right now is to end all files with the CSV extension and use the | character to separate values. The files are comming to me in CSV format, but I guess I can use Excel to quicky convert them to "CSV" using the | as separator.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

June Fabric Update Carousel

Fabric Monthly Update - June 2026

Check out the June 2026 Fabric update to learn about new features.