Exporting Query Results

Query result sets can be easily exported from Arctype in both .csv and .xslx formats directly from the result view.  This can be especially useful for sharing data with team members who don't have database access and for (small-scale) data migrations.  As an example, the below query calculates the average life expectancy and GNP, as well as the total area and population of each continent:
1
select
2
   Continent,
3
   avg(LifeExpectancy) as avg_lifespan,
4
   avg(GNP) as avg_gnp,
5
   sum(SurfaceArea) as total_area,
6
   sum(Population) as total_pop
7
from
8
   country
9
group by
10
   1
11
order by
12
   5 desc
Copied!
After the query has successfully executed and results are displayed, click the ••• button in the right corner of the results pane to open the results context menu:
Right click the 3 dots in the top right of query results to export them.
Then, simply select Download as CSV or Download as Excel and select a filename and destination when prompted:
Save query results as a .csv or .xlsx file.
The query results should now be easily viewable in most spreadsheet applications:
Open the downloaded CSV or Excel file to view query results.
​

Last modified 3mo ago

Copy link