Restaurant Data Formatting
I was wondering if anyone can offer any advice on how to use the Restaurant Inspection Data. The "WebExtract.txt" file seems to contain the brunt of the data, yet I've been unable to import it properly into Excel or a Fusion Table (my end goal). Opening in Excel and saving as a.csv, followed by importing to Fusion Tables seem to work either - the rows are properly imported, but all the data is in one cell (I'm guessing it delimits by the return and ignores the commas).
Any tips on how to format that data / get it into a fusion table?