Export .xlsx file from Quickbooks

[awascholl]

I use Quickbooks desktop on Windows, and I can export to an .xlsx file if I have Excel. However, on my new computer, I don't have it, and I prefer not to, but my only option is to export to a .csv file which I then have to format.

Is it possible to get Quickbooks to recognize OpenOffice as a means for exporting?

Edit: Changed subject, was Exporting to Quickbooks?  Make your post understandable by others  -- MrProgrammer, forum moderator

[John_Ha]

I assume you mean importing from Quickbooks.

AOO can open both xlsx and csv files. Try it.

[awascholl]

I assume you mean importing from Quickbooks.

AOO can open both xlsx and csv files. Try it.

Yes, you're right, exporting from Quickbooks.

However, Quickbooks is set up to export to .xlsx only if I have Microsoft Excel installed, which is what I hope to change if I can find an option.

[MrProgrammer]

However, Quickbooks is set up to export to .xlsx only if I have Microsoft Excel installed, which is what I hope to change if I can find an option.

I suspect that Quickbooks calls Excel to create the .xlsx file. Thus if Excel is not available on your computer Quickbooks can only offer .csv as an option. The question has nothing to do with OpenOffice. It is a Quickbooks question and you should ask them why their software has this restriction. And you can ask them to offer creation of .ods files if OpenOffice is installed. There is no reason Quickbooks can't call OpenOffice to create .ods files. Tell them that millions of people use OpenOffice.

[Example] Loading CSV into preformatted spreadsheets

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.