To edit an XLSX workbook in Excel for the web, store it on OneDrive and open it in your browser. When you need a fixed copy for review, Adobe Acrobat’s Excel to PDF converts XLS and XLSX files online, keeps tables, rows, and columns, and deletes files unless you sign in to save.
This article is for professionals who want online services that convert spreadsheet files into a format that keeps their integrity and supports further editing.
Excel for the Web: Upload a Workbook and Edit in the Browser
Upload the workbook to OneDrive, then open it in Excel for the web to edit it in your browser. Microsoft says you can create, view, and edit workbooks stored on OneDrive or Dropbox, and that you can share them by email address or link. Live co-authoring works only when everyone uses Excel for the web, according to Microsoft, and it needs XLSX, XLSM, or XLSB files. Keep the original on your device, because a browser edit changes the stored file. Set the page layout first if you plan to export a PDF.
- Formats: Microsoft says Excel for the web opens XLSX, XLSB, XLSM, CSV, and ODS files, and CSV files are converted to XLSX.
- Older files: an older Microsoft page says you can view an XLS file in the browser but cannot edit it there, so save a copy as XLSX first.
- Size: Microsoft’s service description says workbooks over 100 MB cannot be viewed in Excel for the web from SharePoint Online.
- Comments: Microsoft says threaded comments let people mention colleagues, and people with write access can resolve and reopen threads.
- History: Microsoft’s SharePoint help says versioning shows when and by whom a file was changed and lets you restore a previous version.
- Sharing settings: Microsoft’s OneDrive help describes Block download, an expiration date, and a password on Anyone links.
- PDF export: a guide says the download as PDF route uses the workbook’s available sheet and print settings, and that chart layout and margins may differ from desktop Excel.
Excel for Web Unsupported Features: What Happens to Your Workbook
Some workbook features cannot be created or edited in Excel for the web, and a few stop the file from opening there at all. Microsoft says unsupported features prevent a workbook from being opened for editing or, in some cases, viewing, and that Excel for the web can make a copy with those features removed so the copy can be edited. Features it names include VBA projects and XML maps. Check the list below, and keep your original workbook untouched. Each limit comes from Microsoft’s own help pages.
- Macros: Microsoft says an XLSM workbook opens but its macros do not run in the browser.
- Legacy macros: Microsoft says workbooks with legacy macro features, such as Excel 4.0 macro functions, cannot be displayed in a browser window.
- Slicers: Microsoft’s service description says you can view and delete existing slicers, but cannot create or edit them.
- Power Pivot: Microsoft says advanced analysis views such as Power Pivot are available only in the desktop app.
- External data: Microsoft says you can view data connections and external references but not create them, and that a query table may show only the data last saved in the desktop app, not live data.
- What if analysis: Microsoft says you can view results, but Goal Seek, Data Tables, Solver, and Series need the desktop app.
- Charts: Microsoft says only the desktop app supports advanced chart features.
- Safe route: if the browser offers an editable copy, check the copy for missing features before you replace the original.
ONLYOFFICE Online Editor: XLSX Compatibility Compared
Online services that keep an XLSX workbook intact and editable include Excel for the web, Google Sheets, ONLYOFFICE, and Zoho Sheet, and Adobe Acrobat’s Excel to PDF covers the fixed copy. ONLYOFFICE says its spreadsheet editor fully supports XLSX and XLS, with 400+ formulas, pivot tables, data validation, and conditional formatting, which is the vendor’s own claim. Excel for the web keeps XLSX, while Google converts an uploaded file to its own format. Test one real workbook in each before you commit.
| Platform | Best For | Key Details |
|---|---|---|
| Excel for the web | Keeping XLSX as the working format | Opens XLSX, XLSB, XLSM, CSV, and ODS; macros do not run; slicers cannot be created or edited; Power Pivot is desktop only |
| Google Sheets | Roles and share controls | A guide says an uploaded workbook opens in Sheets, which converts it, so compare formulas and formatting afterward |
| ONLYOFFICE | XLSX collaboration on your own server | Says it fully supports XLSX and XLS; its ownCloud connector lists XLSX, XLSB, and XLSM as editable and ODS as view only or converted; free Community Edition allows up to 20 simultaneous connections |
| Zoho Sheet | Printing and external sharing | Says it opens .xls, .xlsx, and .csv; its help lists print area, paper size, orientation, scaling, and margins |
| Adobe Acrobat (Excel to PDF) | A fixed copy for review | Keeps tables, rows, and columns; deletes files unless you sign in to save; signed in users can share the PDF for comments |
- Compatibility check: ONLYOFFICE’s converter handles XLSX, CSV, ODS, and PDF among 50+ formats, with a 5 MB limit unless you sign up.
- Co-editing limits: ONLYOFFICE’s connector pages say users on different Document Servers cannot co-edit in real time.
- Integrity: Microsoft says XLSX preserves worksheet data and formatting, while text formats such as CSV remove all formatting.
- Format loss: Microsoft says ODS might lose formatting, so keep XLSX as the master when Excel users depend on it.
- PivotTables: Microsoft says people can view worksheets, sort, filter, and drill into PivotTables in Excel for the web, and ONLYOFFICE lists pivot tables among its supported features.
Frequently Asked Questions
Q: Can I keep my macros if I edit the workbook in the browser?
A: You can keep the file, but the macros will not run there. Microsoft says an XLSM workbook can be opened in the browser, while its macros do not run, and that features such as VBA projects can prevent a workbook from opening for editing. Keep the macro workbook on your device, edit it in desktop Excel, and share a macro free XLSX copy for browser work.
Q: Is the editable copy that removes unsupported features safe to use?
A: Use it as a working copy, not as your master. Microsoft says Excel for the web removes unsupported features from the copy so it can be edited, which means functions such as a slicer or a data connection may be missing. Compare totals and layout against the original, and keep the original file as the version of record.
Q: How large can the workbook be?
A: Microsoft says workbooks over 100 MB cannot be viewed in Excel for the web from within SharePoint Online. Other tools set their own limits, such as ONLYOFFICE’s converter at 5 MB unless you sign up. If a file is close to a limit, remove unused sheets and images from a copy, and test that the copy still opens.
Q: Should I convert the workbook to ODS or CSV to keep it editable?
A: Usually not. Microsoft says XLSX preserves worksheet data and formatting, ODS might lose formatting, and text formats such as CSV remove all formatting and keep only values from the active sheet. Keep XLSX as the editable master, and use CSV only when another system needs plain data. LibreOffice Calc also reads and writes XLSX for people who do not use Excel.
To edit an XLSX workbook in Excel for the web, keep it on OneDrive, check for unsupported features first, and export a PDF when readers only need to review.

