Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you have a spreadsheet created using another application such as Microsoft Excel or Apple Works 6 for example, you can open those files directly from within Numbers '09. Let's explore opening other formats by clicking the File menu and then select Open. We will browse to the 02_02 folder of the Exercise Files where we find two different formats; one is an Excel file, the other a text file using Comma Separated Values. That's the CSV extension. We can also bring in tab-delimited files and .OFX files if we need to.
Let's start with our Microsoft Excel file. Click once to select it, then click Open, and the file will be opened in Numbers '09. Conversions do take place and you may see Document Warnings. Here we see one Import Warning, Frozen panes or split windows are not supported, so they were removed once this document was imported into Numbers '09. We can clear those messages before closing the Document Warnings window. Another option is to drag files directly into an existing spreadsheet. First, let's move to the left hand side and click Realtor Comparison. Here we see a blank table. Now we'll access our Exercise Files directly from Finder, and let's drag the CSV file into the sheet.
Now we can drag it directly into the sheet to create a new table or drag it into an existing table. With the top left corner cell selected, let's release to import that data into the existing table. Now we can close the Exercise Files folder to return to our spreadsheet. So importing other formats is very simple here in Numbers '09. If you have existing files in other formats, open them directly in Numbers '09 to work with them here.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 74637 Viewers
80 Video lessons · 129800 Viewers
52 Video lessons · 64009 Viewers
59 Video lessons · 49792 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.