Importing and Exporting Data - Free Microsoft Excel 2007 Tutorial

by Jeremy Reis on Tuesday, September 25, 2007

Importing and Exporting Data

One of the powerful features of Microsoft Excel is the ability to import and export data. You could have data in a different file format or an export from your corporate accounting system and want to analyze the data – Excel can import from dozens of formats.

In a later tutorial, we explore importing data in a business context. First, we’ll give you the generic steps required to import data.

There are two methods to import data: from an existing file or from a data source.

Importing Data from an Existing File

1. Click the Office button.

2. Click the Open button.

3. Navigate to the folder containing the file you want to open.

4. Select the file. If you don’t see the file you want to open, pull down the All Excel Files menu to the right and select the format the file is in. Once you see the file, select it.

5. Click Open.

You should now see the file:

Page 8 of 23

Comments

 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
It is a good web site
Your site is very nice i appriate you
298 out of 534 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Good material
I like your learningthat page.  I think it has been very helpful.
Thanks for all the hard work.
270 out of 487 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
free courses
it it very interesting and there are a lot of people that do not have the funds for expensive colleges that can learn from you - sorry some courses are not credited or certification,but it's coool.
249 out of 462 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Thanks lot
thank you for assisting..
238 out of 453 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
appreciation
i'm so thankfull of the respected one running this website. here is so useful matirials that can help people get better.
195 out of 369 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Thanks!
Very nice intro!
183 out of 347 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Cool Tut
I really got usefull from this Tut
183 out of 354 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
learning point
I want to learn computer fundamental, jut like to how to create a folder and hide a folder and show it
164 out of 321 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
excel
excel is a wonderful program but it is being taught to me by an idiot thats why it is taking a whole semester to learn
139 out of 276 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Commendation
I want to let you all know that you are doing a great job at Learnthat. Keep up the good work
111 out of 226 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
very useful
I enjoyed this free tutorial and am looking forward to taking an intermediate one.
107 out of 215 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Nice
Nice topic
Thanks
I have found two interesting sources (  http://fileshunt.com and http://filesfinds.com ) and would like to give the benefit of my experience to you.  
86 out of 169 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Thanks for the great job
This is a great job..too informative...Thanks a lot
89 out of 172 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Thank you very much
Thank you for the free tutorial.  Didn't know ANYTHING about excel before and an honestly say it helped me in starting out!
:)
78 out of 155 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Logical Progression of Introductory Material
You have created a user-friendly intro to Excel 2007 that allows the learner to access the information in a sequence that answers questions the normal inquisitive user would have.

Kudos!  
79 out of 155 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
thanku
iam the original commentand hear to licence
71 out of 138 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
what about access 2003
i didn't saw any of it why don't you prepare for it. please!!!
71 out of 130 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Kuno ndi ku Malawi
Taonga peji yinu njiwemi - njakusambizga. Kweni sazgirani Excel ma Macros.
Yewo!!!
62 out of 117 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Mr. Anonymous
Yes it's really good. Thank you. pliz, include more downloads.
63 out of 115 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Miss Anonymous
Yes the free tut is really helping, i really appreciate. keep the good work. Kudos to u all
53 out of 105 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Thank you
Well, the course is free. What face can use to make a complain
37 out of 73 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
certificate
do i have a certificate on this course
25 out of 51 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
cool
Excel is very important software for calculation.
23 out of 44 people found this comment informative.
 Rate This Post:    Rate This Comment as Good Rate This Comment as Bad
Thanks you Very Much
This web site is on of the best web site it is relly helpfull we learned more and more from this web site
6 out of 14 people found this comment informative.

Add a Comment to This Article

Anonymous (Please Login to Post With Your Account)

      
HTML not permitted, some code allowed in [brackets]:
[b]bold[/b] , [i]italicized[/i], [br] line break, other formatting...


Code Image - Please contact webmaster if you have problems seeing this image code Load New Code
Please enter the code above
 
Please submit your comment only once, some comments may be reviewed by moderators
That Network: Interactive Internet Publishing Network DefineThat.com: free technical definitions define wordsExamPractice.com: free certification news and practice exams   Explorestartups.com: find free business plans and business ideas   GiveThat.com: free gift ideas, birthday, Christmas, holidays  helpthat: got questions, we got answers   Jerm.com: entrepreneurship blog   learnthat.com: free software tutorials  mytutorials.com: collaborative write your own tutorials  Publishondemand.net: free publish on demand print on demand pod comparison   Romancetips.com: free romantic tips, advice, dating, date ideas, free romance   seekthat: free technical search engine   selfpublishthat: publish on demand   startupwatch: profiles of new companies   thatgear.com: gadget and electronic reviews   tutorialguru.com: free tutorials