PSFS IQ - Query Builder: How to export query results to a .csv file

How to export query results to a .csv file

After you run a query, you can export it to a .csv file where you can modify the data. After opening the .csv file in Excel, you can export the data into any one of the many formats Excel offers and then import the records into any other application. This topic shows you how to export results to a .csv file.


  1. Build the query the way you typically do by choosing columns from the Column Picker and specifying conditions.

For instructions on building a new query, go to How to Create a New Query.

  1. At the top of the Query Results panel, click Execute Query to run the query.

The results are displayed in the Query Results panel.

  1. To export the results to a .csv file, complete the following:

a. Click Query Results.

b. From the menu, select the Export to CSV option.

The results are exported to a .csv file.

c. Save the .csv file to your local hard drive.

  1. If desired, do one or both of the following:
    • Open the file in Excel and make changes, if necessary.
    • Export the data into any one of the many formats Excel offers.

 


Related Articles

Exporting & Merging (Video)

How to reorder the columns in your query results

How to rename a column heading in your query results

How to find all results that do not match a condition

How to sort a column's data

How to remove duplicate records from your query results

 

Top

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.