Convert Google Sheets Table Back to Normal Range

If you’ve used Google Sheets’ “Convert to table” feature and now want to revert your data back to a plain range—removing the alternating colors, filter buttons, and structured references—this guide walks you through the exact steps. You’ll need edit access to the spreadsheet and the table selected; no other tools or add-ons are required.

What You’ll Need

• A Google Sheets document containing a table (created via Format > Convert to table).
• Edit permissions (Owner or Editor) for that spreadsheet.
• A desktop browser (the option is not available in the mobile app).

Step-by-Step

1. Open your spreadsheet in Google Sheets on a computer.
2. Click anywhere inside the table to activate it. You’ll see a blue border around the table and a small table icon in the top-left corner of the range.
3. Look at the top menu—a new Table menu appears between Format and Data when a table is selected.
4. Click the Table menu, then choose Convert to range from the dropdown.
5. Confirm the prompt that appears: “Convert table to a normal range?” Click Convert.
6. Verify the change: the blue border disappears, the filter buttons on the header row vanish, and any alternating row colors are removed. Your data remains intact, including values, formulas, and formatting applied to individual cells.

That’s it. The conversion is immediate and doesn’t affect any other sheets or data outside the table.

Common Mistakes

• Clicking outside the table before opening the Table menu—if the menu doesn’t appear, click directly on a cell inside the table first.
• Using the mobile app: the Table menu and Convert to range option are only available in the web version. On mobile, you can still remove filters and formatting manually, but not convert the table structure.
• Deleting the table instead of converting: pressing Delete or Backspace removes the data. Use the menu option to keep your values.
• Expecting formulas to change: structured references like [@Column] in formulas will remain as-is after conversion. They may still work, but they won’t auto-expand with new rows.

Tips

• Before converting, consider copying your sheet (Right-click the tab > Duplicate) if you might want the table features later. There’s no undo after you confirm—though you can re-create the table with Format > Convert to table.
• If you only want to remove the alternating colors but keep the filter buttons, you can change the table style instead. Click the table, go to the Table menu, and pick a plain style with no banding.
• After conversion, the header row remains as normal cells. If you want to freeze it, use View > Freeze > 1 row.
• To remove any leftover filter views, check Data > Filter views and delete any that were created for the table.

Troubleshooting

• The Table menu doesn’t appear: Make sure you’ve clicked on a cell inside the table. If the table was created on a different sheet, navigate to that sheet first. Also ensure you’re using the current version of Google Sheets in a browser—not an older cached version.
• “Convert to range” is grayed out: This happens if you don’t have edit access. Check that you’re not in “View only” mode. If you’re the owner, try refreshing the page.
• After converting, the filters are still there: The conversion removes table-specific filters. If you still see filter icons, they might be regular filters applied via Data > Create a filter. Go to Data > Remove filter to clear them.
• Formulas with structured references break: If a formula like =SUM(Table1[Amount]) stops working, replace it with a normal range reference like =SUM(A2:A100). The conversion doesn’t update these automatically.
• The table style persists: If alternating colors remain after conversion, select the range and go to Format > Alternating colors, then click Remove alternating colors.

Frequently Asked Questions

Does converting a table to a range delete my data?

No. All cell values, formulas, and manual formatting are preserved. Only the table-specific features (banding, filter buttons, structured references) are removed.

Can I undo the conversion?

Yes, immediately after converting, press Ctrl+Z (Windows) or Cmd+Z (Mac) to undo. If you’ve made other changes since, you may need to use the version history (File > Version history) to restore an earlier version.

Will my charts and pivot tables still work after conversion?

Yes. Charts and pivot tables that reference the data range will continue to function. However, if they were set to automatically expand with the table, they may not pick up new rows added later.

How do I convert multiple tables at once?

There’s no batch option. You must select each table individually and repeat the steps. Alternatively, you can remove all tables by copying the data to a new sheet, but that loses formatting.

Why can’t I find the “Convert to table” option in the first place?

That feature is being rolled out gradually to Google Workspace accounts and personal accounts. If you don’t see it, you may not have the latest update yet. Try refreshing or check back in a few days.

What’s the difference between a table and a normal range?

A table adds automatic filtering, alternating row colors, and structured references that expand as you add data. A normal range is just plain cells—no special behavior, but more flexible for custom formatting and formulas.

Related

• How to Validate a Product Idea Before Buying Inventory
• Clean iPhone Camera Lens Without Scratching It
• Set Min & Max PIN Length in Windows 10