Welcome to the CSC Q&A, on our server named in honor of Ada Lovelace. Write great code! Get help and give help!
It is our choices... that show what we truly are, far more than our abilities.


+10 votes

As I am working with the FEMA Dataset, my Excel is not allowing me to save it as a txt file or a csv file because the workbook has "too many sheets". This is only allowing me to save the "active sheet". Does anybody know how to fix this?

asked in DATA360_Spring2019 by (1 point)

2 Answers

+4 votes
Best answer

CSV files are a "simpler" version of an excel file. CSV files can only have one sheet in them so if you try to save the fema data excel file as a CSV file it will only save the sheet you have pulled up. For this assignment you should only need to have the "MSFEMA" sheet so if you make that your active sheet and save it as a CSV and just press okay, the resulting CSV file will be what you need.

answered by (1 point)
selected by
+3 votes

Here is the link to the .csv file that I exported from the given dataset. I hope this helps.
> https://drive.google.com/open?id=1DoCAoBTIQmOgLuoQg0TtQmC-Q5RPtRc4

answered by (1 point)