Knowledge Base

How Do I Save My Spreadsheet As A CSV File?

Comma-separated values, commonly known as CSV, stores tabular data (numbers and text) as plain text. It’s a really popular file format. One of the reasons for this is because the vast majority of organizations and applications worldwide support CSV files.

A CSV file is plain text and an average user or even a novice can easily understand it without any learning curve. CSVs files allow users to glance at the file and immediately diagnose the problems with data, if any, change the CSV delimiter, quoting rules, etc.

The Pirsonal platform allows any account under any type of plan to easily create personalized videos, personalized landing pages, and personalized in-video calls-to-action from CSVs using the Campaign tool.

In this article, you’ll learn how to convert Excel, Google Sheets or XLS documents to CSV UTF-8 format or how to simply save any spreadsheet as a CSV file.

How to convert an Excel file to CSV

These are the instructions to export an Excel workbook to the CSV format by using Excel’s Save As command option:

  1. In your Excel workbook, switch to the File tab and click Save As.
  2. In the Save as type dropdown, select “CSV (Comma delimited)”.

Please note that this will only save the active Excel sheet.

How to convert a Google Sheets file to CSV

If you use Google Drive, you’ll also have access to Google Sheets. Once you have opened the Google Sheet file you want to export as a CSV, follow these steps:

  1. In the desired sheet, switch to the File tab and click Download as.
  2. Select “Comma-separated values (.CSV)”.

Please note that this will only save the active Excel sheet.

Related Articles