17. Importing Data to Excel

Overview

Getting data into Excel doesn’t have to involve creating the data yourself. In this lesson, you’ll learn how to import data from txt and csv files into Excel.

To explore more Kubicle data literacy subjects, please refer to our full library.

Summary

  1. Lesson Goal (00:13)

    The goal of this lesson is to learn how to import data into Excel from text files and csv files.

  2. Importing a Text File (00:21)

    A text file is a simple file containing data in a text format. Usually, each piece of information is separated by a character known as a delimiter. Examples of delimiters include tabs, spaces, and commas.

    When we open a text file in Excel, we can import it using the Text Import Wizard. In this wizard, we need to specify what character is used as a delimiter in the text file, and identify the format of each column in the data. Excel then converts the text file into a spreadsheet layout. Some formatting changes may be needed, but otherwise you can start using the file as a spreadsheet immediately.

  3. Importing a CSV File (01:22)

    A comma separated value, or CSV file is similar to a text file, which uses a comma as the delimiter between values. CSV files are often used as a common file format that can be interpreted by various applications.

    If we open a CSV file within Excel, we can import it through the Text Import Wizard like a text file. If we open a CSV file directly from our computer’s file system, the file should open in Excel, automatically converted to an appropriate spreadsheet format. This will work as long as Excel is set as the default program for opening CSV files on your computer.

Transcript