Learn

Many datasets are stored in formats other than Excel’s XLSX format. One of the most common storage formats used across the data science world is the CSV or comma-separated values format.

A CSV file is a text file containing data where the columns of data are separated by commas. Here’s a sample of what a CSV file might look like if you open it up in a text editor:

month,sales,costs Jan,1000,500 Feb,2000,800

Here’s what this same CSV file looks like interpreted as a table:

month sales cost
Jan 1000 500
Feb 2000 800

While CSV files can be opened directly in Excel, certain Excel features won’t work until the file is converted to Excel’s format. We recommend using Excel’s import tool instead. We’ve placed a slideshow illustrating this process in the learning environment. Note that some of the buttons and menus might look slightly different depending on your operating system and version of Excel.

When you’re ready to practice this yourself, get started on the instructions below!

Instructions

When you’re ready to practice what you’ve learned, download and work through our exercise spreadsheet.

Note that for this exercise, you will also need to download this CSV file.

Feel free to download our solutions spreadsheet to compare your work to ours! Note that you might get an External data connections have been disabled warning. When we imported the CSV, that established a connection between Excel and the CSV file. You can ignore this warning.

When you are ready to learn more, select Next!

Take this course for free

Mini Info Outline Icon
By signing up for Codecademy, you agree to Codecademy's Terms of Service & Privacy Policy.

Or sign up using:

Already have an account?