1. Open SQL Editor and Write Your Query

Navigate to Workspaces → SQL Editor in your Keboola project.

Write or paste your SQL query in the editor.

‍

2. Run Your Query

Click the Run Query button (or Command + Enter). The results will appear in the Results Panel below your query.

‍

‍

3. Export to CSV

In the Results Panel, look for the Export to CSV button. Click it, and your browser will download the results as a CSV file.

‍

‍

Note: Large result sets may take a moment to prepare.

‍

Tips

Use LIMIT for Large Queries

Add a LIMIT clause to keep exports manageable.

SELECT * FROM large_table LIMIT 1000;

Format Dates Before Export

Format dates in your SQL query to avoid Excel auto-formatting issues.

SELECT 
  TO_CHAR(order_date, 'YYYY-MM-DD') as order_date,
  customer_name
FROM orders;

Alias Columns for Clarity

Use column aliases to make your exported CSV easier to read.

SELECT 
  customer_id AS "Customer ID",
  SUM(amount) AS "Total Spent"
FROM orders
GROUP BY customer_id;