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

Published 05 February 2020

Description

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.

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
The Complete Introduction to CSV
A straightforward and practical exploration of all things CSV, from how to create and open files, converting CSV from other formats and troubleshooting common issues. Learn more
Unlock Your Data From any Business app
Use Free Export to download data from your apps, so you can save it or move it wherever makes sense for your business. Learn more