NC 09: Export to CSV

Track: No-code sandbox (sandbox.altfndata.com) Prerequisite: NC_08.

The task

Take a filtered query result out of the sandbox and into a downloadable CSV file, ready to open in a spreadsheet or load into a separate analysis tool.

Starter steps

  1. Open the SQL editor and run a query you want to export, for example the pricing power query from NC_04 rebuilt across several designers at once:
SELECT
  designer,
  approx_percentile(usd_price_decimal / sale_estimates_high_usd_price, 0.5) AS pricing_power_median,
  COUNT(*) AS sold_lot_count
FROM all_watches_data
WHERE status = 'sold'
  AND sale_estimates_high_usd_price > 0
GROUP BY designer
HAVING COUNT(*) >= 20
ORDER BY pricing_power_median DESC;
  1. Once the result grid loads, look for the Export button above or beside the grid (commonly offered as CSV, with JSON as an alternative format).
  2. Click Export as CSV and save the file locally.
  3. Open the downloaded file in a spreadsheet application and confirm the column headers match the SELECT list from your query.
  4. Repeat with the JSON export option if you plan to load the result into a script or notebook instead of a spreadsheet.

Expected result

A downloaded file (.csv or .json) containing one row per group in your query's result, with column headers matching your SELECT list (designer, pricing_power_median, sold_lot_count). Opening the CSV in a spreadsheet shows a clean, flat table with no nested structures, ready for sorting, charting, or pivoting outside the sandbox.

Stretch challenge

Export the sell-through query from NC_05 as CSV, then open both this file and the pricing power CSV from this tutorial side by side in a spreadsheet, and use a VLOOKUP or similar join on designer to build a single combined table of pricing power and sell-through per brand.