Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I find that the Excel spreadsheets generated by Quickbooks aren't searchable in Excel. Has anyone else had that problem?
Hi there, @nmp222.
Thanks for reaching out to the QuickBooks Community. I'm here to help provide some insights about the excel spreadsheets in QuickBooks.
Are you trying to export reports from QuickBooks Desktop to Microsoft Excel and the option for excel is grayed out? If so, you have an option to export to a comma separated values (.csv) file.
Here's how:
For additional reference, you can check these articles:
If you're referring to something else, any details you can provide is extremely helpful for us to narrow things down.
I'll be around to help if you have any other questions about exporting to excel. Have a good one.
Actually that's not the issue. The spreadsheets get generated but when you try to do a find in Excel that sometimes doesn't work very well with numbers. It's as if the spreadsheet doesn't recognize them.
I can generate the Excel Spreadsheet but when I try to do a find, especially on an number, Excel seems to have a tough time with it.
I don't have a problem generating the work sheets but I have a hard time doing a find on them. Numbers don't seem to register with Excel as being searchable.
Hello there, @nmp222.
Please allow me to join the thread and help share information about exporting reports to Excel.
For you to search for something in Excel, you can simply click anywhere on the Excel page and press on Ctrl+F on your keyboard.
Since you're able to export the report to Excel successfully, but the numbers are not searchable, the problem here is within your Microsoft Excel.
To investigate and verify this further securely, it would be best if you can contact with Microsoft Excel Support.
On the other hand, to learn more about exporting reports to Excel, you can check this article: Export report from QuickBooks Desktop to Microsoft Excel.
In addition, for your future reference about QuickBooks Desktop, you may check our Help articles: Help articles for QuickBooks Desktop.
Keep posted if you have any other questions about exporting reports to Excel, I'll be always here to help you. Wishing you the best!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here