spreadsheets

Importing Data Into a Spreadsheet

Many government agencies and private organizations provide data on their websites in a spreadsheet or other format that you can download onto your computer.

See our guide on Databases of Statistical Information for locating websites with demographic and other data, including data that can be downloaded as a spreadsheet or in a format like .csv (which stands for comma separated values), which then can be easily imported into a spreadsheet program.

To import a spreadsheet, .csv or other file you've downloaded on your computer into a Google Docs spreadsheet, first create a new spreadsheet in Google Docs. Then in the menu at the top click on File...Import and then Browse and select the downloaded file.

Note: You also can import data on a website directly into a Google Docs spreadsheet. For instructions on doing that, see the section on Functions later in this tutorial.