File Format & Compatibility

How to Fix Excel Replacing Spaces with %20 in Filenames

Natalie Taylor Oct 16, 2026 869 views

Question details

Users experience a bug where Excel automatically replaces spaces in document names with the URL-encoded string '%20' when saving files, particularly to Dropbox folders or local drives.

How to Fix Excel Replacing Spaces with %20 in Filenames

Product: Microsoft Excel, Dropbox
Device & OS: Android, Windows
Scenario: Saving Excel workbooks that contain spaces in the filename to cloud-connected directories or local storage.
Observed behavior: Excel improperly treats the local or synced file path as a web address, URL-encoding standard spaces into the '%20' character sequence during the save process.

Before you start

Verify that your Excel application and Dropbox client are updated to their latest versions, and check whether the problem occurs universally or only when saving into specific folders.

Solution 1Recommended

Remove Special Characters from the Filename

Eliminating specific symbols, such as the number sign (#), from your file or folder names can stop Excel from mistakenly treating the save path as a URL.

URL encoding triggers are often highly sensitive to reserved web characters. Removing symbols from your file path is the quickest workaround to restore normal saving behavior across connected cloud apps.

Open the Save Dialog

In your Excel application, navigate to the 'File' menu and select 'Save As' to attempt renaming the problematic file.

Review the Filename

Carefully check the current filename and the destination folder's name for any special characters, particularly the '#' symbol.

Remove Target Symbols

Delete any special characters and replace them with standard letters, numbers, or hyphens.

Save the Document

Click the 'Save' button and check your file manager or Dropbox folder to confirm the standard spaces were preserved.

Remove Special Characters from the Filename

Successful Renaming: Keeping your filenames alphanumeric significantly reduces cross-platform syncing errors.

Solution 2

Test Saving to an Alternative Location

Isolating the save location helps determine if the '%20' bug is being triggered by a specific cloud integration like Dropbox.

Solution 3

Review VBA Macros for URL Handling

If you use macros to export or save files automatically, the VBA code might be passing the file path strictly as a web URL.

Free Microsoft Office alternative

Save Files Without Renaming Bugs Using WPS Office

Since this filename encoding issue originates within Microsoft Excel's file-handling mechanisms, switching to WPS Office provides a reliable, bug-free way to save and manage your spreadsheets on both local and cloud storage.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your Windows, Mac, or Android device.
2. Open Your Spreadsheet: Launch the WPS Spreadsheet application and open the file you previously struggled to save correctly in Excel.
3. Save Seamlessly: Click 'Menu', select 'Save As', and safely save your file to Dropbox or your local drive with standard spaces in the name.

Fully compatible with all standard Microsoft Excel formats (.xls, .xlsx, .csv).Handles cloud saves accurately without mistakenly URL-encoding file names into '%20'.Lightweight, completely free to use, and features a highly familiar user interface for a seamless transition.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel replace normal spaces in my filenames with '%20'?

The string '%20' is the standard web URL encoding sequence for a space character. This error occurs when a cloud-connected app (like Dropbox) or an internal VBA process mistakenly interprets your local file path as an internet URL during the save action.

Can symbols like '#' cause filename errors in Excel?

Yes, using special web-reserved symbols like the number sign (#) or percent sign (%) anywhere in your file or folder names can trigger unintended URL encoding mechanisms in Excel, which leads to your spaces turning into '%20'.

Does this '%20' renaming issue only happen on Excel for Android?

No, while it is most commonly reported by users on Excel for Android when saving documents directly to Dropbox, many users have also encountered the exact same bug on Windows desktop environments when saving files locally to their C drive.

Document & File Issues