Google Sheets template requirements

Last updated: September 25, 2026

This article lists the required columns, optional columns, named range and formatting rules for each Polar Google Sheets template. To connect a sheet, see Google Sheets.

Rules for every template

Rule	Details
Keep the structure	Don't rename sheets or remove columns (except unused dimension columns in the Custom Report template). Delete the example rows before connecting.
Dates	Format as `YYYY-MM-DD`. Add data daily rather than aggregating by month or year.
Numbers (metrics)	Use a period as the decimal separator (for example, `10.2`). Don't use commas, even as thousands separators. If a metric cell is unused, enter `0.00` instead of leaving it blank.
Text (dimensions)	Leave unused dimension cells empty. Don't leave stray spaces in cells.
Currencies	Use ISO 4217 codes (for example, `USD`, `EUR`, `GBP`).
Metric names	Each metric column name must be unique across all your connected sheets. If two sheets use the same metric name, only one is imported. Dimension names don't have this restriction.

Named ranges

Every template includes a named range that tells Polar which cells to import. To find it, open Data › Named ranges in your sheet and copy the name (by default, polar_test_range). You can rename it, but keep the cell range listed for your template below.

Marketing Spend

Use this for marketing spend from channels Polar doesn't connect to directly, such as influencers, offline media or affiliates. Spend imported this way is added to blended marketing metrics like Total Marketing Spend.

Required columns	`date`, `currency`, `store`, `channel`
Optional columns	`campaign`, `device`. Leave empty if unused.
Metric columns	`spend`, `conversion`, `conversion_value`. Enter `0.00` for conversion and conversion value if you're not tracking them.
Named range	`spend_report!A:I`

Tip: to track influencer spend, put each influencer's name in the campaign column.

Expenses

Use this for operational expenses you want included in your profit metrics. You can choose whether these expenses are deducted from Total Sales in Data Settings.

Required columns	`date`, `currency`, `store`, `expenses_type`
Optional columns	`sales_channel`, `shipping_country`, `billing_country`. Leave empty if unused.
Metric columns	Format all amount columns as numbers.
Named range	`expenses_report!A:H`

Cost of Goods

Use this to import product costs by SKU. For other ways to manage product costs, see How to View and Manage Your Cost of Products (COGs) in Polar.

Required columns	`start_date`, `end_date`, `currency`, `platform_identifier` (your Shopify URL or Amazon Merchant ID), `shipping_country`, `SKU`, `cost_type`
Cost types	One of: `cogs`, `ops_cogs`, `fulfillment`, `opex`
Formatting	Columns A–B (dates) as `YYYY-MM-DD`, columns C–G as plain text, column H (cost) as a number.
Named range	`cost_of_products_report!A:H`

Date ranges: leave start_date empty to apply a cost to all past dates, and leave end_date empty to apply it to all future dates.

Exchange Rates

Use this to override Polar's exchange rates for specific days and currencies. Polar fills in all other historical rates automatically, so only add the day and currency pairs you want to customize.

Required columns	`date`, `currency`, `value`
Formatting	`date` as `YYYY-MM-DD`, `currency` as an ISO 4217 code, `value` as a number.
Named range	`exchange_report!A:C`

Which currency goes where: put the target currency in the currency column. For example, for a USD → GBP rate, enter GBP.

Adding past rates: if you add rates for past dates, reach out through the in-app chat so we can run a full data refresh.

Custom Report

Use this for any other data, such as supplier sales, subscription data from tools Polar doesn't support, or custom targets. Unlike the other templates, you define the columns.

Date column	Required. Every row needs a date, formatted as `YYYY-MM-DD`.
Dimension columns	Plain text. To match Polar's existing dimensions, use the same names with underscores instead of spaces (for example, `Order_Id` or `Campaign_Id`). You can delete dimension columns you don't need.
Metric columns	Numbers, with `0.00` in empty cells. Enter monetary values in USD. See the note below.
Named range	Make sure it covers all your data (for example, from A1 to your last filled cell).

Currency note: Polar treats monetary values in Custom Report sheets as USD and converts them to your account currency, even if your sheet has a currency column. If your values are in another currency, convert them to USD first, or use one of the standard templates above, which handle currency conversion automatically.

Having trouble? See Troubleshooting Google Sheets.