Convert a .csv or .tsv file to columns in Microsoft Excel
- 04 Oct 2023
- 1 Minute to read
- DarkLight
Convert a .csv or .tsv file to columns in Microsoft Excel
- Updated on 04 Oct 2023
- 1 Minute to read
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
- Once you have opened your .csv or .tsv file into Excel, select the column containing the Comma-Separated Values (or Tab-Separated Values).
- Under Data, click on Text to Columns. Make sure that Delimited is selected. Click on Next.
- Select Comma (for .csv file) or Tab (for .tsv file). Click on Next.
- Once you have confirmed by clicking on Finish, your Excel will display the data into separate columns.
Was this article helpful?
