The quickest way to save a copy

Open the file you want to copy in Excel. Go to File at the top left, then click Save As. Choose where you want the copy to go — your Desktop, Documents folder, or any other location on your computer. Give the copy a new name so you don't overwrite the original, then click Save. You now have two separate files: the original and the copy.

This takes about 30 seconds and is the method most people use because it's built into Excel and requires no extra software. The copy is a complete, independent file — you can edit it without touching the original.

Key Takeaways

  • Save As creates a new file with a name you choose, leaving the original untouched.
  • You can save the copy to a different folder, external drive, or cloud storage in the same step.
  • If you want to keep working on the original file, use Save As before making changes to create a backup first.
  • Cloud storage like OneDrive or Google Drive automatically keeps multiple versions of your files, so you don't have to manually save copies as often.

Where to save your copy

When you click Save As, Excel shows you a list of locations. The most common choices are your Documents folder, Desktop, or a folder you've created for a specific project. Pick whichever location makes sense for how you organize your files — if this is a backup, put it somewhere separate from your working copy so you don't accidentally edit the wrong one.

You can also save directly to an external drive (a USB stick or external hard drive plugged into your computer) or to cloud storage like OneDrive, Google Drive, or Dropbox. Cloud storage has an advantage: it keeps old versions automatically, so you can recover an earlier copy if you need to without manually saving multiple versions yourself.

Naming your copy so you can tell them apart

When you save a copy, Excel fills in the current filename. Change it to something that tells you what this copy is for. If the original is called "Budget 2024", you might name the copy "Budget 2024 - Backup" or "Budget 2024 - Draft" or "Budget 2024 - Client Version". The key is making the purpose clear so you don't open the wrong file by accident.

Some people add the date: "Budget 2024 - Jan 15" or "Budget 2024 - Final". This works especially well if you're creating multiple versions over time and need to know which one is newest. Excel shows the file's creation date in your file browser, but putting it in the name makes it obvious at a glance.

Saving a copy while keeping the original open

If you're working on a file and want to save a copy without closing it, use Save As. When you click Save As and give the file a new name, Excel switches to the new copy — the original stays saved exactly as it was. You're now editing the copy, not the original.

This is useful when you want to experiment with changes. Save As before you start, work on the copy, and if something goes wrong you still have the original unchanged. If the changes turn out well, you can delete the original and keep the copy, or keep both.

Copying a file without opening it

You don't have to open Excel to copy a file. Open your file browser (File Explorer on Windows, Finder on Mac), find the Excel file, right-click it, and select Copy. Then right-click in the same folder or a different folder and select Paste. Windows and Mac will create a copy with "(2)" or "copy" added to the name.

This method is faster if you just want a quick backup and don't need to open the file. It's also the way to copy a file to an external drive or email it to someone — you're working with the file itself, not opening it in a program.

Using cloud storage to keep copies automatically

If you save your Excel files to OneDrive, Google Drive, or Dropbox instead of just your computer, these services keep a history of older versions automatically. You don't have to manually save copies — the cloud storage does it for you. If you need to go back to how the file looked yesterday or last week, you can recover that version without having created a separate copy yourself.

To set this up, save your file to your cloud storage folder instead of your Documents folder. On Windows, OneDrive creates a folder on your computer that syncs to the cloud. On Mac, iCloud Drive works the same way. Google Drive and Dropbox have their own folders. Once your file is there, every time you save it, the cloud service keeps a backup of the previous version.

What to do if you accidentally saved over the original

If you opened a file, made changes, and saved it without using Save As first, you've overwritten the original. If the file is in cloud storage, you can recover an older version. Right-click the file in OneDrive or Google Drive and look for Version History or See all versions. Click the version you want and select Restore.

If the file is only on your computer and not in cloud storage, recovery is harder. Some recovery software can find deleted or overwritten files, but it's not may provide. This is why saving a copy before you make big changes is worth the 30 seconds — it prevents this problem entirely.

Frequently Asked Questions

Can I save a copy as a different file type, like PDF or CSV?

Yes. In Save As, look for the dropdown that says "Excel Workbook" or ".xlsx". Click it and choose the format you want — PDF, CSV, or others. Keep in mind that some formats lose Excel features like formulas or multiple sheets, so the copy may not look or work exactly like the original.

What's the difference between Save and Save As?

Save updates the file you're currently working on without changing its name or location. Save As creates a new file with a name or location you choose. If you want to keep the original, always use Save As before making changes.

If I save a copy to a USB drive, will it stay there if I unplug it?

Yes. Once you save the file to the USB drive, it stays there even after you unplug it. The file is now in two places: the original on your computer and the copy on the drive. If you edit the copy on the drive, the original on your computer doesn't change.

Can I save a copy to email it to someone?

Yes, but it's easier to use your email program's attachment feature. Save the copy to your computer first, then open your email, click Attach, and select the file. Or, if the file is in cloud storage, you can share a link instead of sending a copy.