Saving and file formats (xlsx, csv) in Excel - Step-by-Step Guide

Introduction

Saving your work in Excel lets you keep your data safe and share it with others. Different file formats like XLSX and CSV help you use your data in different ways, such as keeping all features or making it easy to open in other programs.

When you want to save your Excel workbook with all formulas, formatting, and multiple sheets for later editing.

When you need to share data with someone who does not use Excel but can open simple text files.

When you want to import your data into another program that only accepts CSV files.

When you want to keep a backup copy of your work in Excel's default format.

When you want to create a plain text version of your data without formulas or formatting.

Steps

Step 1: Click

- File tab

The backstage view opens showing options like Save, Save As, and Export

Step 2: Click

- Save As

A dialog box appears to choose where to save your file

Step 3: Type

- File name box

You enter the name you want for your file

Step 4: Click

- Save as type dropdown menu

A list of file formats appears for you to choose from

Step 5: Select

- File format list

The chosen format is set for saving the file

💡 Choose XLSX to keep all Excel features or CSV to save plain text data

Step 6: Click

- Save button

The file is saved in the chosen location and format

Before vs After

Before

Workbook is open and unsaved or saved in default format

After

Workbook is saved with the chosen name and format in the selected folder

Settings Reference

Save as type

📍 Save As dialog box

Choose the file format to save your workbook depending on your needs

Default: Excel Workbook (*.xlsx)

File name

📍 Save As dialog box

Set the name for your saved file

Default: Current workbook name

Common Mistakes

Saving a file as CSV without realizing it removes formulas and formatting

CSV files only save plain text data, so formulas and colors are lost

Save as XLSX if you want to keep formulas and formatting; use CSV only for plain data sharing

Not changing the file extension when renaming a file

The file may not open correctly if the extension does not match the format

Always select the correct file format from the dropdown to set the right extension

Summary

Saving files in Excel lets you keep your work safe and share it.

XLSX format keeps all Excel features like formulas and formatting.

CSV format saves only plain text data, good for sharing with other programs.