|

How to Create, Save, Open, and Rename an Excel File

How to Create, Save, Open, and Rename an Excel File

BLOG By query Jun 12, 2026 Updated Aug 11, 2026 9 min read

Learning how to create, save, open, and rename an Excel file is one of the first things every beginner should know.

Before you start using formulas, charts, tables, or reports, you need to understand how to manage your Excel files properly.

An Excel file is called a workbook. A workbook is where you enter your data, create worksheets, make calculations, and save your work.

In this guide, you will learn how to create a new Excel file, save it, open it again, and rename it in simple steps.

What Is an Excel File?

An Excel file is a document created using Microsoft Excel.

It is also called a workbook.

A workbook can contain one or more worksheets. A worksheet is the sheet where you enter data in rows, columns, and cells.

For example, you can create an Excel file for:

  • A monthly budget
  • A sales report
  • A school marks sheet
  • A customer list
  • An attendance register
  • A business expense tracker
  • An inventory list

When you save an Excel file, it usually ends with the file extension:

.xlsx

For example:

Monthly Budget.xlsx

The .xlsx part tells your computer that the file is an Excel workbook.

Why File Management Is Important in Excel

Good file management helps you avoid losing your work.

If you do not save your Excel file, your work may disappear when you close Excel or when your computer shuts down unexpectedly.

If you do not give your file a clear name, you may struggle to find it later.

If you do not know how to open and rename files, working with Excel can become frustrating.

That is why beginners should first learn how to create, save, open, and rename Excel files.

How to Create a New Excel File

Creating a new Excel file means starting a new workbook.

Here are the basic steps.

Step 1: Open Microsoft Excel

First, open Microsoft Excel on your computer.

You can do this by clicking the Excel icon from your desktop, Start menu, taskbar, or applications list.

When Excel opens, you may see the start screen.

This screen usually shows options such as:

  • Blank workbook
  • Recent files
  • Templates
  • Open

Step 2: Click Blank Workbook

To create a new file, click Blank workbook.

A new empty Excel workbook will open.

You will see a grid made up of rows, columns, and cells.

This is where you can start typing your data.

Step 3: Enter Your Data

Click any cell and start typing.

For example, you can type a simple budget like this:

ItemAmount
Rent15000
Food8000
Transport5000
Internet3000

This is now your new Excel file, but it has not yet been saved.

How to Save an Excel File for the First Time

Saving an Excel file keeps your work safe.

When you save a file, you choose a file name and where the file should be stored.

Step 1: Click File

At the top left corner of Excel, click File.

This opens the file menu.

Step 2: Click Save As

If the file has never been saved before, click Save As.

Save As allows you to choose the name and location of the file.

Step 3: Choose Where to Save the File

You can save the file in different places, such as:

  • Documents folder
  • Desktop
  • Downloads folder
  • OneDrive
  • External flash drive
  • A specific project folder

For beginners, the Documents folder is usually a good place to start.

Step 4: Give the File a Clear Name

Type a name for your Excel file.

Choose a name that clearly explains what the file contains.

Good file names include:

  • Monthly Budget.xlsx
  • Sales Report January.xlsx
  • School Marks Term 1.xlsx
  • Customer List.xlsx
  • Inventory 2026.xlsx

Avoid names like:

  • Book1.xlsx
  • New File.xlsx
  • Excel Work.xlsx
  • My Stuff.xlsx

Clear names make files easier to find later.

Step 5: Click Save

After choosing the file name and location, click Save.

Your Excel file is now saved.

From now on, when you make changes, you can press Ctrl + S to save quickly.

What Is the Difference Between Save and Save As?

Many beginners confuse Save and Save As.

Here is the simple difference.

Save updates the current file.

Use Save when you want to keep changes in the same file.

Save As creates a new file or saves the file in a new location.

Use Save As when you want to:

  • Give the file a new name
  • Save a copy
  • Save the file in another folder
  • Create a second version of the same file

For example, if you have a file called:

January Sales.xlsx

You can use Save As to create another copy called:

February Sales.xlsx

This helps you keep separate versions.

How to Save Changes in an Existing Excel File

After saving your file for the first time, you can continue editing it.

Whenever you make changes, save the file again.

You can save changes in three common ways:

  • Click File, then Save
  • Click the Save icon at the top
  • Press Ctrl + S on your keyboard

The shortcut Ctrl + S is one of the most useful shortcuts for beginners.

Use it often so you do not lose your work.

How to Open an Existing Excel File

Opening an Excel file means accessing a workbook that was already created and saved.

There are several ways to open an Excel file.

Method 1: Open from Excel

Open Microsoft Excel.

Click File.

Click Open.

Choose the location where the file is saved, such as Documents, Desktop, or OneDrive.

Click the file you want to open.

Then click Open.

The Excel workbook will appear on your screen.

Method 2: Open from Recent Files

When you open Excel, you may see a list of recent files.

These are files you opened or worked on recently.

To open one, simply click the file name.

This is a quick way to continue working on a file.

Method 3: Open from a Folder

You can also open an Excel file directly from your computer folder.

Go to the folder where the file is saved.

For example, open your Documents folder.

Find the Excel file.

Double-click the file.

It will open in Microsoft Excel.

Method 4: Open from OneDrive

If your file is saved in OneDrive, you can open it from your OneDrive folder or through Excel.

OneDrive is Microsoft’s cloud storage service.

It allows you to save files online and access them from different devices.

This is helpful if you want to work from a laptop, desktop, or phone.

How to Rename an Excel File

Renaming an Excel file means changing its file name.

You may need to rename a file when the current name is unclear, outdated, or incorrect.

For example, you may want to change:

Book1.xlsx

to:

Monthly Budget 2026.xlsx

There are different ways to rename an Excel file.

Method 1: Rename the File from a Folder

First, close the Excel file if it is open.

Go to the folder where the file is saved.

Right-click the file.

Click Rename.

Type the new file name.

Press Enter.

Your Excel file now has a new name.

Method 2: Rename Using Save As

Open the Excel file.

Click File.

Click Save As.

Choose where to save the file.

Type the new file name.

Click Save.

This creates a copy of the file with the new name.

The old file may still remain unless you delete it.

This method is useful when you want to keep both the old and new versions.

Method 3: Rename a File Saved in OneDrive

If your Excel file is saved in OneDrive, you may be able to rename it from OneDrive.

Open OneDrive.

Find the file.

Right-click the file or click the menu option.

Choose Rename.

Type the new name.

Save the change.

The renamed file will update in OneDrive.

Best Practices for Naming Excel Files

Choosing a good file name is important.

A good file name helps you know what the file contains without opening it.

Use clear and specific names.

For example:

Business Expenses March 2026.xlsx

is better than:

Expenses.xlsx

You can include:

  • The topic
  • The month
  • The year
  • The department
  • The project name
  • The version number

Good examples include:

  • Personal Budget June 2026.xlsx
  • Sales Report Q1 2026.xlsx
  • Inventory List Main Store.xlsx
  • Staff Attendance May 2026.xlsx
  • Project Tracker Version 2.xlsx

File Naming Mistakes to Avoid

Avoid file names that are too vague.

For example:

  • Final.xlsx
  • New.xlsx
  • Test.xlsx
  • Copy.xlsx
  • Work.xlsx

Also avoid creating too many confusing versions like:

  • Budget Final.xlsx
  • Budget Final 2.xlsx
  • Budget Final Final.xlsx
  • Budget Final Real.xlsx

Instead, use clear version names such as:

  • Budget Draft 1.xlsx
  • Budget Draft 2.xlsx
  • Budget Approved.xlsx

This makes your files easier to manage.

How to Know If Your Excel File Is Saved

You can usually tell that your Excel file is saved by checking the file name at the top of Excel.

If your file still has a name like Book1, it may not have been saved with a proper name yet.

If you see your chosen file name, such as Monthly Budget.xlsx, then the file has been saved.

If you try to close an unsaved file, Excel may ask whether you want to save changes.

Always read this message carefully.

If you click Don’t Save, your recent work may be lost.

What Happens If You Close Excel Without Saving?

If you close Excel without saving, you may lose your changes.

Sometimes Excel may recover unsaved files, but you should not depend on this.

The safest habit is to save your work regularly.

Use Ctrl + S often while working.

This is especially important when creating long reports, budgets, or lists.

What Is AutoSave in Excel?

AutoSave is a feature that can automatically save your file as you work.

It usually works when your file is saved in OneDrive or SharePoint.

If AutoSave is turned on, Excel saves changes automatically.

This is useful because it reduces the risk of losing work.

However, beginners should still understand manual saving because not all files use AutoSave.

If your file is saved only on your computer, AutoSave may not work the same way.

How to Create a Copy of an Excel File

Sometimes you may want to keep the original file and create another copy.

For example, you may have a budget template and want to create a new budget for a new month.

To create a copy:

Open the file.

Click File.

Click Save As.

Give it a new name.

Click Save.

For example, you can change:

Budget Template.xlsx

to:

Budget June 2026.xlsx

Now you have a new copy while the original remains unchanged.

Common Excel File Extensions

The most common Excel file extension is:

.xlsx

This is the standard Excel workbook format.

You may also see:

.xls
An older Excel file format.

.csv
A simple file used to store data separated by commas. It is often used for exporting and importing data.

.xlsm
An Excel file that can contain macros.

For beginners, the main one to remember is .xlsx.

Key Takeaways

  • An Excel file is called a workbook.
  • A workbook can contain one or more worksheets.
  • A saved Excel file usually ends with .xlsx.
  • Use Blank workbook to create a new Excel file.
  • Use Save As when saving a file for the first time or creating a copy.
  • Use Save to update an existing file.
  • Use Ctrl + S often to save your work quickly.
  • Give Excel files clear and meaningful names.
  • You can open Excel files from Excel, Recent Files, folders, OneDrive, or mobile apps.
  • Rename files carefully so they are easy to find later.

Keep learning

Read next

Leave a Reply

Your email address will not be published. Required fields are marked *