Percentage Sheet in Google Sheets: Formulas and Setup

Yes—Google Sheets can create a percentage sheet, and it can open or export an Excel .xlsx workbook. Enter the percentage as a decimal or a value with a percent sign, calculate it with a formula such as =B2/C2, then select the result cells and choose Format > Number > Percent.

What “percentage sheet.xlsx” might mean

The phrase could mean a spreadsheet template for working with percentages, or an existing Excel file named something like Percentage sheet.xlsx that someone wants to use in Google Sheets. A filename alone does not identify a particular official template or guarantee that a file is available. You can build the calculations in a new Google Sheet, or import an existing .xlsx file and work with it there.

A useful percentage sheet usually records the values being compared, calculates a percentage or change, and displays the result in a readable format. For example, a small sales table might show the amount sold, the target, and the share of the target achieved. Keeping the original numbers visible makes it easier to check the result than storing only a percentage.

How percentages work in Google Sheets

A percentage is a way of displaying a ratio whose underlying value is a decimal. The value 0.15 is equivalent to 15%, and 1 is equivalent to 100%. When you apply percent formatting, Sheets displays the decimal multiplied by 100 and adds a percent sign; it does not change the underlying ratio.

This distinction prevents a common mistake. If a cell contains 15 and you format it as a percentage, Sheets displays 1,500%, because 15 represents fifteen whole units, or 1,500 hundredths. To represent fifteen percent, enter 15% or enter 0.15 and apply percentage formatting. You normally do not multiply a ratio by 100 in the formula if you plan to format the result as a percentage.

For a basic percentage, divide the part by the whole. If 18 of 60 items are complete, the ratio is 0.3, which displays as 30% when formatted as a percentage. The arithmetic and the display format are separate: the formula calculates the ratio, while the number format controls how it looks.

Set up a simple percentage sheet

In a new Google Sheet, put descriptive labels in the first row and one record on each following row. For example, use columns A, B, and C for Item, Completed, and Total, then use column D for Percent complete. Enter numbers in the completed and total columns, and put a formula in the first result row.

Open Google Sheets in a web browser and create a blank spreadsheet, or open the workbook you want to use.
Enter clear column labels, such as Item, Completed, Total, and Percent complete.
Enter the part and whole as numbers in their own columns. Do not type a percent sign into those count fields.
In the first result cell, divide the part by the whole, then fill or copy the formula down for other rows.
Select the result cells and choose Format > Number > Percent.

With an item name in A2, the completed count in B2, and the total count in C2, enter =B2/C2 in D2. If B2 is 18 and C2 is 60, the formula returns 0.3; percent formatting displays 30%. For multiple rows, copy D2 down using the small blue fill handle at the bottom-right of the selected cell, or copy and paste the formula into the remaining result cells.

Useful percentage formulas and examples

The right calculation depends on what the percentage is meant to describe. State the numerator and denominator in your column labels so that another person can understand the result. These examples assume a Google Sheets locale that uses commas between function arguments where applicable.

Part as a share of a whole: With the part in B2 and the whole in C2, use =B2/C2. If B2 is 18 and C2 is 60, the result is 0.3, displayed as 30%.
Share of a column total: With individual amounts in B2:B9 and the total in B10, use =B2/$B$10 in C2, then copy down. If B2 is 25 and B10 is 100, C2 displays 25%. The dollar signs keep the total reference fixed as the formula is copied.
Percentage of a target achieved: With actual units in B2 and the target in C2, use =B2/C2. If actual is 45 and the target is 50, the result displays as 90%.
Percentage increase or decrease: With the old value in B2 and the new value in C2, use =(C2-B2)/B2. If the value rises from 80 to 100, the calculation is 20 divided by 80, or 25%. A negative result indicates a decrease.

For a sheet where the denominator might be zero, decide how you want to handle that case instead of allowing a division error to confuse readers. With the part in B2 and the whole in C2, use =IF(C2=0,"",B2/C2) to leave the result blank when the whole is zero. Format the result column as a percentage. A blank can be preferable to showing 0%, because zero percent is a real result, while a zero denominator means the ratio is undefined.

Percentage change is not percentage points

Percentage change and percentage-point change answer different questions. Suppose a completion rate rises from 35% to 42%. The difference is 7 percentage points. Relative to the original 35% rate, however, the increase is 20%, because 7 divided by 35 equals 0.2.

With the old rate in B2 and the new rate in C2, use =C2-B2 to calculate the difference in percentage points. If B2 contains 35% and C2 contains 42%, the result is 7 percentage points (0.07 as a stored value). With those same cells, use =(C2-B2)/B2 to calculate relative percentage change; the result is 20%. Format both results as percentages if desired, but label the first one “percentage-point change” so readers do not mistake it for relative growth.

Format results for readability

Choose the result cells and use Format > Number > Percent. The toolbar also has a percentage-format button. To show more or fewer decimal places, use the increase or decrease decimal-place buttons on the toolbar after applying the percentage format. For example, a ratio of 0.12345 can display as 12%, 12.3%, or 12.35%, depending on the displayed precision; the underlying value remains the same.

Choose precision that suits the data. Whole percentages are often easier to scan in a summary, while a rate used for detailed comparison may need one or two decimal places. Avoid presenting more decimal places than the source data supports. You can also apply a consistent format to an entire result column before entering formulas, which helps new rows match the existing presentation.

Formatting changes how a value appears, not what it means. A cell displayed as 30% still contains the numeric value 0.3, so it can be used in further calculations. If you need a percentage as text for a label, that is a different task and may make later arithmetic less convenient; keep calculation cells numeric wherever possible.

Open or save an Excel .xlsx file

Google Sheets can work with Microsoft Excel files, including .xlsx workbooks. In Sheets, choose File > Import and use the upload option to select a workbook from your computer. Depending on the import choice, Sheets can create a new spreadsheet or replace or add data in a spreadsheet. Review the import options before confirming, especially if the file contains multiple sheets or existing data.

You can also upload an Excel workbook to Google Drive and open it with Google Sheets. To make a separate Google Sheets version, choose File > Save as Google Sheets. To create an Excel copy from a Google Sheet, choose File > Download > Microsoft Excel (.xlsx). The downloaded file is a copy; it does not mean that the Google Sheet and the Excel workbook will stay synchronized automatically.

Simple values, formulas, and percentage number formats are common spreadsheet features, but a conversion can affect workbook-specific formatting, formulas, charts, or other Excel features. Check important formulas and the appearance of the exported workbook after conversion. Excel uses its own menus and interface; the paths above are for Google Sheets in a web browser.

Common percentage-sheet problems

A result is 100 times too large: Check whether the formula multiplies by 100 and whether the cell is also formatted as a percentage. Usually, use the ratio alone, such as =B2/C2, and apply percent formatting.
The result shows 0%: The underlying value may be small and rounded by the display format. Increase the decimal places before deciding the calculation is wrong.
A formula shows a division error: Check that the denominator is not blank or zero. Decide whether a blank, a warning, or a defined fallback is appropriate for your sheet.
A change looks unexpectedly negative: Confirm which value is the starting value and which is the new value. Reversing them changes the sign.
Copied formulas use the wrong total: Use an absolute reference such as $B$10 when every row should divide by the same total. Relative references move as a formula is copied.
An imported workbook looks different: Check number formats and formulas in the Google Sheets version, then inspect the downloaded Excel copy if the workbook will be shared with Excel users.

Frequently Asked Questions

How do I calculate a percentage in Google Sheets?
Divide the part by the whole, such as =B2/C2 when the part is in B2 and the whole is in C2. Format the formula cell with Format > Number > Percent.

How do I make Google Sheets show 15% instead of 1500%?
Use 0.15 or enter 15% as the value. If you enter 15 and then apply percentage formatting, Sheets correctly displays 1,500% because 15 is fifteen whole units.

Can Google Sheets open a percentage sheet.xlsx file?
Yes. Use File > Import to upload the Excel workbook, or open an uploaded workbook with Google Sheets. Check formulas and formatting after conversion if the workbook matters.

How do I calculate percentage increase in Sheets?
Subtract the old value from the new value and divide by the old value. With the old value in B2 and the new value in C2, use =(C2-B2)/B2, then format the result as a percentage.

Can I download my Google Sheet as an Excel file?
Yes. In the browser version of Google Sheets, choose File > Download > Microsoft Excel (.xlsx). The downloaded workbook is an export, so review it if you rely on features specific to either spreadsheet program.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.