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

Data Analysis Data Analysis Basics Introducing Data Analysis Creating a Spreadsheet

4 Answers

Rohald van Merode
seal-mask
STAFF
.a{fill-rule:evenodd;}techdegree
Rohald van Merode
Treehouse Staff

Hey 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
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer

Hey there Sarah Schaeffer ! :wave:

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
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 Points

Yes 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
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Sarah Schaeffer
Data Analysis Techdegree Graduate 11,564 Points

I 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
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Treehouse Project Reviewer

I'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?