{"id":9078,"date":"2019-02-03T11:02:59","date_gmt":"2019-02-03T11:02:59","guid":{"rendered":"https:\/\/dbtut.com\/?p=9078"},"modified":"2019-02-03T11:02:59","modified_gmt":"2019-02-03T11:02:59","slug":"how-to-export-sql-server-table-to-csv-file","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/","title":{"rendered":"How To Export SQL Server Table to CSV File"},"content":{"rendered":"

 <\/p>\n

We usually export a dataset in SQL Server to Excel instead of CSV. But in some cases we may need to export to csv files. You can use the following articles to transfer data from Excel to SQL Server and from SQL Server to Excel.<\/p>\n

“How To Import Excel To SQL Server Table<\/a>“,<\/p>\n

“How To Export SQL Server Table To Excel<\/a>”<\/p>\n

Example:<\/strong><\/p>\n

Right-click on the database and click “Tasks->Export Data”.<\/p>\n

\"\"<\/p>\n

On the incoming screen, select “Do not show this starting page again” and click next.<\/p>\n

As soon as we select the “Microsoft OLE DB Provider for SQL Server or SQL Server Native Client” from the Data source section, the name of the Instance appears in the “ServerName” section and the database name appears in “Database:” section. Because we have clicked export by right-clicking on the database.<\/p>\n

We’re moving forward by clicking Next.<\/p>\n

\"\"<\/p>\n

In the incoming screen, select “Flat File Destination” from Destination.<\/p>\n

In the “File name:” section, we click Browse, and go to the folder we want to export the file to. Then give a name to the file and add the .csv extension to the end of the name.<\/p>\n

We select Turkish (Turkey) from the Locale section and proceed next. You should choose “Locale” and “Code page” according to your language.<\/p>\n

\"\"<\/p>\n

While the “Copy data from one or more tables or views” is selected in the incoming screen, click next to proceed.<\/p>\n

\n\"\"<\/p>\n

In the incoming screen, we select the table we want to export from “Source table or view:”. We will then specify a separator for the rows and columns as follows.<\/p>\n

If we specify a CR (carriage return) in the row delimiter section, it creates a new line in the csv file for each row.<\/p>\n

For Column delimiter, I usually choose Comma {,}.<\/p>\n

\"\"<\/p>\n

Sometimes only {CR} is not enough for Row delimiter. To make it easy to transfer the file with the .csv extension to another system with code, add “||” in front of {CR} as follows.<\/p>\n

\"\"<\/p>\n

Click Next to proceed. On the next screen, select “Run Immediately”.<\/p>\n

Finally, click next and finish to complete the process.<\/p>\n\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

  We usually export a dataset in SQL Server to Excel instead of CSV. But in some cases we may need to export to csv files. You can use the following articles to transfer data from Excel to SQL Server and from SQL Server to Excel. “How To Import Excel To SQL Server Table“, “How …<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[1895,1893,1894,1892],"class_list":["post-9078","post","type-post","status-publish","format-standard","","category-mssql","tag-export-sql-server-table-to-csv-file","tag-export-table-from-database-to-csv-file","tag-export-table-from-sql-server-to-csv-file","tag-export-table-to-csv"],"aioseo_notices":[],"yoast_head":"\nHow To Export SQL Server Table to CSV File - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Export SQL Server Table to CSV File\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Export SQL Server Table to CSV File - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Export SQL Server Table to CSV File\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-03T11:02:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Export SQL Server Table to CSV File\",\"datePublished\":\"2019-02-03T11:02:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\"},\"wordCount\":362,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png\",\"keywords\":[\"export sql server table to csv file\",\"Export table from database to csv file\",\"Export table from sql server to csv file\",\"Export Table To CSV\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\",\"name\":\"How To Export SQL Server Table to CSV File - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png\",\"datePublished\":\"2019-02-03T11:02:59+00:00\",\"description\":\"How To Export SQL Server Table to CSV File\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png\",\"width\":708,\"height\":729},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Export SQL Server Table to CSV File\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Export SQL Server Table to CSV File - Database Tutorials","description":"How To Export SQL Server Table to CSV File","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/","og_locale":"en_US","og_type":"article","og_title":"How To Export SQL Server Table to CSV File - Database Tutorials","og_description":"How To Export SQL Server Table to CSV File","og_url":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/","og_site_name":"Database Tutorials","article_published_time":"2019-02-03T11:02:59+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Export SQL Server Table to CSV File","datePublished":"2019-02-03T11:02:59+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/"},"wordCount":362,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png","keywords":["export sql server table to csv file","Export table from database to csv file","Export table from sql server to csv file","Export Table To CSV"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/","url":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/","name":"How To Export SQL Server Table to CSV File - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png","datePublished":"2019-02-03T11:02:59+00:00","description":"How To Export SQL Server Table to CSV File","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/02\/img_5c56c89ce168b.png","width":708,"height":729},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/02\/03\/how-to-export-sql-server-table-to-csv-file\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Export SQL Server Table to CSV File"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9078","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=9078"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/9078\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=9078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=9078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=9078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}