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/TO | CSV | Excel | SQL Server | SQLite | SQL Script (*.sql) | R dataset | Python - Pandas DataFrame |
|---|---|---|---|---|---|---|---|
| CSV | - - - - - - - - - | From CSV to Excel | Text to SQL Server | Import CSV to SQLite From CSV to SQLite | Reading Data into R | Read a CSV File into Python | |
| Excel | From Excel to CSV | - - - - - - - - - | Excel to SQL Server with Copy Paste | Create Table SQL Script in Excel | Reading Data into R | Excel into Python (pandas) | |
| SQL Server | SQL Server to CSV | SQL Server Export to Excel SQL Server Link to Excel SQL Server to Excel (Copy Paste) | - - - - - - - - - | Generate a SQL Script | SQL Server to Python SQL Server to Python with SQLAlchemy |
||
| SQLite | From SQLite to CSV | - - - - - - - - - | From SQLite to SQL Script | Import SQLite to Python | |||
| SQL Script (*.sql) | SQL Script into SQLite | - - - - - - - - - | |||||
| R dataset | The write.csv Function in R | - - - - - - - - - | |||||
| Python - Pandas DataFrame | Pandas DataFrame to CSV | Pandas DataFrame to Excel | Pandas DataFrame to SQLite | Pandas DataFrame to SQL Script | - - - - - - - - - | ||
| FROM/TO | CSV | Excel | SQL Server | SQLite | SQL Script (*.sql) | R | Python |
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.