Export SQL query result to CSV

Question

I'm using sqlcmd to export a query result with two columns to csv. The simple query is:

SELECT DISTINCT
    CustomerGuid, CustomerPassword
FROM
    ServiceOrder
ORDER BY
    CustomerGuid

When I open the exported csv in Excel both customer and password are on the same column. Is it possible to split them into their own column using sqlcmd. My sqlcmd looks like

SQLCMD -S . -d BAS -Q "SQL STATEMENT" -s "," -o "c:\data.csv"

Thanks.

Try SQLCMD -S . -d BAS -Q "SQL STATEMENT" -s ";" -o "c:\data.csv" It could be a problem with the line delimiter in Excel. — andy
– andy, Commented Nov 8, 2013 at 11:38
Andy, thank you. The problem was me using "," instead of ";". — Morten Laustsen
– Morten Laustsen, Commented Nov 8, 2013 at 11:49
Awesome, I've added this as an answer :) If you could accept it, that'd be a great help. — andy
– andy, Commented Nov 8, 2013 at 11:51
Actually, there is nothing wrong with ,. Excel's behaviour is locale-dependent, with , or ; used depending on the Regional Settings of the user. — Panagiotis Kanavos
– Panagiotis Kanavos, Commented Nov 8, 2013 at 11:56

andy · Accepted Answer · 2013-11-08 11:51:01Z

2

The problem is that you are using , instead of ; as the line delimiter. Try:

SQLCMD -S . -d BAS -Q "SQL STATEMENT" -s ";" -o "c:\data.csv"

:)

answered Nov 8, 2013 at 11:51

andy

2,4193 gold badges32 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-03-20 10:18:25Z

1

Actually, this is more of an Excel question and it's already answered in superuser. The default separator when you open a CSV file is locale dependent. In locales where , is a decimal separator, the default is ;.

You can either modify the List separator in Regional settings (not recommended) or open an empty worksheet and import the data, specifying the separator you want.

By the way, the same rules are used in Excel and SharePoint Formulas, where you may have to type ; instead of , to separate values depending on your locale.

edited Mar 20, 2017 at 10:18

CommunityBot

11 silver badge

answered Nov 8, 2013 at 11:48

Panagiotis Kanavos

134k16 gold badges211 silver badges271 bronze badges

Comments

Andrei Nicusan · Accepted Answer · 2013-11-08 11:41:12Z

0

You might have one of the following issues:

Either the CSV output does not use any separator between its columns (you can check this by opening the CSV file in a regular text editor; or the column separator set in Excel for CSV files does not match the separator you actually have in your output file.

answered Nov 8, 2013 at 11:41

Andrei Nicusan

4,6191 gold badge27 silver badges37 bronze badges

Collectives™ on Stack Overflow

Export SQL query result to CSV

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related