We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Apple iWork 08 Tutorials
Even More Numbers / Export a Spreadsheet
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Apple iWork 08 / Even More Numbers / Export a Spreadsheet)
Let's say you built an itinerary for a trip and you want to send this off to someone else, other family members that live across the country, something like that. So again, the example here that we're dealing with is just sending, sharing information from a spreadsheet with someone else. Well, that someone else, maybe they don't have a Macintosh computer. Maybe they don't have Numbers installed. Well, what can you do? The answer is to simply export the information that is in your spreadsheet and export it to a different type of file format. The way that you do it is very simple. All you have to do is select a sheet first of all and then use the file menu to export. The ellipses there tells you that you're going to get another confirmation dialog box where you then select to export either to Excel, to a comma-separated value file or a pdf. And each one of these are explained and you'll export these in different situations. Obviously, if the other person has Excel or needs to make edits to the spreadsheet, you probably want to export it to Excel. CSV is most often used for exchanging information, so I have information, maybe a set of contacts or tasks or something like that that I'm going to take from one program, Numbers, and put them into another program, maybe an online contacts database, something like that. Usually CSV is a way to exchange information from one program to another that works pretty well cross platform. Pdf is a way to just simply get information in a very visually appealing way from point A to point B, even though that point B might not have the exact same application. All they need is an Adobe Acrobat pdf viewer. So image quality, layout, all sheets, current sheet. Again, you have a choice here. Usually you just want to send one sheet, but, you know, again, it can sometimes be multiple sheets. Choose pdf, choose next, you'll choose where to export this to. Let's just throw it on the desktop and we'll export it and bingo and now let's look at what we've done here. Here we are back to the desktop and on a Macintosh computer. Our application that deals with pdf's in the preview application. So we can open this up very easily on a Macintosh. If this was sent to a Windows computer, then most likely the Adobe Acrobat viewer would go ahead and launch. So this is what we've got. This did not export to a single sheet and again, you can modify this. You can use some of the lessons we learned earlier with modifying your page layout so that it will export to one sheet if you so desire, but as it stands right now, we certainly have all the information there from this nice graphical layout and the table below. It's just that the table was split into four different pages. That's how you do it. That's how you do an export. Again, pretty straightforward. With the options you have in Numbers, you don't have to worry about compatibility issues. You can go ahead and use this application, generate your spreadsheets and export them to other file formats if need be.
Tutorial Information
| Course: | Apple iWork 08 |
| Author: | Brian Culp |
| SKU: | 33851 |
| ISBN: | 1-934743-50-X |
| Release Date: | 2008-02-07 |
| Duration: | 6.5 hrs / 105 lessons |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
