Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More

Why do CSV files downloaded to Excel appear as one sentence; Explorer converts to spreadsheet.

  • 1 reply
  • 8 have this problem
  • 1 view
  • Last reply by cor-el

more options

Downloading census data from http://censtats.census.gov/cgi-bin/bldgprmt/bldgdisp.pl comes across in Explorer directly into Excel with all columns intact. When we use Firefox 3.6.8 it comes across as an old style csv, with "" and commas separating columnar data. How do we get Firefox to import csv into Excel spreadsheet so it doesn't have to be manipulated?

Downloading census data from http://censtats.census.gov/cgi-bin/bldgprmt/bldgdisp.pl comes across in Explorer directly into Excel with all columns intact. When we use Firefox 3.6.8 it comes across as an old style csv, with "" and commas separating columnar data. How do we get Firefox to import csv into Excel spreadsheet so it doesn't have to be manipulated?

All Replies (1)

more options