Export to Excel from Quickbooks
Export to Excel from Quickbooks
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).
Edited to remove All Caps (TheGurkha, Moderator).
Openoffice org 3.2.0
Mac OS X 10.6.2
Mac OS X 10.6.2
Re: Export to Excel from Quickbooks
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.
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
Gurkha Welfare Trust
Re: Export to Excel from Quickbooks
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"
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Export to Excel from Quickbooks
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
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
Mac OS X 10.6.2
Re: Export to Excel from Quickbooks
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
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Export to Excel from Quickbooks
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
Mac OS X 10.6.2
Re: Export to Excel from Quickbooks
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Export to Excel from Quickbooks
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
Re: Export to Excel from Quickbooks
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.pstoll wrote:As I stated in my question, I do not own Excel, so how could I export to it? to: TheGurkha
Ubuntu 14.10 Utopic Unicorn, LibreOffice Version: 4.3.3.2
Gurkha Welfare Trust
Gurkha Welfare Trust
Re: Export to Excel from Quickbooks
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.TheGurkha wrote:Most other programs that export to different formats don't rely on the target application being installed for the export to work.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Export to Excel from Quickbooks
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.
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
Open Office 4.01 on Mac Snow Leopard
Windows running as virtual machine (Parallels) in Snow Leopard on a Mac Pro
Re: Export to Excel from Quickbooks
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.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
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice