<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":82692,"date":"2026-09-29T17:53:38","date_gmt":"2026-09-29T20:53:38","guid":{"rendered":"https:\/\/reportei.com\/?post_type=pauple_helpie&#038;p=82692"},"modified":"2026-10-15T12:59:41","modified_gmt":"2026-10-15T15:59:41","slug":"integration-with-sheets-necessary-precautions-in-the-data-validation-step-of-the-spreadsheet","status":"publish","type":"pauple_helpie","link":"https:\/\/reportei.com\/en\/central-de-ajuda\/integration-with-sheets-necessary-precautions-in-the-data-validation-step-of-the-spreadsheet\/","title":{"rendered":"Google Sheets: what to check during spreadsheet data validation"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">When connecting a spreadsheet to Reportei, you need to choose which columns (for vertical spreadsheets) or rows (for horizontal spreadsheets) will be used to create metrics, charts, and tables\u2014and how Reportei should interpret the data based on the\u00a0<a href=\"https:\/\/reportei.com\/en\/central-de-ajuda\/sheets-integration-how-to-sort-columns-or-rows-in-the-spreadsheet-on-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">column or row classification<\/a>. You configure these settings during the spreadsheet data validation step:<\/p><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"600\" alt=\"\" class=\"wp-image-57994\" src=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1024x600.png\" srcset=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1024x600.png 1024w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-300x176.png 300w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-768x450.png 768w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1536x900.png 1536w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-2048x1199.png 2048w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-750x439.png 750w, https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-400x234.png 400w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p><strong>Check before you continue:<\/strong> Make sure each column or row has the correct name, position, and data type. The settings saved during validation cannot be changed later for this integration.<\/p><\/blockquote>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<h3 class=\"wp-block-heading\" id=\"h-essa-configura-o-pode-ser-alterada-depois\"><span id=\"helpie-sp-1\"><strong>Can I change these settings later?<\/strong><\/span><\/h3>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\"><strong>No.<\/strong>\u00a0You must classify each column or row correctly at this stage. These settings\u00a0<strong>cannot be edited later<\/strong>.<\/p>\n\n<p class=\"wp-block-paragraph\">If you need to change which data is used or how it is organized and classified, you will need to\u00a0<strong>remove the current spreadsheet integration and reconnect the spreadsheet<\/strong>\u00a0with the new structure.<\/p>\n\n<h3 class=\"wp-block-heading\" id=\"h-por-que-n-o-poss-vel-mudar-a-configura-o-dos-dados-ap-s-esta-etapa\"><span id=\"helpie-sp-2\"><strong>Why can\u2019t I change the data settings after this step?<\/strong><\/span><\/h3>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">When you connect a spreadsheet, Reportei reads its structure based on the columns (or rows) and their classifications. This ensures the data is interpreted correctly.<\/p>\n\n<p class=\"wp-block-paragraph\">These classifications define the spreadsheet\u2019s \u201cframework.\u201d Once saved, this framework serves as the basis for all the metrics, charts, and tables you can use in reports and dashboards.\u00a0<\/p>\n\n<p class=\"wp-block-paragraph\">If you need to change a classification or data type saved during validation, you must reconnect the spreadsheet so Reportei can use the new structure and recreate the metrics, tables, and charts based on that new framework.<\/p>\n\n<h2 class=\"wp-block-heading\" id=\"h-posso-alterar-minha-planilha-depois-da-integra-o\"><span id=\"helpie-sp-3\"><strong>Can I change my spreadsheet after connecting it?<\/strong><\/span><\/h2>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">Avoid structural changes to the original spreadsheet after connecting it, as they can affect how your reports work. Here are some examples of changes to avoid:<\/p>\n\n<p class=\"wp-block-paragraph\"><strong>If your spreadsheet is vertical:<br\/><br\/><\/strong>\u274c Deleting or reordering columns<br\/>\u274c Inserting columns in the middle of the existing structure<\/p>\n\n<p class=\"wp-block-paragraph\"><strong>If your spreadsheet is horizontal:<br\/><br\/><\/strong>\u274c Deleting or reordering rows<br\/>\u274c Inserting rows in the middle of the existing structure<\/p>\n\n<p class=\"wp-block-paragraph\">If you need to make these changes, you will have to reconnect the spreadsheet. To learn more, see\u00a0<strong><em><a href=\"https:\/\/reportei.com\/en\/central-de-ajuda\/integration-with-sheets-can-i-make-changes-to-my-spreadsheet-after-integrating-with-reportei\/\">Can I make changes to my spreadsheet after connecting it to Reportei?\u00a0<\/a><\/em><\/strong><\/p>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<h4 class=\"wp-block-heading\" id=\"h-dica-final\"><span id=\"helpie-sp-3-1\"><strong>\ud83d\udca1 Final tip<\/strong><\/span><\/h4>\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n<p class=\"wp-block-paragraph\">Before connecting your spreadsheet, review it carefully. Make sure all the columns you need are present, have clear headings, and are organized the way you intend to use them in your reports.<\/p>\n\n","protected":false},"excerpt":{"rendered":"<p>When connecting a spreadsheet to Reportei, you need to choose which columns (for vertical spreadsheets) or rows (for horizontal spreadsheets) will be used to create metrics, charts, and tables\u2014and how Reportei should interpret the data based on the\u00a0column or row classification. You configure these settings during the spreadsheet data validation step: Check before you continue: [&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-82692","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\/82692","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=82692"}],"version-history":[{"count":6,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82692\/revisions"}],"predecessor-version":[{"id":84673,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/pauple_helpie\/82692\/revisions\/84673"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/media?parent=82692"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpdesk_category?post=82692"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_tag?post=82692"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_add_tag?post=82692"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/en\/wp-json\/wp\/v2\/helpie_up_tag?post=82692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}