Excel 2010 Essentials: Import and Export Data in Excel


show more Importing and exporting data in Excel provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training show less
please wait ...

Importing and exporting data in Excel

Although you can copy and paste data in and out of Excel like you can in almost every other program, Excel lets you take this a step further using its Import and Export features. These features are useful when you have to share data with programs that don't work directly with Excel. Maybe they don't recognize Excel's file format. So let's say we get info from a database and we need to bring that data into this worksheet. We are going to start by importing here into Cell A5. But before we do that I want you to see what the raw data will look like.

I have this file open here in Windows Notepad and you can see the file here as importdata.txt and the first line here, these are our column headers, Last Name, and First Name and so forth and you can look here and you can see we have last names, first names, department and so on. Now we have two of these files in the Chapter 8 folder of the Exercise Files. import data.txt, a text file, and also import data.csv. CSV stands for Comm...

Importing and exporting data in Excel
Video duration: 8m 2s 6h 21m Beginner

Viewers:

Importing and exporting data in Excel provides you with in-depth training on Business. Taught by Bob Flisser as part of the Excel 2010 Essential Training

Subjects:
Business Education + Elearning
Software:
Excel
Author:
please wait ...