Articles on: Data Management

How to convert a CSV file to Excel?

Have you tried to open a CSV file of scraped data but just gathered a bunch of unreadable data?

csv file opened with excel looking terrible

In this short help article, we will see how to convert a CSV file into a clean Excel file.

With 3 easy steps:

Create a Google Spreadsheet
Upload the CSV
Export to Excel format

Let’s deep dive in.

Create a Google Spreadsheet



To create a new spreadsheet:

Open the Sheets home screen at sheets.google.com
Click New +. This will create and open your new spreadsheet.

click the + button to create a new spreadsheet

Upload the CSV



To upload the CSV:

Click on File
Click on Import

click on file and import

Click on Upload
Click on Browse. Choose the file you want to upload.

click on upload and browse

Click on Import data. It will create a new file with all your data.

click on import data

Export to Excel format



Click on File > Download > Microsoft Excel.

click on file > download > microsoft excel

An Excel file is downloaded on your computer.

Double click to open with Excel.
You now have a clean, structured and reliable Excel file.

excel file looking way better

Awesome!

Updated on: 11/06/2024

Was this article helpful?

Share your feedback

Cancel

Thank you!