Wednesday, May 8, 2013

GettingDataFromTheInternet


There are many places to get data.  Here are a few places that I like to get data....and put it in your google drive as a spreadsheet


- KidsCount "Data Across the States"  compare something for all 50 states



How to get it to a Google Spreadsheet????
(remember, everything should be in a separate column)
(start using keyboard shortcuts....like control C or command C....)
A) Try copy & paste

didn't work???
B) Find someplace in the original that says "download data" or "raw data" and click on that.
If it opens, try to copy & paste that

didn't work??
C) find an office program on the computer (LibreOffice, OpenOffice...). 
Open its spreadsheet program (might be called "Calc" or "Numbers" or...)
Open the downloaded data (file...open...find the file that you downloaded)
Copy & Paste the data from that spreadsheet


D) You might be able to upload & convert an Excel file to Google Drive...so if the data was downloaded as Excel, go to Google Drive and click "Upload".....you have to make your "Upload Setings" (top right "gear' in Drive) are on "Convert"

No comments: