Downloading/Opening .csv file using Google chrome, it changes extension of .csv file to .xls

user_2642351 0
Viewed 7954

I have an a tag in my html file that is pointed to a .csv file. Every time I click on the link it downloads the same file in .xls extension. Why?

I tried the following: 

<a href="./example.csv" target="_blank">File download</a>
<a href="./example.csv" download>File download</a>
<a href="./example.csv" type="text/comma-separated-values">File download</a>
<a href="./example.csv" type="text/csv">File download</a>

I tried to open the file with the file:///myfolder/example.csv protocol but all of these had the same outcome.

Whereas in Firefox, IE, Edge this downloads the file in .csv extension.

How can I get chrome to download the .csv file in the .csv extension?

anchor google-chrome csv download html
2 Answers

Locally on Windows 10 machine Google Chrome downloaded .csv file with .xls extension. But when I uploaded the same project to GitHub Pages, Google Chrome started downloading file with correct .csv extension.

So the solution is either in webserver settings or just to test outside of the local environment.

user_32833700

I didn't find any solution for it so I have made a work around:

      if (fileType === 'text/csv') {
        FileSaver.saveAs(newBlob, `${data}.csv`);
      } else {
        FileSaver.saveAs(newBlob, `${data}`);
      }

This is working for me, if you find that browser makes the same issue for any other file and this file is not csv, try to implement it like this and it will also work.

user_123953390
Related