cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
mugelbbub
Level 3

New experience reports export to excel with values stored as text and for .csv with a preceding accent character rendering both reports pretty useless without reformat?

The new experience reports supposedly export to excel and .csv BUT when doing so for excel the values are stored as text and for .csv come with a preceding accent character rendering both reports pretty useless without time consuming formatting. 
I hoped they would improve on the poor existing report exports to excel that come with unnecessary and frustrating formatting (like the old sage ones).
when asking support they say "It's not technically an issue but more of a working as designed kind of feature" 
Does anyone know if that is correct and they are supposed to export values as text? 
5 REPLIES 5
Ashleigh1
QuickBooks Team

New experience reports export to excel with values stored as text and for .csv with a preceding accent character rendering both reports pretty useless without reformat?

Hello Mugelbbub, yes this is correct it is working as designed, though it is not the best design granted, we suggest you leave feedback within the main cog wheel this gets sent straight to the developers team, this is the only option thanks.

mugelbbub
Level 3

New experience reports export to excel with values stored as text and for .csv with a preceding accent character rendering both reports pretty useless without reformat?

Hi Ashleigh1,

 

Thanks for replying.  I have left feedback in the COG already.

 

I can not believe that a financial product exporting to a spreadsheet designs it so the numbers come out as text.

Baffled!

emmam6
Moderator

New experience reports export to excel with values stored as text and for .csv with a preceding accent character rendering both reports pretty useless without reformat?

Hello Mugelbbub, Thanks for your reply. We'll pass on your comments to the product development team. Currently it would be a case of reformatting the CSV file you export.

mugelbbub
Level 3

New experience reports export to excel with values stored as text and for .csv with a preceding accent character rendering both reports pretty useless without reformat?

not just hte .csv but also with the excel file since the values are formatted as text.

 

I may not have mentioned but been exporting .cvs  from multiple different packages for over forty years and never has one exported values (particularly financial) as text.  

Usually   19.2    but never  Â£19.20  

 

and oddly in principle for your developers, the legacy reports export values to excel fine as values 19.20 albeit on a  #,##0.00 _€ format   so why do it as text now?

 

Ashleigh1
QuickBooks Team

New experience reports export to excel with values stored as text and for .csv with a preceding accent character rendering both reports pretty useless without reformat?

Hello Mugelbbub, thanks for sharing that as well, we will pass this on to the team. 

Need to get in touch?

Contact us