From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Import TXT or CSV data into an existing workbook
From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019
Import TXT or CSV data into an existing workbook
- [Instructor] Importing data from a text tab delimited file, or a comma separated value file into an existing workbook is very easy to do in Excel 2019. Let's jump right into our import workbook, and go through the steps of importing the information from our merchandise .csv file into our existing worksheet. I'll go ahead and click in cell A7, because that's where I'd like the information to come into the worksheet. Let's go to data, and in our Get and Transform Data group, we have From Text and .CSV. I'll go ahead and click on that, navigate to my chapter two folder, I'll select the merchandise .csv file. Notice it is a text file. Click import. Excel is connecting to that document and giving me a preview of the data that will be imported into my merchandise worksheet. Excel has picked up on my data being separated by a comma. Anywhere there was a comma in the data, a new column has been created. I have the .csv file open, I want to take a look at it before we bring the information…
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.
Contents
-
-
-
-
Import TXT or CSV data into a new workbook3m 22s
-
Import TXT or CSV data into an existing workbook3m 7s
-
Search for data within a workbook2m 36s
-
Navigate data with named ranges and hyperlinks5m 27s
-
Format worksheets and workbooks5m 1s
-
Customize headers and footers4m 37s
-
Display and modify content in different views5m
-
Modify basic workbook properties2m 33s
-
Customize the Quick Access Toolbar3m 55s
-
Inspect and export workbooks6m 33s
-
Configure print settings4m 15s
-
Challenge: Manage worksheets and workbooks1m 10s
-
Solution: Manage worksheets and workbooks9m 10s
-
-
-
-
-
-
-