How do I export a report to Excel?
With the Data button on the report screen: it downloads an Excel sheet where the amounts are numbers that can be added up and the dates are dates that can be sorted. The arrow on its right lets you choose CSV, the same content in plain text to load into another programme. It is done from Management → Reports.
How do I do it?
- Open the Reports group in the menu and click Reports.
- Click Run on the record of the report you want.
- Fill in the details the window asks for.
- Click Data.
The browser downloads the file. The name is the report title followed by the date, for example Ventas-por-cliente-20260731.xlsx.
Data gives Excel the first time. For the other format, click the arrow attached on its right and choose Excel or CSV: the file downloads and, from then on, the Data button gives the one you chose last.
If you have steps applied in Query, the sheet comes out with them: the same records you see in the View.
From the on-screen report (Report) the two buttons are also there, at the top, next to Back to the report: they download the same report with the same data you are looking at.
What does the Excel file contain?
It contains the same as what you get when you click View, with the title at the top and the row of column names fixed as you scroll down the sheet:
- Amounts and quantities are numbers, with the decimals and thousands you see on screen. The column adds up on its own.
- Percentages are percentages (‘12 %’ is 0.12 for the sheet).
- A column of dates comes out as a date: it sorts by date and not by the day of the month.
- What isn’t a number —a dash, ‘several’, the label of a total— stays as text, just as it is.
- A code (customer, item) stays as text, with its leading zeros.
- Subtotals and the total go in their place and in bold, as in the PDF. If you tick Totals only, only that line per group comes out.
What is the CSV for, then?
The CSV is the same content in a text file: it comes out in UTF-8 and separated by semicolons, which is what a spreadsheet in Spanish expects, so it opens with a double click. Use it when you are going to load the data into another programme. In the CSV everything is text: if you are going to do sums, choose Excel.
The semicolon isn’t a whim: in Spanish the comma is the decimal separator, so a file separated by commas can’t be read without the amounts being split in half. If your spreadsheet is set up in English, the separator it expects is the comma: in that case you have to use the data import and tell it to use semicolon as the separator.
What about reports that aren’t listings?
They also have Excel and CSV next to the PDF: those in Warehouse reports (stock, catalogue, inventory at a date, purchase forecast, batch traceability), the accounting ones (balance sheets, journal, ledger statements, chart of accounts, official books), the open items, the cash count, the CRM reports and listings and the mailing listings.
What doesn’t come out in Excel is what isn’t a table: the notes to the annual accounts and the tax forms, which are documents.
How many rows can it have?
An Excel sheet allows 1,048,576 rows. A longer report isn’t generated in Excel: the message asks you to get it as CSV, which has no such limit, or to narrow down the details in the window.
If something goes wrong
| What you see | What has happened | What to do |
|---|---|---|
| Nothing downloads when you click Data | The report returned no rows | Click View to check there is data |
| ‘The report takes … rows and an Excel sheet allows …’ | It exceeds the Excel limit | Get it as CSV or narrow down the details |
| The whole CSV falls into one column | Your spreadsheet is in English and was expecting the comma | Import it, setting semicolon as the separator |
| Accented characters in the CSV come out wrong | You opened it with a programme that ignores the UTF-8 mark | Open it with the spreadsheet, or import it setting UTF-8; or use Excel |
| Rows are missing at the end | The result was truncated by the row limit | Narrow it down with the details the window asks for and get several files |
See also: Run a report · Create a custom report · Where each report is
More about Reports
- How do I group and total a report?
- How do I see what share of the year’s sales falls in a period?
- How do I change the design of an invoice?
- How do I create a custom report?
- Where is each report?
- How do I choose which layout a document is printed with?
- How do I print labels?
- Running reports and formatting documents
- The standard reports in each area
- How do I run a report?