Problem opening .csv file with Excel from webpage
Hello, When I try to open .csv file using Excel all data are loaded to one column. If I do the same in Internet Explorer (whcih I don't want to use) or if I save the file and then open it in Excel, it works fine. Any idea how to fix it? /Bartek
Hello,
When I try to open .csv file using Excel all data are loaded to one column. If I do the same in Internet Explorer (whcih I don't want to use) or if I save the file and then open it in Excel, it works fine.
Any idea how to fix it?
/Bartek
Alla svar (2)
Hi,
I've already had this problem. you have to do file \ open and you can choose the delimiter format and get several columns
Best regard
The problem is not with Excel. It is when I try to open .csv file from Internet via Firefox without saving it.