Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 PointsImporting Boston Marathon results. After importing I am not able to view in the spreadsheet.
Why can't I view the results on the spreadsheet?
4 Answers
Rohald van Merode
Treehouse StaffHey Sarah Schaeffer 👋
Are you using Safari by any chance? While looking into your issue I came across this community post which confirms that there is an issue with Google Sheets when using Safari and they are actively working on a fix. I tried following along with Travis his instructions in 4 different browsers and am encountering the exact same thing you're describing in Safari. Other browsers seem to be working perfectly fine so for the time being you might want to give that a shot 🙂
Hope this helps!
Travis Alstrand
Data Analysis Techdegree Graduate 45,984 PointsHey there Sarah Schaeffer !
I just followed the steps of importing the csv along with the video and didn't hit any issues. Is your spreadsheet remaining blank?
It may take a few moments for it to appear as it is a large amount of data.
Also, did you choose the "append to current spreadsheet" option when importing?
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 PointsYes it is just remaining blank and continuously says saving. I followed all the steps and was able to import it but was not able to move the spreadsheet or click on anything. Thank you for responding. I will try again.
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 PointsI have tried several more times and still no success. I was able to open it in the Numbers app but not able to follow along with the video as the apps are different.
Travis Alstrand
Data Analysis Techdegree Graduate 45,984 PointsI'm so sorry you're still hitting this issue, it's very strange! Just to be super clear, here is the exact steps I took on my end.
- Download the .csv file from the Teacher's Notes
- Go to Google Sheets and create a New Blank Sheet
- File > Import > Upload > Browse
- Select the .csv from my Downloads folder
- Changed "Import Location" to "Append to Current Sheet"
- Kept "Separator Type" as "Detect Automatically" & left "Convert text to numbers, dates, and formulas" as checked.
- Import Data button / waited for data to appear
After that I am able to click on / edit the cells. Is this the same process that you tried?
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 PointsYes. I just did the same exact thing and the spreadsheet it is till blank. The window also freezes and I am not able to do anything.