Save, share and file formats in Excel might not sound like the most exciting topic in the world — but they are the ones that will save you from a genuine panic moment at work. You know the feeling: you spent an hour on a spreadsheet, something goes wrong, and suddenly the file is gone, broken, or in a format nobody can open. This guide exists so that never happens to you.

We are going to walk through everything — how to save properly, which format to use and when, and how to share your workbook with someone else without anything going wrong. By the end, this whole area of Excel will feel completely comfortable.

Think of this lesson as your Excel safety net. Once you understand how save, share and file formats in Excel all connect, you will work with a lot more confidence — and a lot less second-guessing.

How to Save a Workbook in Excel

Most people learn one save method and stick with it forever. Here is the thing — Excel actually gives you three different options, and they all do different things. Using the wrong one at the wrong moment can mean accidentally overwriting a file you needed, or losing track of which version you are working on.

Save vs. Save As vs. Save a Copy

Save is the straightforward one. It updates the file you are currently working on with your latest changes. Press Ctrl+S and it is done — no dialog box, no prompts. Use this constantly while you work. Every few minutes is not too often.

Save As is for when you want to create a new version of the file. Maybe you want to give it a different name, save it in a different folder, or change the file format entirely. The thing most people do not realise is that after you Save As, Excel switches you over to the new file. Your original stays untouched, but now you are working in the copy.

Save a Copy does something slightly different. It also creates a new file, but you stay in the original. Think of it like making a photocopy — the copy goes somewhere else, but you keep working on the one in your hands. This is perfect when you want to send someone a version of your file but keep going on your own.

Keyboard Shortcuts for Saving

What Is AutoSave and How Do You Turn It On?

AutoSave is the little toggle in the very top-left corner of your Excel window. When it is on, Excel saves your file automatically every few seconds without you having to do a thing.

Here is the catch that trips everyone up: AutoSave only works when your file is stored on OneDrive or SharePoint. If your file is sitting on your desktop or in a folder on your computer, that AutoSave toggle will be greyed out. You cannot turn it on for a local file.

To get AutoSave working, save your file to OneDrive first. Go to File, then Save As, and choose OneDrive from the list of locations. Once the file is there, AutoSave activates automatically. If you do not have OneDrive, Excel’s AutoRecover feature saves a temporary backup — we will cover recovering that later.

Excel File Formats Explained

This is where most beginners get confused, and it is completely understandable. When you click Save As, Excel offers you a long list of formats and it is not obvious which one to pick. Here is the honest, plain-language breakdown of the formats you will actually encounter.

.xlsx — The Default Modern Format

This is the one Excel uses when you create a new file and save it. It supports everything — formulas, formatting, charts, multiple sheets, named ranges, the works. Unless you have a specific reason to use something else, save everything as .xlsx. It is the right choice for day-to-day work.

.xls — The Legacy Format and Compatibility Mode

The .xls format predates Excel 2007. You will mostly encounter it when someone sends you an old file. When you open one, you will see “Compatibility Mode” in brackets in the title bar. That is Excel telling you it is working in a restricted mode.

You’ve probably seen that label and ignored it. To fix it, go to File, then Info, and click Convert. Excel upgrades the file to .xlsx and everything goes back to normal.

.xlsm — When You Need Macros

If your workbook contains macros — automated scripts written in VBA — you must save it as .xlsm. That M stands for macro-enabled. If you try to save a macro workbook as .xlsx, Excel will warn you that the macros will be deleted. Always save macro files as .xlsm.

Excel Save as CSV — How It Works and What You Lose

CSV stands for Comma-Separated Values. It is a plain text file where your data is stored as rows and columns separated by commas. No formulas. No formatting. No charts. No multiple sheets. Just raw data from a single worksheet.

So why use CSV at all? Because almost every system in the world can read one. Databases, websites, CRMs, accounting software — they all accept CSV. When you need to move data out of Excel into another system, CSV is usually what that system wants. Trust me on this though: always keep your .xlsx original safe before you export anything as CSV.

PDF — The Best Format for Sharing Read-Only Files

Saving as PDF turns your spreadsheet into a document that looks exactly like your Excel file but cannot be edited. It opens on any device, in any browser, even if the recipient does not have Excel installed. Use PDF when you are sharing something final — a report, invoice, or budget summary — and you do not want anyone changing a single cell.

.ods — For Google Sheets and LibreOffice Users

The .ods format is used by Google Sheets and LibreOffice. You will rarely need it, but if someone who does not use Microsoft Office is having trouble opening your file, saving as .ods can fix that.

How to Save an Excel File as CSV

Before you do anything else: save your workbook as .xlsx first and make sure that copy is somewhere safe. Once you save as CSV, formulas are gone. Formatting is gone. If the .xlsx disappears, you cannot get any of that back.

How to Share an Excel Workbook — 3 Easy Methods

There are three main ways to share your workbook. Which one you pick depends on what you want the other person to do with the file.

Method 1 — Share via OneDrive (Real-Time Collaboration)

This is the best method when you want multiple people working on the same file at the same time. Everyone edits one shared version and changes appear in real time. No more emailing three different copies back and forth and trying to figure out whose version has the latest numbers.

Can Edit — the person can add data, change formulas, delete content. Use for team members actively contributing.

Can View — the person can open and read the file but cannot change a single thing. Use when you want someone to review without any risk of edits.

Method 2 — Share as an Email Attachment

This is the right call when you are sending a one-off copy to someone and you do not need ongoing collaboration — just a file in their inbox.

1. Click File and then Share.
2. Select Email.
3. Choose Send as Attachment for an editable .xlsx file, or Send as PDF for a read-only version.
4. Your email app opens with the file already attached. Add the recipient’s address and send.

The rule of thumb is simple: if the person needs to work with the data, send .xlsx. If you are sharing a finished document you do not want edited, send PDF.

Method 3 — Share a Link via OneDrive

If your file is already saved on OneDrive, generating a shareable link is often the cleanest option. The recipient always opens the latest version — there is no old attachment floating around in someone’s inbox from three weeks ago.

1. Click the Share button in the top-right corner.
2. At the bottom of the sharing panel, click Copy Link.
3. Click the settings next to the link to control who can access it and what they can do.
4. Set it to Anyone with the link can view or Anyone with the link can edit.
5. For extra security, add an expiry date or a password in the link settings.
6. Copy the link and paste it wherever you need — an email, a message, a project tool.

Save, Share and File Formats in Excel — Common Mistakes to Avoid

You now know the right way to handle save, share and file formats in Excel. Here is what tends to go wrong for beginners — and how to make sure it does not happen to you.

How to Recover Unsaved or Previous Versions of an Excel File

Recovering an Unsaved File Using AutoRecover

Excel crashed. You closed a file without saving. Whatever happened — here is how to try to get your work back.

1. Open Excel and click File.
2. Select Open from the left panel.
3. Scroll to the bottom and click Recover Unsaved Workbooks.
4. Select your file from the list and click Open.
5. Immediately click Save As and save it properly to your chosen location.

Restoring a Previous Version via Version History

If your file is saved on OneDrive, Version History keeps a complete record of every saved version with timestamps. This is brilliant for those moments when you realise you deleted something important three days ago and only just noticed.

1. Click File and then Info.
2. Look for Version History on the right side and click it.
3. A panel opens showing a list of versions with dates and times.
4. Click any version to preview it in a new window.
5. If that is the version you want, click Restore at the top of the preview window.

Frequently Asked Questions

What is the best format to save an Excel file in?

For everyday use, .xlsx is the right answer. It preserves everything and works with all modern versions of Excel. Only switch to another format when you have a specific reason — CSV for exporting data, PDF for sharing finished documents.

How do I share an Excel file without others editing it?

Two options. Either send it as a PDF attachment via email. Or share a OneDrive link with the permission set to Can View. Both prevent the recipient from making any changes.

Why does my Excel file say Compatibility Mode?

Your file is saved in the older .xls format. Go to File, then Info, and click Convert to upgrade it to .xlsx. The Compatibility Mode label will disappear.

Can I save an Excel file as a PDF?

Yes. Go to File, then Save As, and choose PDF from the file type dropdown. Alternatively, go to File, then Export, and select Create PDF/XPS. The PDF will look identical to your spreadsheet and cannot be edited by the recipient.

Connect This to What You Already Know

The file you are saving and sharing is only as useful as the data inside it. If you want to make sure your workbooks are clean and well-organised before you share them with someone else, the lesson on entering and formatting data in Excel is worth revisiting. A well-formatted file makes a much better impression on whoever receives it.

And when you are ready to start doing real work inside those files — running calculations, building totals, working with percentages — the Excel formulas for beginners lesson on XplorExcel.com walks you through the most essential formulas step by step.

Wrapping Up

You now have a solid, practical understanding of how to save share and file formats in Excel all work together. You know which save method to use in which situation, how to pick the right file format for any scenario, how to share with the right permissions, and how to recover your work if something goes wrong.

The habits that will protect you going forward are simple: save often with Ctrl+S, always keep your .xlsx original before exporting to CSV, and check your sharing permissions before sending. Those three things alone will prevent most of the file problems that trip up beginners. You have finished Lesson 10 — on to the next one.