{"id":1809,"date":"2017-03-25T09:01:27","date_gmt":"2017-03-25T09:01:27","guid":{"rendered":"http:\/\/data-flair.training\/blogs\/?p=1809"},"modified":"2021-08-25T18:21:09","modified_gmt":"2021-08-25T12:51:09","slug":"exporting-data-from-r","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/","title":{"rendered":"Exporting Data from R to Other File Formats &#8211; Guide for Data Science Aspirants!"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:2197,&quot;href&quot;:&quot;https:\\\/\\\/www.r-project.org\\\/mail.html&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250923123815\\\/https:\\\/\\\/www.r-project.org\\\/mail.html&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-11 02:30:50&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-15 15:57:43&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-20 17:10:49&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-25 14:56:12&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-29 06:15:36&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-01-06 14:58:27&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-09 19:59:55&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-15 07:02:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-18 20:33:29&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-22 09:45:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-01-25 20:29:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-01 15:58:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-04 16:56:11&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-09 00:30:49&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-02-12 23:36:25&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-16 10:34:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-19 18:55:30&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-24 08:47:46&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-02-27 09:24:35&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-02 12:35:13&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-05 17:16:00&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-09 15:35:22&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-12 20:57:28&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-16 06:08:08&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-20 03:17:03&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-03-26 05:26:49&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-01 02:55:55&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-06 06:09:23&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-09 13:50:53&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-13 07:12:36&quot;,&quot;http_code&quot;:503},{&quot;date&quot;:&quot;2026-04-20 20:41:19&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-25 09:59:01&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-04-29 16:16:37&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-03 04:24:47&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-06 05:00:22&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-09 11:59:39&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-12 19:12:53&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-18 14:26:40&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-22 10:34:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-26 03:16:07&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-05-29 10:14:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-01 20:22:56&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2026-06-05 03:35:35&quot;,&quot;http_code&quot;:206}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-06-05 03:35:35&quot;,&quot;http_code&quot;:206},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<p>Previously, we explored the <em><strong><a href=\"https:\/\/data-flair.training\/blogs\/importing-data-in-r\/\">process of importing data in R<\/a><\/strong><\/em>, now, in this tutorial, we will learn the steps of exporting data from R programming to CSV, Excel, SPSS, SAS and Stata. Lastly, we will understand the process of saving work in R.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64499\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg\" alt=\"Reading-Exporting-Data-in-R\" width=\"802\" height=\"420\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg 802w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R-520x272.jpg 520w\" sizes=\"auto, (max-width: 802px) 100vw, 802px\" \/><\/a><\/p>\n<p>Let&#8217;s quickly start.<\/p>\n<h2>Introduction to Exporting Data from R<\/h2>\n<p>Exporting results from R programming is usually a less contentious task.<\/p>\n<h3>1. Exporting table data to a CSV file<\/h3>\n<p>Exporting results from R to other applications in the CSV format is just as convenient as importing data into R by using CSV files.<\/p>\n<p>To create a CSV file, the write.csv()function can be used. Just as the <em>read.csv()<\/em> function is a special case of<em> read.table(), write.csv()\u00a0<\/em>is also a special case of <em>write.table()<\/em>. The command can be used as follows:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt; #Author DataFlair\r\n&gt; data &lt;- data.frame(x1 = c(1, 2, 3, 4),          \r\n+                   x2 = c(5, 6, 7, 8),\r\n+                   x3 = c(9, 10, 11, 12))\r\n&gt; write.table(data, file = \"data.csv\",\r\n+            sep=\"\\t\", row.names=FALSE)\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64494\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file.png\" alt=\"Exporting table data to a CSV file\" width=\"1298\" height=\"740\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file.png 1298w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file-150x86.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file-1024x584.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-table-data-to-a-CSV-file-520x296.png 520w\" sizes=\"auto, (max-width: 1298px) 100vw, 1298px\" \/><\/a><\/p>\n<p>Here separator is tab character (\\t). This means using the above command, tabular data can be written to the clipboard.<\/p>\n<h3>2. Exporting R data to an Excel Spreadsheet<\/h3>\n<p>Below commands are used to export R data to an excel sheet:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">library(xlsx)\r\nwrite.xlsx(data, \"\/home\/dataflair\/data.xlsx\")<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64495\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export.png\" alt=\"xlsx export - Exporting data from R\" width=\"1297\" height=\"739\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export.png 1297w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export-768x438.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export-1024x583.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/xlsx-export-520x296.png 520w\" sizes=\"auto, (max-width: 1297px) 100vw, 1297px\" \/><\/a><\/p>\n<h3>3. Exporting data from R to SPSS<\/h3>\n<p>In order to export the data from <a href=\"https:\/\/www.r-project.org\/mail.html\">R<\/a> to SPSS, you will require the &#8220;Foreign&#8221; package. Then, you can export data from R to SAS or SPSS or Stata.<\/p>\n<p>In order to write the data file, that can be interpreted by the SPSS, we write the following lines of code:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt; #Author DataFlair\r\n&gt; library(foreign)\r\n&gt; write.foreign(data, \"\/home\/dataflair\/data.txt\", \"\/home\/dataflair\/data.sps\", package=\"SPSS\")\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64496\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS.png\" alt=\"Exporting data from R to SPSS - library foreign data\" width=\"1296\" height=\"738\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS.png 1296w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS-768x437.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS-1024x583.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SPSS-520x296.png 520w\" sizes=\"auto, (max-width: 1296px) 100vw, 1296px\" \/><\/a><\/p>\n<p><em><strong>Wait! Have you checked &#8211; <\/strong><a href=\"https:\/\/data-flair.training\/blogs\/binomial-and-poisson-distribution\/\"><strong>Binomial and Poisson Distribution in R<\/strong> <\/a><\/em><\/p>\n<h3>4. Exporting data from R to SAS<\/h3>\n<p>Below is the way to write out text data file and a SAS program to read it:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt; #Author DataFlair\r\n&gt; library(foreign)\r\n&gt; write.foreign(data, \"\/home\/dataflair\/data.txt\", \"\/home\/dataflair\/data.sas\", package=\"SAS\")\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64497\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS.png\" alt=\"Exporting data from R to SAS\" width=\"1299\" height=\"739\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS.png 1299w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS-300x171.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS-768x437.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS-1024x583.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-data-from-R-to-SAS-520x296.png 520w\" sizes=\"auto, (max-width: 1299px) 100vw, 1299px\" \/><\/a><\/p>\n<h3>5. Exporting R data to Stata<\/h3>\n<p>We use the below method to export data frame to Stata binary format:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">&gt; library(foreign)\r\n&gt; write.dta(data, \"\/home\/dataflair\/data.dta\")\r\n<\/pre>\n<p><strong>Output:<\/strong><\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-64498\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata.png\" alt=\"Exporting R data to Stata\" width=\"1297\" height=\"737\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata.png 1297w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata-150x85.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata-300x170.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata-768x436.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata-1024x582.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Exporting-R-data-to-Stata-520x295.png 520w\" sizes=\"auto, (max-width: 1297px) 100vw, 1297px\" \/><\/a><\/p>\n<h2>Saving Work in R<\/h2>\n<p>Let us now understand how we can save our work in the R programming language. For saving data to disk as text files while performing Data Analytics:<\/p>\n<ol>\n<li>The command which we will use depends on the format of data to save to the disk. Transfer the data out of R by using the <em>write.table(), write.csv(), and cat() commands<\/em>.<\/li>\n<li>For a single vector of values,\u00a0use the <em>write()<\/em> or <em>cat()<\/em> command. For multiple column items containing several variables,\u00a0use the <em>write.table()<\/em> or <em>write.csv()<\/em> command.<\/li>\n<\/ol>\n<h2>Summary<\/h2>\n<p>We learned several steps to export table\u00a0data to CSV file, R data to excel sheet, SPSS, Stata and SAS in this tutorial. We also discussed how to save work in R Programming.<\/p>\n<p><em><strong>Next, master the concept of <a href=\"https:\/\/data-flair.training\/blogs\/r-predictive-and-descriptive-analytics\/\">Predictive and Descriptive Analytics in R<\/a><\/strong><\/em><\/p>\n<p>Still, if you have any doubt regarding the tutorial, ask in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Previously, we explored the process of importing data in R, now, in this tutorial, we will learn the steps of exporting data from R programming to CSV, Excel, SPSS, SAS and Stata. Lastly, we&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":64499,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[51],"tags":[4486,20669,20670,20671],"class_list":["post-1809","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-r","tag-exporting-data-from-r","tag-exporting-data-from-r-to-csv","tag-exporting-data-from-r-to-excel","tag-exporting-data-from-r-to-sas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Exporting Data from R to Other File Formats - Guide for Data Science Aspirants! - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn the process of exporting data table from R programming to CSV and R data to Excel, SPSS, SAS, Stata and saving work in R. Explore now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting Data from R to Other File Formats - Guide for Data Science Aspirants! - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn the process of exporting data table from R programming to CSV and R data to Excel, SPSS, SAS, Stata and saving work in R. Explore now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-25T09:01:27+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-25T12:51:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting Data from R to Other File Formats - Guide for Data Science Aspirants! - DataFlair","description":"Learn the process of exporting data table from R programming to CSV and R data to Excel, SPSS, SAS, Stata and saving work in R. Explore now!","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:\/\/data-flair.training\/blogs\/exporting-data-from-r\/","og_locale":"en_US","og_type":"article","og_title":"Exporting Data from R to Other File Formats - Guide for Data Science Aspirants! - DataFlair","og_description":"Learn the process of exporting data table from R programming to CSV and R data to Excel, SPSS, SAS, Stata and saving work in R. Explore now!","og_url":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2017-03-25T09:01:27+00:00","article_modified_time":"2021-08-25T12:51:09+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Exporting Data from R to Other File Formats &#8211; Guide for Data Science Aspirants!","datePublished":"2017-03-25T09:01:27+00:00","dateModified":"2021-08-25T12:51:09+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/"},"wordCount":453,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg","keywords":["Exporting data from R","Exporting Data from R to CSV","Exporting Data from R to Excel","Exporting data from R to SAS"],"articleSection":["R Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/","url":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/","name":"Exporting Data from R to Other File Formats - Guide for Data Science Aspirants! - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg","datePublished":"2017-03-25T09:01:27+00:00","dateModified":"2021-08-25T12:51:09+00:00","description":"Learn the process of exporting data table from R programming to CSV and R data to Excel, SPSS, SAS, Stata and saving work in R. Explore now!","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2017\/03\/Reading-Exporting-Data-in-R.jpg","width":802,"height":420,"caption":"Reading-Exporting-Data-in-R"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/exporting-data-from-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"R Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/r\/"},{"@type":"ListItem","position":3,"name":"Exporting Data from R to Other File Formats &#8211; Guide for Data Science Aspirants!"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/1809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=1809"}],"version-history":[{"count":16,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/1809\/revisions"}],"predecessor-version":[{"id":64500,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/1809\/revisions\/64500"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/64499"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=1809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=1809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=1809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}