The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

Go Back   The Omni Group Forums > OmniOutliner > OmniOutliner 3 for Mac
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
Export oo3 to excel format Thread Tools Search this Thread Display Modes
How do I export oo3 files to excel format? I downloaded the .zip file from the website / double clicked and tried to export a file to excel - nada.

What am I missing on my MBP?

Thanks
 
Dbl-clicking the OmniOutliner Exports Plugin zip archive file will decompress its contents - generating a folder called Exports plugin which contains instructions and a subfolder (Exports Plugin.ooxsl) which you need to move to HOME/Library/Application Support/OmniOutliner 3/Plug-Ins/

As long are you are running OO3 Professional, Microsoft Excel (XML) will then be one of the file formats available under File > Export

--

Last edited by RobTrew; 2010-09-23 at 01:55 AM.. Reason: Clarification in case unzipping is unfamiliar
 
Does the Excel export work with Excel 2011?
 
No.

(It generates an .xml (rather than .xlsx) file with a content which looks promising enough:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<Workbook xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:o="urn:schemas-microsoft-com:office:office">
but the verdict given by Excel 2011 is that it is not a valid Excel spreadsheet, and manually changing the extension to .xlsx doesn't solve the problem)

You can, however, export from oo3 to .csv, and successfully import the .csv file into Excel 2011.

--
 
Yeah, I tried the CSV route, but as my outline has multiple columns, I lose them in the import.
 
Quote:
Originally Posted by kevinpcook View Post
Yeah, I tried the CSV route, but as my outline has multiple columns, I lose them in the import.
That sounds frustrating, but there should be no problem at all with multiple columns.

With three columns in oo3 - one text and two numeric, I am finding that File > Export > CSV generates a file that contains the data and a header for all three columns.

I am also finding that in Excel 2011 File > Import > CSV File is having no difficulty in reading all three columns into good Excel data, textual and numeric.
 
Thanks for the guidance on adding the Excel Export plug-in.

I had to manually add the /Plug-ins/ directory as my oo3 Pro directory did not already have that.

But, I re-start oo3 and there is no Excel choice in the dropdown box.

Perhaps I need to re-boot the computer?
 
Hi,

I need to export my 6 column OO file into an XML table, but I need to carry over some stylings too. I need BOLD, and hopefully Font COLOR and SIZE as well.

Is there anyone here who could write this plug-in? I bet it'd be useful to a lot of people!

Would it be a simple matter of modifying the Excel export plug-in?

Jmz
 
Could I used the XML export plugin to export and then import into another table-generating program like Open Office?
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Export, metcalfjohn OmniOutliner 3 for Mac 2 2012-07-19 11:03 AM
Excel export is incomplete shahW OmniOutliner 3 for Mac 3 2011-08-23 07:04 PM
Excel export and Excel 12 on Mac? gbp OmniOutliner 3 for Mac 6 2009-11-12 04:35 PM
CSV export not importable by Mac Excel 2008 Flexattend OmniFocus 1 for Mac 1 2009-09-13 03:10 PM
HTML Task Report - export to Excel? rsabella OmniPlan General 1 2007-07-24 12:21 PM


All times are GMT -8. The time now is 07:51 AM.


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