From the course: Excel 2010 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Importing and exporting data in Excel - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
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 Comma Separated…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.