Skip to content

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?

  1. Open the Reports group in the menu and click Reports.
  2. Click Run on the record of the report you want.
  3. Fill in the details the window asks for.
  4. 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:

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 seeWhat has happenedWhat to do
Nothing downloads when you click DataThe report returned no rowsClick View to check there is data
‘The report takes … rows and an Excel sheet allows …’It exceeds the Excel limitGet it as CSV or narrow down the details
The whole CSV falls into one columnYour spreadsheet is in English and was expecting the commaImport it, setting semicolon as the separator
Accented characters in the CSV come out wrongYou opened it with a programme that ignores the UTF-8 markOpen it with the spreadsheet, or import it setting UTF-8; or use Excel
Rows are missing at the endThe result was truncated by the row limitNarrow 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