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

Published 06 February 2020

Description

You will see how to create CSV files in Excel and in Google Sheets.

First, you will learn where the name CSV came from - comma-separated values. CSV file is a text file, however, it is best viewed in a spreadsheet program.

Next, you’ll learn how to write CSV files if you were editing it in Microsoft Excel. What format to select when you save Excel to CSV.

Finally, you’ll see how to create a CSV file in Google Sheets so your file gets saved to your computer.

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
One Data Backup Solution for all your business apps
Set up your own data backup process to ensure that your data is always there for that moment when you need it most. Learn more