How to copy data from the SSMS results grid

Copy data from the SSMS results grid

With SQL Complete, you can copy data from a cell or an entire table in the results grid to clipboard or to a CSV, XML, HTML, or JSON file.

To copy data from the results grid, select the values you want to copy, right-click them and select Copy Data As > file format (CSV, XML, HTML, or JSON) > To File or To Clipboard.

Alternatively, you can use shortcuts to copy data to the clipboard for a specific file format:

  • Ctrl+Alt+Y,C for the CSV format
  • Ctrl+Alt+Y,X for the XML format
  • Ctrl+Alt+Y,H for the HTML format
  • Ctrl+Alt+Y,J for the JSON format

If you want to copy column names from the grid, select the columns you want to copy, right-click and select Copy Data As > Copy Column Names Only or press Ctrl+Alt+Y,N.

If you want to copy column names and types of their values from the grid, select the columns you want to copy, right-click and select Copy Data As > Copy Column Names and Types or press Ctrl+Alt+Y,T.

Let’s take the CSV format as an example and see how SQL Complete copies data to clipboard.

Copy Data As

The output is as follows:

680,FR-R92B-58,Black,375,"1,431.50"
706,FR-R92R-58,Red,375,"1,431.50"
707,HL-U509-R,Red,3,34.99
708,HL-U509,Black,3,34.99
709,SO-B909-M,White,3,9.50

How to query data for CSV export

In the example provided above, you may notice that the data in the last column is exported without a trailing separator. This can lead to issues when the data is imported into a CSV file. To resolve this, we recommend adding an empty column when querying data. This will add the required separator when you copy the data from the grid with that empty column.

To export data with an additional empty column, first generate an output containing this empty column using a SELECT query.

You can achieve by adding a pair of single quotation marks (‘’) in place of a column name in your query. For example:

SELECT ProductID, ProductNumber, '', Color, ReorderPoint, ListPrice
FROM Production.Product
WHERE Color IS NOT NULL AND ListPrice !=0

Copy data from a column

Then, select the fields you want to copy, right-click them, and select Copy Data As > CSV > To File or To Clipboard.

Then, paste the data. The output should be as follows:

FR-R92B-58,
FR-R92R-58,
HL-U509-R,
HL-U509,
SO-B909-M,

Customize options to copy data from the results grid to the CSV file format

To customize options:

1. In the SQL Complete menu, select Options.

2. In the SQL Complete: Options dialog, switch to Data Export > CSV and configure data export to the CSV file format.

Options

Option Description
Use Unicode Creates a .csv file with a Unicode character encoding.
Show a table header Indicates whether to write column headers.
Quote string Encloses a string in quotes. The recommended options are single quote mark or double quote mark.
Force quote Indicates whether quoting should be optional (if cleared) or added at all times (if selected).
Field separator Defines a field separator by using one of the available options: comma, semicolon, Tab, or Space.

3. To save changes, click OK.

Note

For more information on configuring data export options, see Data Export.

Paste the copied data

After you have copied data, you can easily paste it into any editor, such as Google Sheets, Microsoft Excel, LibreOffice Calc, and so on. To do this, you can press CTRL + V in the editor where you want to insert it or select the required option. Since the option name may vary among editors, feel free to refer to their official documentation.

You can also paste the copied data from the clipboard, for example, into Notepad, and then save it as a separate file with the .csv extension.

Notepad

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge SQL Complete for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the SQL Complete in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the SQL Complete for your business, request a demo to see it in action.
Ready to start using dbForge SQL Complete for SQL Server?