How to Convert CSV files to Excel

Some of your Downloads in Skynamo might be downloaded in a .csv format, and not the .xlsx that you are used to. To get this information in a more readable format for you to work on, you can follow a few easy steps.

If you can download the dataset you are looking at, it will have three dots displayed to the right. After clicking on these, select the Download CSV button, and open the downloaded file.

Step 1: Once the spreadsheet has opened select the entire column A.

Step 2: Select the Data tab at the top, and then click the “Text to Columns” button

Step 3: Ensure that the “Delimited” option is selected, indicating that the data is separated by a character such as a comma (,) or period (.) and click the “Next” button at the bottom.

Step 4: From the options in the list select the character separating each field, untick all the others that aren’t applicable, and select next.

Step 5: Check to ensure the data displays correctly, and then click Finish.

If you have any further questions, please reach out to our support team by sending an email to support@skynamo.com