<div class='ui dimmer modals page' style='display: none;'><div id='helpie-password-modal' class='pauple_helpie ui modal small' style='display: none;'><div class='ui header'><i class='circular lock icon'></i> Password Protected</div><div class='item-content'><br /><label for='password_check'>Enter Password : </label><p><input type='password' id='password_check' name='password_check' class='password' value='' required></p></div><div class='actions'><div class='ui black deny button'>Nope</div><div class='ui positive right labeled icon button'>Yep, that's right!<i class='checkmark icon'></i></div></div><div class='clear'></div></div></div>{"id":82677,"date":"2026-09-29T17:46:34","date_gmt":"2026-09-29T20:46:34","guid":{"rendered":"https:\/\/reportei.com\/?post_type=pauple_helpie&#038;p=82677"},"modified":"2026-10-15T11:51:58","modified_gmt":"2026-10-15T14:51:58","slug":"sheets-integration-how-to-sort-columns-or-rows-in-the-spreadsheet-on-google-sheets","status":"publish","type":"pauple_helpie","link":"https:\/\/reportei.com\/en\/central-de-ajuda\/sheets-integration-how-to-sort-columns-or-rows-in-the-spreadsheet-on-google-sheets\/","title":{"rendered":"Google Sheets integration: how to classify spreadsheet columns or rows"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">For Reportei to interpret your spreadsheet correctly, you need to <strong>classify the data type of each column or row<\/strong>, depending on the spreadsheet\u2019s layout. This ensures the data can be read, grouped, and displayed correctly in charts, tables, metrics, and filters.<\/p>\n\n\n<p class=\"wp-block-paragraph\">Before configuring the integration, check these two key aspects of your spreadsheet:<\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-1-identificar-o-formato-da-planilha\"><span id=\"helpie-sp-1\"><strong>1. Identify the spreadsheet layout<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\">First, check how your data is organized and which of the following layouts your spreadsheet uses:<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Vertical spreadsheets<\/strong>: headings are in the <strong>first row<\/strong>, with data below them.<br\/><\/li>\n\n\n<li><strong>Horizontal spreadsheets<\/strong>: headings are in the <strong>first column<\/strong>, with data alongside them in subsequent columns.<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-2-separador-decimal\"><span id=\"helpie-sp-2\"><strong>2. Check the decimal separator<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\">Check that the spreadsheet\u2019s decimal separator (a period or comma) matches the one configured for your Reportei project.<\/p>\n\n\n<p class=\"wp-block-paragraph\">If they differ, change <strong>either the spreadsheet or the project settings<\/strong> so both use the <strong>same separator<\/strong>.<\/p>\n\n\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f <em>Changing the project settings affects <strong>all reports and dashboards<\/strong> linked to that project. We therefore recommend changing the spreadsheet instead.<\/em><\/p>\n\n\n<p class=\"wp-block-paragraph\">You can then identify and classify the column types.<\/p>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-tipos-de-colunas-linhas\"><span id=\"helpie-sp-3\"><strong>Column and row types<\/strong><\/span><\/h2>\n\n\n<p class=\"wp-block-paragraph\">When connecting the spreadsheet, specify the <strong>type of each column or row<\/strong>. For a vertical layout, classify each column. For a horizontal layout, classify each row.<\/p>\n\n\n<p class=\"wp-block-paragraph\">The available types are:<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li>Metric<\/li>\n\n\n<li>Dimension<\/li>\n\n\n<li>Date<\/li>\n\n\n<li>Dimension\/Metric<\/li>\n\n\n<li>Unidentified<\/li>\n<\/ul>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-coluna-do-tipo-m-trica\"><span id=\"helpie-sp-3-1\"><strong>Metric columns<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<p class=\"wp-block-paragraph\">These columns contain numeric values, usually used in calculations.<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Example uses<\/strong>:\n<ul class=\"wp-block-list\">\n<li>summing<\/li>\n\n\n<li>averaging<\/li>\n\n\n<li>counting.<\/li>\n<\/ul>\n<\/li>\n\n\n<li><strong>Examples of Metric data<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Amount spent\u00a0<\/li>\n\n\n<li>Reach\u00a0<\/li>\n\n\n<li>Clicks<\/li>\n<\/ul>\n<\/li>\n\n\n<li><strong>Where it can be used<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Number widgets<\/li>\n\n\n<li>Chart series<\/li>\n\n\n<li>Numeric columns in tables<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-colunas-do-tipo-dimens-o\"><span id=\"helpie-sp-3-2\"><strong>Dimension columns<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\">These columns are used to <strong>group or filter data<\/strong> and usually contain text or categories.<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Example data<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Campaign name<\/li>\n\n\n<li>Channel<\/li>\n\n\n<li>Ad type<\/li>\n<\/ul>\n<\/li>\n\n\n<li><strong>Where it can be used<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Filters in number cards<\/li>\n\n\n<li>Grouping in charts<\/li>\n\n\n<li>Text columns in tables<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-colunas-com-tipo-dimens-o-m-trica\"><span id=\"helpie-sp-3-3\"><strong>Dimension\/Metric columns<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<p class=\"wp-block-paragraph\">These columns can be used <strong>as either a metric or a dimension<\/strong>: they can represent numeric values or categories.<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Example data<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Country<\/li>\n\n\n<li>Traffic source\u00a0<\/li>\n\n\n<li>Device<\/li>\n<\/ul>\n<\/li>\n\n\n<li><strong>Where it can be used<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Anywhere that accepts dimensions or metrics<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-colunas-do-tipo-data\"><span id=\"helpie-sp-3-4\"><strong>Date columns<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<p class=\"wp-block-paragraph\">These columns contain date values.<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Example data<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Subscription date\u00a0<\/li>\n\n\n<li>Campaign date\u00a0<\/li>\n\n\n<li>Month.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><strong>Where it can be used<\/strong>:<\/p>\n\n\n<ul class=\"wp-block-list\">\n<li>Date-range filters (reports, dashboards, and widgets)<\/li>\n\n\n<li>Time-based grouping in charts<\/li>\n\n\n<li>Display in table columns<\/li>\n<\/ul>\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n<h3 class=\"wp-block-heading\" id=\"h-colunas-do-tipo-n-o-identificado\"><span id=\"helpie-sp-3-5\"><strong>Unidentified columns<\/strong><\/span><\/h3>\n\n\n<p class=\"wp-block-paragraph\">If the system cannot automatically recognize a column\u2019s contents, it is assigned the &#8220;Unidentified&#8221; type.<\/p>\n\n\n<p class=\"wp-block-paragraph\">You need to review and classify these columns manually before using them. Otherwise, columns with this type are ignored when creating metrics and analyzing data.<\/p>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-dica-final\"><span id=\"helpie-sp-4\"><strong>Final tip<\/strong><\/span><\/h2>\n\n\n<p class=\"wp-block-paragraph\">Correct column classification ensures your data is interpreted properly in every visualization. An incorrect or outdated classification can affect data retrieval, so check these details when importing your spreadsheet.<\/p>\n\n\n<p class=\"wp-block-paragraph\">\u26a0\ufe0f <strong>Important:<\/strong> after you complete <strong>data classification<\/strong> in Reportei, you cannot edit it. <strong>Avoid changing the structure of the original spreadsheet<\/strong>, such as moving, adding, or deleting columns, because these changes can prevent the data from being read correctly. If you need to make a structural change, <strong>connect the spreadsheet to Reportei again as a new integration<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For Reportei to interpret your spreadsheet correctly, you need to classify the data type of each column or row, depending on the spreadsheet\u2019s layout. This ensures the data can be read, grouped, and displayed correctly in charts, tables, metrics, and filters. Before configuring the integration, check these two key aspects of your spreadsheet: 1. Identify [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"inline_featured_image":false,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"helpdesk_category":[4179],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-82677","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-google-sheets"],"_links":{"self":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/comments?post=82677"}],"version-history":[{"count":3,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82677\/revisions"}],"predecessor-version":[{"id":83868,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82677\/revisions\/83868"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/media?parent=82677"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpdesk_category?post=82677"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_tag?post=82677"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_add_tag?post=82677"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_up_tag?post=82677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}