The Omni Group Forums

The Omni Group Forums (http://forums.omnigroup.com/index.php)
-   OmniFocus 1 for Mac (http://forums.omnigroup.com/forumdisplay.php?f=38)
-   -   CSV export not importable by Mac Excel 2008 (http://forums.omnigroup.com/showthread.php?t=13835)

Flexattend 2009-09-12 10:37 PM

CSV export not importable by Mac Excel 2008
 
Excel 2008 does not recognize either of the two CSV file types which OF allows.

The workaround appears to be to open the CSV file with TextEdit, copy it to Excel, and clean it up with Excel's Text to Columns feature.

Still, it seems odd that OF's export file is not readable by Mac Excel.

Has anyone else run into this problem?

brianogilvie 2009-09-13 02:10 PM

[QUOTE=Flexattend;66735]Excel 2008 does not recognize either of the two CSV file types which OF allows.... Has anyone else run into this problem?[/QUOTE]

Opening a CSV file works fine for me in Excel 2008 v. 12.1.3. I exported the file from OmniFocus 1.7.3 and dragged it onto the Excel icon in my Dock.

It's true that if you use File > Open..., the CSV file is not listed as a readable type. But if you choose "All Files" in the popup at the bottom of the dialog, you can select the file and it will open.

I'm not sure why this happens and I don't have time to figure it out, but the problem is not with OmniFocus. I just exported a CSV from Numbers and Excel claims that it is not a readable file. The problem is with Excel or Office (surprise, surprise...).


All times are GMT -8. The time now is 01:15 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2024, vBulletin Solutions, Inc.