How to convert a CSV file using Excel

If you want to convert a CSV file using Excel just follow these easy steps:

1. Open the CSV file. In most cases, Excel is already set as the default program to open a CSV file, but if it isn’t you can just use right click -> “Open with” on the file to open it using Excel.

2. Mark the first column (column A). Switch to the tab “Data” and choose the option “Text to Columns” to open the wizard.

3. First steps first: Chose “Delimited” on the first screen and confirm by clicking “Next”

4. Activate Comma and Semicolon as Delimiters and click “Next” here, as well as on the next screen. Close the wizard by clicking “Finish”. The data is now sorted into columns and rows.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk