How to Import Data From CSV or Text Files in Excel


show more Importing data from comma separated value (CSV) or text files provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Importing data from comma separated value (CSV) or text files

When you work with colleagues in other departments or other companies, they might not have access to Microsoft Excel. If that's the case, they might save their data to a text file for you to read into Excel. You can bring that data in using the Text Import Wizard. So I have opened just a blank new workbook. I haven't saved it. That's why it's called Workbook 1, and what I'm going to do is bring in the data from the outside file. To do that, you click the Data tab on the Ribbon, and then in the External Data Sources group, you click Text.

This is a CSV file, which means comma- separated values, and that is a form of a text file. So I click Text. When I do, Excel enables me to select the file I want to bring in, and in this case that file is called ImportCSV, and you'll see that it's noted that it's a comma-separated values file. And I'll click Get Data to start the Text Import Wizard. And I'll just bring it down a little bit. The Text Import Wizard allo...

Importing data from comma separated value (CSV) or text files
Video duration: 4m 20s 6h 32m Beginner

Viewers:

Importing data from comma separated value (CSV) or text files provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...