Import and Export Tables


Do you find yourself converting data tables between different formats such as Excel or comma separated values? Are you feeling a little overwhelmed with the data highways going this way and that way? The table below has some links to other posts at this site. On the left side is where you are starting from and across the top is the destination.

Click one of the links in the matrix to get instructions and examples on how to do the task.

FROM/TOCSVExcelSQL ServerSQLiteSQL Script (*.sql)R datasetPython - Pandas DataFrame
CSV- - - - - - - - From CSV to ExcelText to SQL ServerImport CSV to SQLite
From CSV to SQLite
Reading Data into RRead a CSV File into Python
ExcelFrom Excel to CSV- - - - - - - - Excel to SQL Server with Copy PasteCreate Table SQL Script in ExcelReading Data into RExcel into Python (pandas)
SQL ServerSQL Server to CSVSQL Server Export to Excel SQL Server Link to Excel
SQL Server to Excel (Copy Paste)
- - - - - - - - Generate a SQL ScriptSQL Server to Python
SQL Server to Python with SQLAlchemy
SQLiteFrom SQLite to CSV- - - - - - - - From SQLite to SQL ScriptImport SQLite to Python
SQL Script (*.sql)SQL Script into SQLite- - - - - - - -
R datasetThe write.csv Function in R- - - - - - - -
Python - Pandas DataFramePandas DataFrame to CSVPandas DataFrame to ExcelPandas DataFrame to SQLitePandas DataFrame to SQL Script- - - - - - - -
FROM/TOCSVExcelSQL ServerSQLiteSQL Script (*.sql)RPython

Other Formats

There are many other data formats that are not part of this matrix. For example I have not included JSON or XML.

The above table was made with the TablePress plugin.

Leave a comment

Your email address will not be published. Required fields are marked *