iWork Numbers: How to Open Tab Delimited CSV Files
Google adsense and many other programs export data into tab delimited CSV files. Numbers will not open these files with the correct formatting. However, with some minor preparation, Numbers will open the files perfectly.
The problem is honestly not iWork's Numbers program. The problem is that CSV files are not supposed to be tab delimited. As their name suggests, CSV files should contain Comma Seperated Values.
Although Excel does not care and has a wizard to walk the user through the import process, Numbers is a little more strict.
This is what happens if you try to load a tab delimited CSV file in Numbers:
Messy, huh?
Luckily, the fix is very easy. Tab delimited files should be in txt format. In a Finder window, click on your .csv file and rename it to a .txt file.
Now when you open the file in Numbers, you formatting will be correct.
Also see ...
Install OS X from DMG File
H3Installing OS X from a DMG file can be difficult. With leopard testing and development, many people are having troubles installing from the supplied binary. Here is how it can be accomplished./H3PInstalling OS X from a dmg file format instead of a DVD/CD format seems challenging. Here is
H3Installing OS X from a DMG file can be difficult. With leopard testing and development, many people are having troubles installing from the supplied binary. Here is how it can be accomplished./H3PInstalling OS X from a dmg file format instead of a DVD/CD format seems challenging. Here is
Mac OS X Tiger Ultimate Newbie: Single click access to Applications
H3So you've ditched Windows and got yourself a new Macintosh congratulations on such a smart move! If you're new to the Mac and are running Tiger (OS X v10.4.x), feed your need for the missing Windows Start menu with this recipe. One of the first things you'll no doubt be asking is "How the he
H3So you've ditched Windows and got yourself a new Macintosh congratulations on such a smart move! If you're new to the Mac and are running Tiger (OS X v10.4.x), feed your need for the missing Windows Start menu with this recipe. One of the first things you'll no doubt be asking is "How the he
OS X: Show hidden files and folders in Mac OS X Finder
H3I received a request to show how to show hidden files and folders in the Mac OS X finder. Using this terminal command, any OS X user can unhide all hidden files and folders. This will make them visible when browsing through Finder./H3PFirst, open Terminal. br / br /Type this command, t
H3I received a request to show how to show hidden files and folders in the Mac OS X finder. Using this terminal command, any OS X user can unhide all hidden files and folders. This will make them visible when browsing through Finder./H3PFirst, open Terminal. br / br /Type this command, t