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:


  1. Create a Google Spreadsheet
  2. Upload the CSV
  3. Export to Excel format


Let’s deep dive in.


Create a Google Spreadsheet


To create a new spreadsheet:


  1. Open the Sheets home screen at sheets.google.com
  2. 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:


  1. Click on File
  2. Click on Import


click on file and import


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


click on upload and browse


  1. 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!