I downloaded an excel file and I’m trying to import a table data from one of sheets in that file. The problem is, there are a couple of other tables in the same sheet. How can I import one that I want?
I’m using “Residential and nonresidential building fire and fire loss estimates by property use and cause (2003-2014)” https://www.usfa.fema.gov/downloads/xls/statistics/residential_nonresidential_fire_loss_estimates.xlsx from US Fire Administration page https://www.usfa.fema.gov/data/statistics/order_download_data.html, and I’m trying to grab the 1st table “OVERALL Residential Building Fires - Causes” table on “Res Bldg Fire Est by Causes” tab. I can open the sheet in the import dialog (see the pic following), but I don’t know what to do next.
Please let me know if you have any good idea.