Export query data from Ascend

Written By Ascend knowledge base (Administrator)

Updated at May 3rd, 2023

Table of Contents

Sometimes, you need to save the results of a query (orange icon) to your computer. This may be to reference in the future, to import into your email marketing program, or to further filter the data in Microsoft Excel – whatever the reason, Ascend allows you to export these results in a variety of formats.

Editable format

  1. From the results toolbar, click the arrow next to the Export button and choose CSV (comma separated values) or XLSX (Microsoft Excel or Open Office).
    Screenshot of the Export button highlighted with the dropdown open. The options are CSV or XLSX
  2. Navigate to the location on your computer where you wish to save the file (e.g. the Windows Desktop).
  3. If desired, enter a new name in the File Name field (the default value is Report name yyyymmdd – Location short name).
  4. Click Save.
    Screenshot of Downloads window with File Name box highlighted and Save button highlighted

Printable format

  1. From the results toolbar, click the Preview button.
    Screenshot with the Preview button highlighted
  2. On the Preview window, select the File menu > Export Document > PDF File.
    Screenshot of the Preview window. The File menu is open, Export Document is selected, and there is a check mark next to PDF File
  3. On the PDF Export Options dialog box, click the OK button.
    Screenshot of the PDF Export Options window with the OK button highlighted
  4. Navigate to the location on your computer where you wish to save the file (e.g. the Windows Desktop).
  5. In the File Name field, enter a descriptive name (e.g. Customers on Mail List 20180131).
  6. Click Save.
    Screenshot of the Save As window, the File Name box is highlighted, the Save button is highlighted

KB22-064