PRACTICAL GUIDES FOR WORK, STUDY & EVERYDAY LIFE

About   /   Contact

Home  /  Guides

How to Clean a Spreadsheet Before Sharing It

A spreadsheet can look perfectly tidy on screen and still contain the wrong dates, duplicate records, private information or an old tab you forgot about. Before sending one to a colleague, tutor or client, spend a little time checking what the recipient will actually receive. A clean sheet is easier to understand, less likely to cause mistakes and safer to share.

This guide gives you a practical checking routine for Excel and Google Sheets. You do not need advanced formulas or specialist software. Work through the steps in order, make a separate sharing copy and use the final checklist before you press Send. The examples use an imaginary list of workshop bookings, so you can follow them without handling anybody’s real details.

Decide what the recipient actually needs

Start with purpose, not formatting. Ask what the other person needs to do with the file: check a total, update a schedule, analyse results or read a report. That answer tells you which columns and tabs should remain. A colleague checking monthly spending probably needs category, date and amount. They may not need internal notes, staff names or a separate worksheet containing raw exports.

Write the intended use in one sentence before editing. For example: “This file lets the event organiser count bookings by session.” Then compare every field against that sentence. If you cannot explain why a column is necessary, leave it out of the sharing copy until you have checked. Removing unnecessary information is usually more effective than hoping people will ignore it.

Preserve the original before cleaning

Never start by deleting rows from the only copy. Save a duplicate in a clearly named folder such as “To share”, and keep the source file unchanged. A filename like “workshop-bookings-share-2026-11.xlsx” is more useful than “Final FINAL 3”. Include a date or version only when it helps someone distinguish one file from another.

A separate copy also makes your decisions reversible. If you are working with shared folders, our guide to cloud storage explains the basics. If a formula stops working or a colleague asks where a record went, you can inspect the original without reconstructing the data. For a sensible folder structure, see our guide to organising laptop files.

Audit every tab, including hidden sheets

Check the workbook from left to right. Read each tab name, note its purpose and identify old imports, scratch calculations, archived lists or notes. Look for hidden rows and columns as well as hidden worksheets. You should not treat a hidden tab as a secure place to store material the recipient must not see.

Google explains that hidden sheets may be accessed by people with a copy of the spreadsheet, and editors can unhide them. See its official guidance on hiding and protecting sheets. If a tab is not suitable for sharing, remove it from the separate copy and check any formulas that depended on it.

Remove personal information that is not needed

A booking export might contain names, email addresses, telephone numbers, dietary details and comments. Perhaps the recipient only needs a total number of places booked per session. Create that summary instead of distributing the full list. If you must share personal data, follow your organisation’s approved process and use an appropriate access-controlled method.

The Information Commissioner’s Office describes data minimisation as keeping personal data adequate, relevant and limited to what is necessary for its purpose. Its data minimisation guidance is a useful starting point. The precise obligations depend on your circumstances; this article is a general organisation guide, not legal advice.

Give columns clear, stable headings

Use one header row and choose labels that mean something to somebody who did not build the file. “Session date” is clearer than “D”, and “Amount paid (£)” is clearer than “Value”. Avoid mixing a title, notes and data rows in the same table if the file will be sorted or analysed. Put explanatory notes above or on a separate readme tab where they will not be mistaken for records.

Keep each column to one type of information. Do not combine a postcode, a customer name and an amount in one cell just because it looks compact. Avoid merged cells inside the data table; they often make filtering, exporting and copying more difficult. If codes need leading zeroes, store or format them in a way that preserves those zeroes before sharing.

Check dates, numbers and currencies

Date mistakes are remarkably easy to miss when a file travels between systems. A value such as 03/04/2026 can be understood differently by readers using different regional conventions. Consider an unambiguous displayed format, such as 3 April 2026, or a consistently agreed ISO-style date. Verify that the cells contain actual dates where calculations are needed, rather than a mixture of text and dates.

Do the same for amounts. Check whether a column holds pounds, percentages, hours or simple counts. Make decimal places consistent without assuming that display rounding changes the underlying number. In the sample booking sheet, “12.50” and “£12.50” may look similar, but the second might have been entered as text. Test calculations rather than relying on appearance.

Standardise names and labels carefully

Small inconsistencies can split what should be one category into several. “Online”, “online ” and “ONLINE” may be treated differently by some reports or tools. Decide on a sensible spelling for each approved category, then review all variations before you change them. A short list of accepted values can help prevent the problem returning.

Be especially careful with names and identifiers. Two people can share a name, and similar-looking codes may represent different records. Do not automatically merge them. Cleaning is not the same as guessing: when a value is ambiguous, mark it for the original data owner to check. Google Sheets provides cleanup suggestions and column statistics that can help you spot patterns, but you still need to judge the proposed changes.

Investigate duplicates instead of deleting blindly

A duplicate row is not always an error. Two identical-looking workshop bookings might be separate purchases, or the same person may legitimately attend two sessions. Define what makes a record unique: an order ID, a transaction reference or a combination of fields. Only remove a repeated row when you can show that it represents the same event twice.

In Google Sheets, Data → Data cleanup → Remove duplicates lets you choose columns and indicate whether there is a header row. Google’s official instructions explain the process. For a safer first pass, copy the relevant range to a temporary tab and record how many rows were flagged. Compare the totals before and after.

Review blanks, errors and unusual values

Blank cells mean different things in different contexts. A missing phone number may be acceptable; a missing amount in a payment report may not be. Establish which fields are required, which are optional and which need a placeholder such as “Not provided”. Do not use zero to mean missing if zero is a genuine possible value.

Scan for formula errors, impossible dates, negative counts and unexpectedly large amounts. A booking total of 8,000 where most sessions contain 8–30 people deserves a second look, but it is not automatically wrong. Compare suspicious figures with a reliable source. Highlight unresolved issues in a short note rather than silently editing them to make the spreadsheet look neat.

Check formulas, filters and calculated totals

A well-formatted spreadsheet can still be misleading if someone copied formulas into the wrong rows. Check the first, middle and last formula in each calculated column. Verify that ranges cover every intended record and that additions or removals did not shift the references. Recalculate a small sample by hand or with an independent calculation.

Temporarily clear filters and inspect the whole range. A hidden filter can make a file appear to have fewer records than it contains. If you plan to provide a static report rather than an editable model, consider whether to paste calculated results as values in the sharing copy. Keep formulas where recipients actually need to inspect or adapt them. Our beginner’s guide to Google Sheets formulas explains common formula patterns.

Inspect comments, links and hidden document details

Before distributing an Excel workbook, check notes, comments, named ranges, external connections and document properties. A comment can reveal an internal discussion; an external link might depend on a file the recipient cannot access. Microsoft provides a Document Inspector that can detect several categories of hidden data. It recommends working on a copy because some removals cannot easily be undone.

Use File → Info → Check for Issues → Inspect Document in supported desktop Excel versions, then review each finding before choosing any removal action. Microsoft’s Document Inspector instructions explain what the tool can and cannot detect. Do not assume running it once guarantees that every embedded or linked item is safe.

Test the file as somebody else would

Now stop looking at the workbook like its creator. Open the sharing copy afresh, read the first screen and ask whether its purpose is obvious. Can the recipient identify the newest data, the units, the date range and the intended next action? Are the important columns visible on a typical laptop? Is the heading row still easy to find after scrolling?

Try sorting and filtering a copy of the table. Check that all associated columns move together. Open it using the programme the recipient will use if you can. If formulas, charts or fonts change during a format conversion, note the difference and choose a more reliable delivery format. Your aim is not visual perfection; it is a file that communicates the right information without surprises.

Choose the right sharing format and access level

An editable workbook suits collaboration. A CSV may suit a data import, but it typically does not carry workbook formatting, multiple sheets or the same features as an Excel file. A PDF may be better when someone only needs to read or print a summary. Export a small test file if you are unsure, then reopen it to see what survived the conversion.

For cloud sharing, grant the least access the recipient needs: Viewer for reading, Commenter for feedback or Editor for changes. Review the recipient list, inherited folder permissions and general-access setting before sending a link. Google’s Drive sharing guidance describes these roles. Remember that restricting editing is not the same as removing sensitive data from the file.

A worked example: a workshop booking sheet

Imagine a fictional sheet with 120 rows, a hidden “Old export” tab and columns for booking reference, session date, participant name, email address, session type and fee. The organiser asks only for a count of places by session. Start with a duplicate of the workbook. Verify booking references, check whether repeated rows are genuine, and correct dates only against the source.

Create a new summary containing the session date, session type and verified count. Exclude names and email addresses because they are not needed for that purpose. Add a short note explaining the date range and the meaning of the figures. Reopen the summary, confirm the totals against the cleaned source and share the summary with Viewer access. This is an illustrative workflow, not a claim about a real dataset.

Your five-minute pre-send checklist

Use this final pass even when you have cleaned the file before. First, confirm you are sending the sharing copy, not the raw source. Second, read every visible and hidden tab name. Third, search for personal details and private comments that should not travel. Fourth, spot-check calculations, blank fields, duplicates and date formats. Fifth, reopen the exported file or shared link using the intended recipient’s perspective.

Do not rush the access settings. Check the exact email addresses and the role you are granting. If the spreadsheet is business-critical or contains sensitive information, use the organisation’s formal review and data-sharing procedure, not only this checklist. Save a note of what you changed and where the verified original lives; it will help when someone asks about the figures later.

Frequently asked questions

Should I remove every duplicate in a spreadsheet?

No. A repeated value is not necessarily an incorrect record. Define the unique identifier for your dataset and investigate repeated rows before deleting anything. Keep a record of confirmed removals.

Can people see a hidden worksheet?

Hiding a sheet is a convenience feature, not a confidentiality guarantee. Remove information that recipients should not receive from the sharing copy, rather than merely hiding its tab.

Is CSV safer than an Excel workbook?

CSV is simpler and often contains fewer workbook features, but it can still include sensitive rows or columns. Review the exported values, file encoding and intended import process. Do not assume a format change makes data safe.

Should I share a view-only link or send an attachment?

Use whichever method fits your organisation’s process and the recipient’s needs. A controlled view-only link can make access easier to manage, but you must still check permissions and the content itself.

What if I find an uncertain value just before sending?

Do not quietly invent a correction. Check the original source or ask the person responsible for the data. If the answer cannot be confirmed in time, clearly flag the uncertainty or delay sharing the affected figures.

The useful habit to keep

Cleaning a spreadsheet is less about finding a magic button and more about knowing what the file is for. Keep a trustworthy original, remove information that does not belong in the shared version, check the figures and view the final result through the recipient’s eyes. That routine is useful whether you are sharing five rows with a friend or a monthly report at work.

Sources and further reading

Google Sheets: remove duplicate rows and trim whitespace; Google Sheets: protect and hide sheets; Microsoft: inspect hidden workbook data; ICO: data minimisation; Google Drive: sharing permissions.

Keep learning

One useful skill leads to another. Choose your next guide from the collection.

Browse all practical guides →