How to Open CSV file (in Excel and Google Sheets)

Published 05 February 2020


You will learn how to open CSV file in Excel and in Google Sheets. CSV (comma-separated values) is a text file, and to start we will open a CSV file also in a text editor.

Next, you will learn how to read CSV files (import CSV file) in Microsoft Excel using an Excel Import Text wizard. You will find a step by step guide on all the settings you have to select to get the file in a CSV format opened in Excel correctly.

And, finally, you will learn how to upload a CSV file from your computer to open it in Google Sheets.

Automate your data import tasks
Use Auto-import to perform regular data uploads into your business apps. Learn more
Your familiar CSV import, but better
Import2 Wizard helps you bring the data you want into the tools you use - whether it be contacts, accounts, deals, tickets, customers, emails, tasks, notes and more. Learn more
Business Data Glossary
We know that talking about data could be confusing. Here is a list of terms for you to get up to speed. Learn more