Skip to content
← For small businesses

Enter your idea

For small businesses: Accounting features

Categories

(thinking…)

Reporting | Excel Export - Remove formatting

Please remove font size formatting and merged cells from excel exporting and open the exported spreadsheet at 100%.

18 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Janet Hiern shared this idea  ·   ·  Report…  ·  Admin →
delivered  ·  AdminKelly Munro (Community Manager, Xero) responded  · 

Hi team, rounding back to confirm that the changes shared last week have now been rolled out and you'll find the next time you export a report from Xero to Excel that the formatting will be a little different. To recap the updates we've made;

  • The report will now default to 100% zoom (rather than 150%),
  • we've adjusted the size of title and currency fonts for ease of reading, and 
  • made slight changes to the formatting of cells in rows for consistency across the report

Thanks again for your feedback on the site, and if you'd like to support and follow any updates on merged cells, join in the idea here 🙂

Show previous admin responses (2)
Comments are closed An error occurred while saving the comment
  • Claudine Kimber commented  ·   ·  Report

    This is absolutely horrible to work with. It’s making our job harder not easier. I feel like Xero is going backwards.

  • Janet Hiern commented  ·   ·  Report

    Thanks for the update. I will express again the inconvenience of having to unmerge in every report, ever time. Surely Xero can create a report with unwrapped text formatting that spills into the next cell? Just leave the next cell empty. More than half the time reports are used for information not presentation and most people using Xero would have figured out using a spreadsheet formatting

  • Susanna Swan commented  ·   ·  Report

    It'd be great to get the 'merge cells' removed! To work with the data you then have to unmerge everything first and then work with it. 'align & centre' achieves exactly the same look on the reports but doesn't mess with selections etc.

  • Jackie Mahon commented  ·   ·  Report

    I agree the new formatting on the reports is apalling

  • Carmen Lewis commented  ·   ·  Report

    Can you please change the new Aged Receivables Report so that it exports to excel the same as the old one. The old one exports perfectly into excel, when you export the new one, it doesn't have any vertical grid lines, the numbers down the left hand side are all compacted together, the zoom is 150% but if you reduce it to 100% the writing is tiny, and and if you remove one of the columns the total doesn't update, like the old one.

  • Kielan Faria commented  ·   ·  Report

    The new Bank Reconciliation Summary report is formatted badly when exporting to Excel.

    The formatting is really big and spacey. Withdrawals are shown '(200.00)' instead of '-$200.00' and this confuses clients.

    Overall the report is visually unpleasant. Reverting to the old format would be greatly appreciated.

    Example attached.