Languages
Wiki
All Wiki Articles Create Wiki Article
excel
microsoft
csv
text-to-columns
data-tools
columns
[Edit]
EN

Microsoft Excel - split CSV data to columns

2 contributors
7 contributions
0 discussions
0 points
Created by:
Erica33
439

This article will show you how to split comma-separated values (CSV) data into columns in Microsoft Excel.

Practical example

Microsoft Excel - split CSV data to columns

Steps

  1. Go to Data > Data Tools > Text to Columns.
  2. Check the Delimited option, click Next, and choose Comma as the delimiter.
  3. In the next step, you can choose column data format, after that click Finish.
Donate to Dirask
Our content is created by volunteers - like Wikipedia. If you think, the things we do are good, donate us. Thanks!
Direct link
Join to our subscribers to be up to date with content, news and offers.

Microsoft Excel

Microsoft Excel - delete columns
Microsoft Excel - delete rows
Microsoft Excel - export data to csv UTF-8 encoded file
Microsoft Excel - freeze first column
Microsoft Excel - freeze top row
Microsoft Excel - get name of day for specific date
Microsoft Excel - hide columns
Microsoft Excel - hide rows
Microsoft Excel - insert columns
Microsoft Excel - insert rows
Microsoft Excel - merge / unmerge cells
Microsoft Excel - split CSV data to columns
Microsoft Excel - unfreeze panes
Native Advertising
🚀
Get your tech brand or product in front of software developers.
For more information Contact us
Dirask - we help you to
solve coding problems.
Ask question.

❤️💻 🙂

Join