I have downloaded a csv file, and when I open it in excel, it looks like the image below.

I would like to view the data in a table format. with each field in a separate column.

5

2 Answers

Follow these steps:

• Select Column A
• On the data tab, click Text to columns
• Ensure Delimited is selected and click next
• Ensure comma is selected and click finish.

See images below for reference.

Aaaaah CSV files and their oh so many flavours...

PeterH's answer would do the job quickly, but would not really well handle stuff like line feeds within a field (from what you screenshot show, you seemm to be in this case), or differences in character encoding.

Excel is very bat at opening CSV files if you double-click them from the file explorer, but there's a hidden gem in recent versions of Excel (you seem to have Office 365), that is very robust robust: go to Data > From a text/CSV file and then pick the encoding (start with 65001: Unicode (UTF8) and check in the sample below if the special characters appear nicely), the separator (comma is obviously the one in your case), and then click on Load, select where you want the import to be, and you should be done.

An alternative is to install LibreOffice that does a very good job at opening CSV files.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password Submit

Post as a guest

Post Your Answer Discard

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy