Stata

Export Stata data to CSV

#Using command ‘export delimited’, Syntax:
"export delimited using ‘filename.csv’, replace"
#Example code:

Sysuse auto, clear
export delimited using "U:/Downloads/file2.csv", replace

#Using Menu:
‘File’ -> ‘Export’ -> ‘Text data (Delimited, *.csv, …)’
#Notice using the menu you can export to a variety of different formats
Stata Exporting Documentation

Import CSV data into Stata

#Using import delimited command, Syntax:
import delimited using “filename.csv”, clear
#Example code:

Import delimited using "U:/Downloads/file2.csv", clear

#Using Menu:
‘File’ -> ‘Import’ -> ‘Text data (Delimited, *csv, …)’
#Using the menu you can also import many different types of files.

Stata Importing/Exporting Documentation

R

Export R data to CSV

# Uses write.csv command. Syntax:
write.csv(data_object, ‘filename.csv’)
#Example Code

df <- data.frame(name = c("Jon", "Bill", "Maria"), age = c(23, 41, 32))
write.csv(df, 'U:/Downloads/file1.csv')
R Exporting CSV Documentation
R can export to a variety of formats. Some of the formats included in the following link.
R Exporting to other File Formats

Import csv data into R

Uses read.csv command. Syntax:
data_object = read.csv(‘filename.csv’)
#Example code

Df = read.csv('U:/Downloads/file1.csv')

Matlab

Export Matlab data to CSV

Using Writematrix or csvwrite commands. Syntax:
writematrix(object, ‘filename.csv’)
csvwrite(‘filename.csv’, object)
#Example Code

a=[234,2
671,5
735,1]


csvwrite(' U:\Downloads\file.csv',a)
Matlab exporting CSV Documentation
Matlab can export to a variety of formats other than CSV.

Import CSV Data into Matlab

Use readtable command to import delimited data. Syntax/Example Code:
T = readtable(' U:\Downloads\file.csv');
Matlab Importing CSV documentation

SPSS

Export SPSS Data to CSV

Using save translate command. Syntax/Example Code:
save translate outfile = ‘filename.csv’ /type = CSV.
save translate outfile = 'U:\Downloads\file1.csv'
/type = CSV.

Using Menu:
Activate dataset. ‘File’ -> ‘Export’ -> ‘CSV Data’
SPSS Export to CSV Documentation

Import CSV Data to SPSS

Using command GET DATA. Syntax/Example Code

GET DATA /TYPE=TXT
/FILE="U:\Downloads\file1.csv"
/DELIMITERS=","
/QUALIFIER='"'
/ARRANGEMENT=DELIMITED
/FIRSTCASE=1
/DATATYPEMIN PERCENTAGE=95.0
/VARIABLES=
V1 AUTO
V2 AUTO
/MAP.
RESTORE.
CACHE.
EXECUTE.
DATASET NAME DataSet2 WINDOW=FRONT.

#Using Menu:
Activate Data Viewer. “File” -> “Import Data” -> “CSV Data”
Importing CSV into SPSS Documentation

SAS

Export SAS data to CSV

Using Command “Proc Export”. Syntax/Code Example:

proc export data=sashelp.class outfile “U:\Downloads\class.csv" dbms=dlm replace;
delimiter = ',';
run;
Using Menu:
File -> Export Data
SAS Exporting to CSV Documentation

Import CSV Data into SAS

Using Command “Proc Import”. Syntax/Code Example:
proc import datafile="U:\Downloads\class.csv" out=Class dbms=csv replace; run;
proc print data = Class; run;
Using the menu:
“File” -> “Import Data”
SAS Import CSV Data Documentation

Python

Export Python Data to CSV

Requires csv Python library. Syntax/Code Example
Import csv
with open('eggs.csv', 'w', newline='') as csvfile:
spamwriter = csv.writer(csvfile, delimiter=' ',
quotechar='|', quoting=csv.QUOTE_MINIMAL)
spamwriter.writerow(['Spam'] * 5 + ['Baked Beans'])
spamwriter.writerow(['Spam', 'Lovely Spam', 'Wonderful Spam'])
Python can export to a variety of files other than CSV.
Python Exporting CSV Documentation

Import CSV Data into Python

Pandas library helpful for importing and exporting csv files. Syntax/Code Example
Import pandas and pd
data = pd.read_csv("filename.csv")
Import CSV into Python Documentation

Mathematica

Export Mathematica Data to CSV

Syntax:
Export["file","Table"]
Example Code:
Export[“U:/Documents/Transfers/mathematica.csv”, Data_object]

Import CSV Data into Mathematica

Syntax:
Data_object = Import["file”]
Code Example:
Data_object = Import[“U:/Documents/Transfers/mathematica.csv”]
Mathematica Importing Exporting CSV Documentation

JMP

Exporting JMP Data to CSV

Example Code:
Current data table() << Save(“Filename.csv”, text)
Using Menu:
Activate dataset window. ‘File’ -> ‘Export’
JMP Exporting to CSV Documentation

Importing CSV Data into JMP

Example Code:
Open("dataGSS2.csv", End of Filed(comma),
Columns(
year = Numeric(4),
hh1 = numeric(1),
hh2 = numeric(2)
)
);

Using Menu:
‘File’ -> ‘Open’ -> change file types to ‘Text Files’ for importing CSV.
JMP Importing Text Files Documentation

Minitab

Exporting Minitab Data to CSV

Using Menu:
Activate Data. ‘File’ -> ‘Save Worksheet As’ -> Change ‘Save as type:’ to CSV -> Save file

Importing CSV into Minitab

Using Menu:
‘File’ -> ‘Open’ -> Change file type to be ‘Excel Files’, ‘Text’ or ‘All’. Select file you want to import and press ‘Open’.

Atlas.ti Exporting

Qualitative Software.
Export entire Atlas.ti project using Menu:
“File” -> “Export” -> “Project Bundle”
“Import & Export” tab with more exporting details.
Atlas.ti Exporting Projects Documentation

NVivo Exporting

Qualitative software.
“Share” tab from home menu has options for exporting specific files or exporting an entire project file.
#Export Specific Files within NVivo Project
Click on items in list. “Share” tab in menu -> “Export” or “Export List”
#Export Entire Project file
“Share” tab in menu -> “Copy Project”
NVivo Exporting Projects