The numbers you see in a table or a graph in gas can be downloaded into a file and worked on further in Excel or Google Sheets. This is handy when you need to send data to a colleague or a client, add your own formula, or set today's figures aside for later. Export is part of every table in the application and you do not have to ask anyone for it.
Before you start
The file contains exactly what the table is set to at the moment of export: the selected period, the filters that are on, the row order and which columns are visible. So set the table up the way you want the file to look, and only then run the export.
Export is operated on a computer. On a phone and a tablet the export buttons are not shown, because tables there switch to a simplified card view meant mainly for browsing. When you need to download data, open gas on a computer and keep the browser window wide.
No special permission or higher plan is needed. Anyone who can see the table in the application can download it.
Which format to choose
For tables you can pick between two formats, and the difference between them matters.
CSV is a plain text file. Values in one row are separated by a comma and the file contains no formatting, colours or formulas. Its advantage is that almost any program opens it. It is used mainly when you are uploading data into another system.
Excel is a full workbook with the .xlsx extension. Numbers stay numbers, so you can calculate a sum or an average right away, and the file opens on a double click without any further setup.
If you only want to open the file, look at it or calculate in it, choose Excel. Choose CSV when another program you are uploading data into explicitly asks for it.
How to do it
- Open the page with the table you want to download, for example Campaigns or Goals.
- Set the period and any filters in the table so that it shows the data you need.
- Click the header of the column you want to sort by. The rows will be in the same order in the file.
- Use the Columns button above the table to turn columns on or off if you want a specific set in the file.
- On the right-hand side of the bar above the table you will find three buttons with icons. When you hover over them, the tooltips Export CSV, Export Excel and Print appear.
- Click Export CSV or Export Excel, depending on the format you want.
- A window opens with two checkboxes, All rows and All columns. Both are empty by default; their meaning is described below.
- Click the Export button. The window closes and the browser downloads the file.
Both checkboxes in the window decide how much of the table ends up in the file:
All rows. An unchecked box means that only the part of the table currently loaded gets into the file, so usually the page you are looking at. A checked box means that gas also loads all the remaining pages and puts them into the file. This box does not cancel filters or the selected period, only the table paging. A large table takes longer to load this way, which the text in the window also warns about.
All columns. An unchecked box means that only the columns currently turned on in the table are exported. A checked box adds absolutely every column of that table to the file, including the ones you have hidden.
What happens next
The browser saves the file among your downloads, so usually into the Downloads folder, and offers it in its download bar. Double-clicking it opens the file in whatever program your computer uses for spreadsheets.
The file name matches the table you exported from. The Campaigns page produces campaigns-list.csv or campaigns-list.xlsx, the Goals page produces goals-list.csv or goals-list.xlsx. The name contains neither the selected period nor the name of the customer account, so if you download the same table again, the browser only adds a sequence number.
Rename the file right after downloading it so that the name shows the period and the customer account, for example campaigns-june-2026.xlsx. In a month's time the original name will not tell you what the numbers refer to.
In the file itself, expect the following:
- The first row holds the column names exactly as you see them in the table header.
- The rows follow in the same order in which the table was sorted.
- The Summary row, which is pinned at the very bottom of the table and holds the totals, is not carried over into the file. Calculate the totals yourself in Excel.
- The column with action icons (the pencil for editing, the bin for deleting) does end up in the file, but it stays empty and without a name. Icons have no value that could be written into a file.
- Values are in the file in raw form, that is without the adjustments gas makes for on-screen readability. The thousands separator, the currency symbol and the percent sign are missing, and a date may be written differently than in the table. This is intentional: you can keep calculating with an unformatted number, but not with the text "12,345 CZK".
Exporting data from a graph
Export is not only in tables. Above every graph there is an Export button with a downward arrow icon. Clicking it opens a menu with six items: PNG image, JPG image, PDF file, SVG vector, CSV file and XLS file.
The first four items save the graph as an image or as a PDF, that is as a picture to put into a presentation. The last two items, CSV file and XLS file, save the numbers the graph is built from: one row per date and one column per line in the graph.
Files with graph data follow the language settings of your browser, so in a Czech environment they use a semicolon as the separator and a decimal comma. That is why they usually open correctly in Czech Excel. The file name, however, does not take over the name of the graph, it is generic, so rename the file after downloading it.
If you need a paper version or a PDF of the whole page including the graphs, use printing instead of export. That is covered by a separate guide on printing a page and saving it to PDF.
Common problems
Columns I can see in the table are missing from the export
By default only the columns currently turned on in the table are exported, and on a narrower monitor the table hides some columns on its own. In the export window tick All columns, which puts the whole table into the file including the hidden columns. Alternatively, first turn the specific columns on with the Columns button above the table and run the export only after that.
Rows I can see in the table are missing from the export
Without the All rows box ticked, only the part of the table currently loaded is downloaded, so typically one page. Run the export again and tick the All rows box. With very large tables, wait until the table finishes loading and the loading indicator stops flashing, and only then confirm the export.
The export is empty or contains only the header
The table held no data at the moment of export. The most common cause is a filter that finds nothing, or a selected period that is too short or too far in the past. Close the export window, remove the filters with the Clear filters button above the table, check the selected period and see whether the table shows any rows on screen. If it is empty there too, there is nothing to export.
After opening in Excel the whole row is in one column
The CSV file from a table separates values with a comma, whereas Excel in Czech settings expects a semicolon. The quickest solution is not to download CSV but to click Export Excel, because an .xlsx workbook always opens correctly. If you need to stay with CSV, load it through Excel's text file import function and choose the comma as the separator. Google Sheets usually detects the separator by itself.
Numbers behave like text in Excel or turn into dates
In a CSV file decimals are separated by a dot, which Czech Excel settings do not consider a number and sometimes flip the value into a date. Use the Excel export instead of CSV; there the numbers are stored as numbers and you can calculate with them right away.
Instead of accented characters there are strange symbols in the text
Files from gas use UTF-8 encoding and carry a mark by which Excel recognises it, so accented characters should be fine there. If you open the file in an older or simpler program, set the encoding to UTF-8 when loading it. If you are not sure how, download the Excel version instead, it does not suffer from this problem.
The summary row with totals is missing from the file
The Summary row, which is pinned at the very bottom of the table, is not carried over into the export. Calculate the totals again in your spreadsheet program, for example with the SUM function over the given column.
There is an empty column without a name in the file
That is the column in which the table on screen shows the action icons, that is the pencil for editing and the bin for deleting. The buttons have no value that could be written into a file, so the column stays empty. You can safely delete it in Excel.
Values in the file look different from the table
That is correct. Unformatted numbers are saved into the file, so without the thousands separator, without the currency symbol and without the percent sign, and dates may be written in a different form. If the on-screen form were exported, those would be texts and you could not calculate with them. Set the formatting in Excel to your liking.
Downloading all rows takes a long time and the page does not move
The All rows box forces the application to load all pages of the table, which with large data takes tens of seconds. Leave the browser window open and wait until the file downloads. If it takes unbearably long, shorten the selected period, narrow the selection with a filter, or download the table in parts.
I cannot see the export buttons at all
The buttons are hidden on narrower screens. On a phone and a tablet export is not offered at all, and on a computer a small browser window behaves the same way. Stretch the window to the full width of the screen, or move to a computer with a bigger monitor.
I cannot tell which period and account the downloaded data is from
The file name carries only the name of the table; neither the period nor the customer account is in it. Rename the file right after downloading, while you still know what you downloaded, and add the month and the client to the name.
I need the data regularly and I do not want to download it by hand
Export from a table is always manual, it does not repeat on its own. Regular automated processing is handled by the Reports module, which can create a report on a schedule and deliver it, but the output is a PDF, not a table for further calculations. If you need to receive table data regularly, write to us through the contact form and we will agree on a solution.