How to Save an Excel File (Local, OneDrive, PDF, and CSV)
- Peter J.
- Jul 3
- 5 min read
To save an Excel file, press Ctrl + S (Windows) or Cmd + S (Mac). If it’s a new file, Excel will ask you to choose a location and file name. To save a copy in a different format (like PDF or CSV), go to File > Save As and choose your format from the dropdown.
Saving in Excel sounds straightforward, but there are several options that matter a lot depending on what you’re trying to do. This guide covers all of them.
The Difference Between Save and Save As
Save (Ctrl + S): Saves your changes to the existing file, in the same location, with the same name. If you’ve never saved this file before, Excel treats the first save like a “Save As” and asks you where to put it.
Save As (Ctrl + Shift + S or File > Save As): Saves a new copy of your file. You can choose a new name, a new location, or a different file format. The original file stays unchanged.
💡Tip: Use Save As when you want to make a backup before making big changes. Open your file, go to Save As, name it “filename_backup_2026-06-28,” and work in the original. That way you can always go back.
How to Save an Excel File to Your Computer
Step 1: Press Ctrl + S
If you haven’t saved yet, Excel opens the Save As screen. If you have saved before, it saves silently in the background.
Step 2: Choose a Location (for new files)
You’ll see options like This PC, OneDrive, Desktop, and recent folders. Click the folder where you want to save.
If you want to save to a specific folder, click Browse to open a file explorer window and navigate there.
Step 3: Name Your File
At the top of the Save dialog, there’s a field showing the file name. Click it and type the name you want. Be descriptive; “Budget_Q2_2026” is better than “Book1.”
Step 4: Choose a File Format
The Save as type dropdown defaults to .xlsx (standard Excel format). Most of the time, leave this as-is. See the formats section below if you need something different.
Step 5: Click Save
Click the Save button. Your file is saved.
How to Save to OneDrive (and Enable AutoSave)
OneDrive is Microsoft’s cloud storage. Saving there gives you two big benefits: your file is accessible from any device, and AutoSave turns on automatically.
AutoSave saves your changes every few seconds, so you never lose work. You’ll see an AutoSave toggle in the top-left corner of Excel when a file is saved to OneDrive.
How to Save to OneDrive
Go to File > Save As.
Click OneDrive in the left column.
Choose a folder within your OneDrive.
Name the file and click Save.
From now on, AutoSave handles saving for you. You’ll see “AutoSave On” in the top-left toolbar.
⚠️ Watch out: If you share a OneDrive file, other people with access can edit it. Set sharing permissions carefully. This is less of an issue with locally saved files.
How to Save as a Different File Format
Save as PDF
PDFs are perfect for sharing a file you don’t want others to edit. The formatting is locked, and anyone can open it without needing Excel.
Go to File > Save As (or File > Export).
Choose PDF from the Save as type dropdown.
Choose the page range if needed.
Click Save (or Publish).
💡 Tip: Before saving as PDF, set up your print area and page layout so it looks right. See our guide on how to print a spreadsheet so it fits on one page.
Save as CSV
CSV stands for “Comma-Separated Values.” It’s a plain text format that most programs (databases, other spreadsheet apps, websites) can read. Use it when you need to export data from Excel to another system.
Go to File > Save As.
Choose CSV (Comma delimited) from the Save as type dropdown.
Click Save.
Excel will warn you that CSV doesn’t support multiple sheets or formatting. Click OK to continue.
⚠️ Watch out: CSV saves only the active sheet. Any other sheets in your workbook are not included. Any formatting (colors, fonts, merged cells) is also lost. This is fine for raw data; CSV is about the data, not the look.
Common File Formats Summary
Format | Extension | When to use |
Excel Workbook | .xlsx | Standard. Use this almost always. |
Excel 97-2003 | .xls | For sharing with very old Excel versions. Rare. |
CSV | .csv | Exporting data to other programs or databases. |
Sharing a read-only, print-ready version. | ||
Excel Macro-Enabled | .xlsm | Only needed if your file contains macros. |
How to Recover an Unsaved Excel File
Excel automatically creates temporary recovery files. If Excel crashes or you close without saving, here’s how to recover:
Method 1: AutoRecover on Reopen
Next time you open Excel after a crash, a Recovered Files panel usually appears on the left side. Click the file to open it.
Method 2: Manage Workbook
Open Excel and create a blank workbook.
Go to File > Info.
Look for Manage Workbook and click the dropdown.
Choose Recover Unsaved Workbooks.
A folder opens with .xlsb or .xlsrecovery temp files. Open the most recent one.
Step: Save Immediately After Recovery
Once you recover the file, save it properly right away with Ctrl + S. Recovered temp files are deleted after a few days.
💡 Tip: You can adjust how often Excel creates AutoRecover files. Go to File > Options > Save and change the “Save AutoRecover information every X minutes” setting. Setting it to every 2–5 minutes is a good safety net.
How to Turn Off AutoSave (When You Don’t Want It)
Sometimes AutoSave causes problems; for example, if you’re making experimental edits to a shared file and don’t want to accidentally save half-finished work.
Click the AutoSave toggle at the very top-left of Excel to turn it off. Excel will ask if you want to keep a local copy. Say yes, then make your changes locally, and only save when you’re ready.
Common Mistakes
Closing without saving. Excel will ask “Do you want to save?”; but it’s easy to click “Don’t Save” by mistake. Make it a habit to save manually (Ctrl + S) before closing.
Saving over a file you needed to keep. Always use Save As and a new name if you want to keep the original.
Sharing a .csv file thinking the formatting will be there. CSV doesn’t keep any formatting. If you need formatting, share as .xlsx or .pdf.
Saving to the Desktop. The Desktop is fine short-term but clutters up fast. Use organized folders.
Frequently Asked Questions
Does Excel save automatically?
By default, Excel does NOT auto-save locally. It only auto-saves when the file is stored on OneDrive and AutoSave is turned on. Always press Ctrl + S regularly if you’re saving locally.
How do I save a copy without overwriting the original?
Use File > Save As and give it a new name or save it to a different location. The original file stays unchanged.
Can I save an Excel file so it opens in Google Sheets?
Yes. Excel .xlsx files can be opened directly in Google Sheets; just upload the file to Google Drive and double-click it. Or in Google Drive, go to New > File Upload to add your .xlsx file.
What does “Read Only” mean when I open a file?
It means you can view the file but not save changes to it. This happens when the file is marked as Read Only, when someone else has it open, or when it’s on a network drive without write permission. Look for an Enable Editing button at the top to unlock it.
Wrapping Up
Saving in Excel gives you more options than it might seem at first; local vs cloud, different formats, recovery, AutoSave. The core habit to build: press Ctrl + S regularly, especially before any big operation. And use Save As whenever you want to keep a backup.
Ready to go further?
Get up to speed with all the basics in our Excel for Beginners guide