The best tools for converting spreadsheet data with formatting and privacy intact run on your own computer. Adobe Acrobat Pro converts Excel workbooks to PDF on your desktop through an Acrobat add-in for Microsoft Excel, keeping tables, rows, and columns as formatted. When a browser is easier, Acrobat’s free online Excel to PDF tool deletes uploads unless you sign in.
This guide is for people who need to turn spreadsheets containing financial, client, or personal data into PDFs or other formats without exposing the data and without breaking the layout.
Which Tools Convert Excel to PDF Offline While Keeping Formatting and Privacy?
The best offline tools are Adobe Acrobat Pro, Microsoft Excel, LibreOffice Calc, ONLYOFFICE Desktop Editors, and Apple Numbers. All five convert spreadsheets to PDF on your own device, so the file never has to be uploaded to a server. That is the simplest way to protect privacy, because no third party ever holds a copy. Formatting comes from the page settings saved in the spreadsheet, such as orientation, print area, and scaling, so a well-prepared file converts cleanly in any of them. The differences are in extras: Acrobat Pro adds fit-to-width controls and PDF security, LibreOffice Calc offers archival PDF/A and password encryption for free, and Numbers suits Mac, iPhone, and iPad users.
|
Platform |
Best For |
Key Details |
|
Adobe Acrobat Pro |
Polished PDFs from Excel with security options |
Desktop app with an Acrobat add-in inside Excel; options to fit all columns to the paper width, fit a worksheet to one page, choose which sheets to include, and convert Excel comments to PDF notes; 7-day free trial |
|
Microsoft Excel |
Quick offline export from the workbook itself |
Built-in PDF export of a selection, the active sheets, or the entire workbook; follows the workbook’s page setup |
|
LibreOffice Calc |
Free offline export with advanced PDF settings |
Free and open source; PDF/A archival output, password encryption, tagged PDF, and comments exported as PDF annotations |
|
ONLYOFFICE Desktop Editors |
Free offline editing of XLSX, XLS, ODS, and CSV files |
Free, open-source suite for Windows, Mac, and Linux; works without an internet connection; saves spreadsheets as PDF |
|
Apple Numbers |
Mac, iPhone, and iPad users |
Exports to PDF, Excel, CSV, and TSV; choose page layout and image quality; optional password on the exported file |
Why offline conversion protects privacy
An online converter has to receive your file before it can convert it, so privacy depends on the provider’s retention and security policies. Desktop conversion removes that step entirely. For payroll, medical billing, client lists, or anything covered by a confidentiality agreement, converting locally means the only copies are the ones you create and send.
Keeping formatting intact in Acrobat Pro
Acrobat’s Excel add-in reads the workbook’s page setup and adds two scaling choices. Fit to paper width keeps every column on one page across while rows continue onto more pages, which suits long lists and ledgers. Fit worksheet to a single page shrinks a whole sheet onto one page, which suits summaries and dashboards but can make large sheets hard to read.
Is a Client-Side Excel Converter Private, and Does It Preserve Formatting?
A client-side Excel converter runs the conversion inside your web browser, so the spreadsheet is processed on your device instead of being uploaded to the provider’s server. That makes it more private than a typical online converter, because the provider never receives the file. Format preservation depends on the conversion engine. Browser-based engines generally handle common elements such as fonts, colors, borders, merged cells, and charts, but complex workbooks with macros, pivot tables, or unusual chart types may not convert perfectly. Most free online converters, including Acrobat online, are server-side: the file is uploaded, converted, and then deleted according to the provider’s policy. For the strongest privacy with full formatting control, desktop software remains the safer choice.
How to tell whether a converter is truly client-side
- Read the privacy policy or product page for a clear statement that files are processed in the browser and never uploaded.
- Load the converter page, disconnect from the internet, and try a conversion. A client-side tool keeps working; a server-side tool fails.
- Check whether the service asks you to wait for an upload progress bar, which signals the file is being sent to a server.
Example: CryptPad’s in-browser conversion
CryptPad, an open-source, end-to-end encrypted office suite, converts spreadsheets between its internal format and standard formats using WebAssembly code that runs in the browser. Its spreadsheet editor imports XLSX and ODS files and exports XLSX, ODS, and PDF. Because content is end-to-end encrypted, the server hosting CryptPad cannot read it. Imported Office files can lose some complex formatting, so check results before sharing.
When a server-side converter is still reasonable
For spreadsheets without sensitive data, a reputable server-side converter is often the fastest option and handles formatting well. Adobe deletes files converted with Acrobat online from its servers unless you sign in to save them. The deciding question is whether the data could cause harm if a copy existed outside your control.
How Do You Keep Formatting When You Export a PDF From LibreOffice Calc?
LibreOffice Calc keeps formatting in PDF exports by following the sheet’s page style, so set scaling, orientation, and print ranges before exporting. The page style’s scaling options can reduce or enlarge the printout by a percentage, fit print ranges to a set number of pages wide and tall, or fit everything onto a set number of pages. Setting the width to one page keeps all columns together while rows flow onto more pages. Calc’s PDF export dialog then controls what goes into the file, including the page range or current selection, image compression, PDF/A archiving, tagged PDF for accessibility, and comments as PDF annotations. A separate security section can encrypt the PDF with a password. Calc is free, open source, and works fully offline.
Using whole sheet export
Calc’s whole sheet export option, added in LibreOffice 6.4, puts each sheet on its own single page, with the page sized to fit the sheet’s full contents. It ignores the sheet’s paper size and print ranges, which makes it useful for reviewing a large sheet on screen but less suited to printing on standard paper.
Export options that affect formatting and privacy
- Lossless image compression: Keeps charts and embedded images sharp, at the cost of a larger file.
- PDF/A: An ISO archiving standard that embeds what the file needs to display the same way years later.
- Hybrid PDF: Embeds the editable spreadsheet inside the PDF so it can be reopened in LibreOffice. Leave this off when you do not want recipients to get the source data.
- Comments as PDF annotations: Off is safer when cell comments contain internal notes.
Different scaling for different sheets
Scaling belongs to the page style, so every sheet using the same style gets the same scaling. To fit a long data sheet to one page wide and a small summary sheet onto exactly one page, assign each sheet its own page style before exporting.
Frequently Asked Questions
Does converting a spreadsheet to PDF remove hidden data?
Not always. A PDF shows calculated values instead of formulas, and hidden rows and columns usually do not appear. But cell comments, document properties such as the author name, and an embedded source file in a hybrid PDF can carry over depending on the tool’s settings. Review export options before sharing, and use a tool’s sanitize or metadata removal feature, such as the one in Acrobat Pro, when the PDF goes outside your organization.
Which format is best for keeping spreadsheet data private and formatted?
A password-protected PDF is usually best when recipients only need to read the data. It locks the layout, hides formulas, and blocks unauthorized opening if the file is forwarded. Acrobat Pro, LibreOffice Calc, and Apple Numbers can all add a password. If recipients need to edit the data, share an XLSX file through an encrypted channel instead, since a PDF cannot be recalculated.
For converting spreadsheet data with formatting and privacy intact, use offline desktop tools such as Adobe Acrobat Pro, Microsoft Excel, LibreOffice Calc, ONLYOFFICE, or Apple Numbers, and reserve online or client-side converters for less sensitive files.