Export to Excel from Quickbooks

Discuss the spreadsheet application
Post Reply
pstoll
Posts: 3
Joined: Sat Mar 13, 2010 8:01 pm

Export to Excel from Quickbooks

Post by pstoll »

I am a QB Mac user. There is a functionality in QB that supports exporting reports to Excel which I do not have nor want. Is there some way within OpenOffice to have this occur? I have also posted this question on the QB forums.

Edited to remove All Caps (TheGurkha, Moderator).
Openoffice org 3.2.0
Mac OS X 10.6.2
User avatar
TheGurkha
Volunteer
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Export to Excel from Quickbooks

Post by TheGurkha »

Have you tried to export from Quickbooks to Excel and then use Calc to open the Excel .wks document?

If this has answered your question please go to your first post and use the Edit button, and add [Solved] to the start of the title. You can use the green tick icon at the same time if you like.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to Excel from Quickbooks

Post by Villeroy »

Excel does not need to support QB nor does Calc. QB utilizes an installed Excel application in order generate xls files.
QB is founded on a database. There areODBC drivers to allow access from other database applications such as OOo Base. OOo Base serves as a bridge to Calc and Writer. Using Base via ODBC you can define your own database reports.
Google "Quickbooks +ODBC"
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
pstoll
Posts: 3
Joined: Sat Mar 13, 2010 8:01 pm

Re: Export to Excel from Quickbooks

Post by pstoll »

To all who have replied:

As I stated in my question, I do not own Excel, so how could I export to it? to: TheGurkha

Insofar as the ODBC thing goes, I am unable to find anything that I can use for MY MAC. They all appear to be windows-related interfaces
Openoffice org 3.2.0
Mac OS X 10.6.2
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to Excel from Quickbooks

Post by Villeroy »

If QB is distributed for the Mac then there should be an ODBC drivers for that platform as well.
Search the QB home: http://quickbooks.intuit.com/search/sma ... stid=19158
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
pstoll
Posts: 3
Joined: Sat Mar 13, 2010 8:01 pm

Re: Export to Excel from Quickbooks

Post by pstoll »

I have now been able to determine, absolutely, that there is NO ODBC for QB and the Mac!!!
Openoffice org 3.2.0
Mac OS X 10.6.2
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to Excel from Quickbooks

Post by Villeroy »

Welcome to the wonderful world of proprietary software.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
RoryOF
Moderator
Posts: 35079
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Export to Excel from Quickbooks

Post by RoryOF »

If the information is exported in .csv format, then OOo Calc can read this, whether you have Excel or not. My limited information on Quickbooks (v6) tells me that QB exports data in Intuit Interchange Format (IIF) and that customising an IIF file or writing a translator is complex; it suggests it may frequently be quicker to hand enter the data.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.5 LTS
User avatar
TheGurkha
Volunteer
Posts: 6482
Joined: Thu Mar 13, 2008 12:13 pm
Location: North Wales, UK.

Re: Export to Excel from Quickbooks

Post by TheGurkha »

pstoll wrote:As I stated in my question, I do not own Excel, so how could I export to it? to: TheGurkha
my mistake. I didn't realise QB needed Excel to be able to export to that format. Most other programs that export to different formats don't rely on the target application being installed for the export to work. If QB had been able to export to the xls format OOo Calc would have opened it.
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to Excel from Quickbooks

Post by Villeroy »

TheGurkha wrote:Most other programs that export to different formats don't rely on the target application being installed for the export to work.
I'd rather say that using an installed MS Office is the way how "export to xls/doc" is implemented in 99% of all cases. It is very easy to code with the simple assumption that someone who wants xls/doc has Excel/Word. WIthout the MS software being installed, the programmer has to implement details of the binary file formats which can be very difficult as we know.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
JimV
Posts: 1
Joined: Fri Jul 25, 2014 12:11 am

Re: Export to Excel from Quickbooks

Post by JimV »

For the recent Windows versions of Quickbooks at least, select the "Create a comma separated file" option and save the resulting file, then open the file created with Open Office. Be sure to select the "comma" option in the process of opening the file into Open Office. The immediate result is not as pretty as the Excel export option would be, but all the information is there and you can make it look as pretty as you want within the limits of Open Office
Last edited by thomasjk on Fri Jul 25, 2014 6:59 pm, edited 1 time in total.
Reason: Removed Green Check mark reserved for solved threads.
Open Office 4.1 on Windows XP
Open Office 4.01 on Mac Snow Leopard
Windows running as virtual machine (Parallels) in Snow Leopard on a Mac Pro
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Export to Excel from Quickbooks

Post by Villeroy »

JimV wrote:For the recent Windows versions of Quickbooks at least, select the "Create a comma separated file" option and save the resulting file, then open the file created with Open Office. Be sure to select the "comma" option in the process of opening the file into Open Office. The immediate result is not as pretty as the Excel export option would be, but all the information is there and you can make it look as pretty as you want within the limits of Open Office
You can even have a perfectly layouted professional report with charts, statistics, company logo, vertical or horizontal layout, grouping and everything Writer and/or Calc has to offer. But this would involve the database component which most users shy away from.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply