Have you ever wondered how to work with CSV (comma separated values) files if you don’t have Microsoft Excel or similar softwares to handle tabular data? Have you even been asked to convert a table in text form to a csv or xlsx format? With Sublime Text, you can easily manage existing csv files or covert text files to csv files. Sublime Text is actually a text editor but it does much more than editing text! This post will help you select, move, adjust columns of a CSV (or text) file in sublime text. This can be used to convert tables created in text files into CSV.

Let us take an example CSV format as below

Let us select Column2 and paste it below.

  1. Bring the cursor before “Column1”

  1. For MAC users, press and hold control + shift and use down arrow key to select all the rows.

  1. For MAC users, press and hold control + shift and useright arrow key to reach end of Column1.

  1. Now use only right arrow key to reach the beginning of the next column.

  1. Again press and hold control + shift and useright arrow key to select Column2.

  1. For MAC users press command + x for cut, press down arrow key to go to desired location below.

  1. Press command + v for paste.

That’s it! Now you can adjust columns as per your need to create new tables and modify existing tables.