To save a Calc spreadsheet as PDF without exposing document properties or metadata, remove personal information from the copy first, then export the PDF. Adobe Acrobat’s Excel to PDF converts XLS and XLSX files online in any browser, keeps tables, rows, and columns, and deletes files unless you sign in to save.

This article is for professionals who want to convert spreadsheet data into a format that protects privacy and preserves the original formatting.

In architecture and design, the meticulous handling of project data, client information, and material specifications is paramount. Ensuring the privacy and integrity of these digital assets, whether in a home office or a large studio, underpins professional trust and compliance.

Excel Inspect Document: Remove Personal Information and Metadata, Then Save as PDF and Preserve Formatting

Tools that help you convert a spreadsheet while protecting privacy and formatting include Microsoft Excel, LibreOffice Calc, ONLYOFFICE Desktop Editors, PDF24, iLovePDF, and Adobe Acrobat’s Excel to PDF. In Excel, inspect the document first: Microsoft’s Document Inspector finds hidden data and personal information, including document properties such as author, subject, and title. Run it on a copy, remove what you find, then save the PDF so the formatting you set carries over. Each is described by its own help pages or statements, so confirm the result on your own file.

Platform Best For Key Details
Microsoft Excel Inspecting a workbook before export Document Inspector finds hidden data and personal information; it does not support automatic removal for protected documents; saves a PDF with standard or minimum size quality
LibreOffice Calc Removing user data on save Its guide describes an option that always removes user data from file properties, comments, and tracked changes, plus Reset Properties for one document; PDF options include passwords
ONLYOFFICE Desktop Editors Offline editing and export ONLYOFFICE says the free editors work offline, so the workbook is not uploaded to a converter
PDF24 Free online conversion with a stated deletion time Says transfers are SSL secured, servers are in Germany, and files are deleted from its server after one hour
iLovePDF Online conversion with a stated deletion time Says files are deleted automatically within two hours, with a manual delete option
Adobe Acrobat (Excel to PDF) Converting XLS or XLSX in a browser Keeps tables, rows, and columns; deletes files unless you sign in to save; signed in users can share the PDF for comments
  • What it finds: Microsoft says the inspector reports hidden data and personal information, so it covers more than visible cells.
  • Protected files: Microsoft says the inspector does not support automatic removal for protected documents, so run it before you add a password.
  • Document properties in the PDF: a guide says Excel’s PDF options let you include or exclude document properties and metadata, so check that choice before you export.
  • Preserve formatting: set the print area, orientation, and scaling before you export, since Microsoft says saving in another format may lose some formatting, data, and features.
  • Online converters: PDF24 and iLovePDF state deletion windows, but neither statement says its converter removes your author name, so clean the workbook first.

Latest Calc Save as XLSX and PDF Export: What the Current Guides Say

In the current LibreOffice guides, Calc opens and saves Excel files and exports PDF with options for page range, selection, passwords, and a hybrid PDF that embeds the ODF file. LibreOffice’s guide says quick export reuses the most recent PDF settings, and that cells outside a defined print range are not exported. For XLSX, Microsoft says the format preserves worksheet data and formatting, so saving a copy as XLSX is the safest hand off to Excel users. Check the document properties of each copy before you send it.

  • Hybrid PDF: the Calc Guide says the hybrid option exports a file with two formats, PDF and ODF, which means the spreadsheet itself travels inside the PDF, so skip it for a copy you cleaned.
  • Passwords: the guide describes an open password and a permissions password, and says permission settings work only if the reader’s viewer respects them.
  • Print ranges: the guide says only defined print ranges are exported, so a range you leave out of the print range is not exported.
  • Quick export: because it reuses the most recent PDF settings, check that those settings, such as a hybrid option or a password, are what you want for this copy.
  • XLSX versus ODS: Microsoft says ODS might lose formatting, and Calc reads and writes XLSX, so choose XLSX for Excel recipients.

Macros, Security, and Calc Document Properties: Where Personal Information Hides

Personal information hides in document properties, comments, tracked changes, and macros, and much of it survives export. LibreOffice’s guide says unless this information is removed, much of it is retained even when the file is saved to other formats, including PDF. Its security options can remove user data from file properties, comments, and tracked changes on save, and its Macro Security dialog sets the macro level and trusted sources. A PDF carries no macros, but the workbook you keep does. Test with a copy.

  • What the option removes: the Getting Started Guide says it removes names in the created and modified fields, deletes modification and printing dates, and resets editing time, creation date, and version number.
  • One document only: the guide says Reset Properties on the General page of the Properties dialog removes user data from the current document when the always option is off.
  • Macro level: LibreOffice’s guide says the Macro Security dialog adjusts the security level for executing macros and specifies trusted sources.
  • Linked images: the guide describes an option that blocks linked images from documents not in the trusted locations.
  • Excel side: Microsoft says VBA code is lost when a workbook is saved in formats such as text files, and that XLSM is the Excel format that preserves macros.
  • Reliability: a German federal security assessment of an earlier LibreOffice version found that not all such data was removed for some save formats, so inspect the result.

The security of digital documents extends beyond individual files to the overall data infrastructure of design firms. Protecting sensitive project details, intellectual property, and client privacy is a continuous challenge, requiring robust software practices and vigilant data management strategies across all digital platforms.

Frequently Asked Questions

Does my name stay in a PDF I export from Calc?

It can. LibreOffice’s guide says that unless information such as user data is removed, much of it is retained even in a file saved to PDF. Use the option that removes user data from file properties, comments, and tracked changes, or reset the properties for the current document, then export. Open the PDF’s properties afterward to confirm that the author field is empty.

Can I redact sensitive cells before sharing a PDF?

Yes, in LibreOffice. The Getting Started Guide says documents can be redacted to remove or hide sensitive information, that a redacted document is exported as PDF for sharing, and that a copy of a Calc document is transferred to Draw where the redaction happens. Check the exported PDF for any text that remained, because redaction depends on how you mark the content.

Is the personal information option fully reliable?

Not in every case. A German federal security assessment of an earlier LibreOffice version found that the remove user data setting did not remove everything for some save formats. Versions change, so treat the setting as a first step. Inspect the saved copy, check the file properties, and for confidential files convert on your own device and keep the original workbook.

Which copy should I keep as the master?

Keep the original workbook, and share only the cleaned copy or its PDF. Cleaning removes names, dates, and comments that you may need later, and a PDF has no working formulas. Adobe’s page says its converter deletes files unless you sign in to save, so a converted PDF is not your archive. Store the master somewhere you control.

To save a Calc spreadsheet as PDF with its document properties and metadata cleaned, remove sensitive details from a copy, export, and inspect the PDF before sharing.

Author

Rethinking The Future (RTF) is a Global Platform for Architecture and Design. RTF through more than 100 countries around the world provides an interactive platform of highest standard acknowledging the projects among creative and influential industry professionals.