<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":82694,"date":"2026-09-29T17:53:43","date_gmt":"2026-09-29T20:53:43","guid":{"rendered":"https:\/\/reportei.com\/?post_type=pauple_helpie&#038;p=82694"},"modified":"2026-10-15T13:04:43","modified_gmt":"2026-10-15T16:04:43","slug":"integracion-con-sheets-cuidados-necesarios-en-la-etapa-de-validacion-de-los-datos-de-la-hoja-de-calculo","status":"publish","type":"pauple_helpie","link":"https:\/\/reportei.com\/es\/central-de-ajuda\/integracion-con-sheets-cuidados-necesarios-en-la-etapa-de-validacion-de-los-datos-de-la-hoja-de-calculo\/","title":{"rendered":"Integraci\u00f3n con Sheets: qu\u00e9 revisar al validar los datos de la hoja de c\u00e1lculo"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Al integrar una hoja de c\u00e1lculo a Reportei, debes definir qu\u00e9 columnas \u2014en hojas verticales\u2014 o filas \u2014en hojas horizontales\u2014 se utilizar\u00e1n para crear m\u00e9tricas, gr\u00e1ficos y tablas, y c\u00f3mo debe interpretar esos datos la herramienta seg\u00fan la&nbsp;<a href=\"https:\/\/reportei.com\/es\/central-de-ajuda\/integracion-sheets-como-clasificar-columnas-o-filas-de-la-hoja-en-google-sheets\/\" target=\"_blank\" rel=\"noreferrer noopener\">clasificaci\u00f3n de las columnas o filas<\/a>. Estas configuraciones se realizan en la etapa de validaci\u00f3n de los datos de la hoja:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1024\" height=\"600\" src=\"https:\/\/reportei.com\/wp-content\/uploads\/2025\/08\/image-1-1-1024x600.png\" alt=\"\" class=\"wp-image-57994\" 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\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-essa-configura-o-pode-ser-alterada-depois\"><span id=\"helpie-sp-1\"><strong>\u00bfPuedo cambiar esta configuraci\u00f3n despu\u00e9s?<\/strong><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>No.<\/strong>En esta etapa, cada columna o fila debe clasificarse correctamente. Esa configuraci\u00f3n&nbsp;<strong>no puede editarse despu\u00e9s<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si necesitas cambiar los datos utilizados o la forma en que se organizan y clasifican, tendr\u00e1s que&nbsp;<strong>eliminar la integraci\u00f3n de la hoja actual y volver a integrarla<\/strong>con la nueva estructura.<\/p>\n\n\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>\u00bfPor qu\u00e9 no se puede cambiar la configuraci\u00f3n de los datos despu\u00e9s?<\/strong><\/span><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Durante la integraci\u00f3n, Reportei interpreta la estructura de la hoja seg\u00fan sus columnas o filas y las clasificaciones correspondientes. Esto permite leer los datos correctamente.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Esa estructura funciona como el esqueleto de la hoja: una vez clasificada, queda guardada como base para crear las m\u00e9tricas, gr\u00e1ficos y tablas disponibles en informes y dashboards.&nbsp;<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si necesitas cambiar una clasificaci\u00f3n o tipo guardado durante la validaci\u00f3n, debes integrar la hoja de nuevo para vincular la nueva estructura y recrear las m\u00e9tricas, tablas y gr\u00e1ficos a partir de ella.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-posso-alterar-minha-planilha-depois-da-integra-o\"><span id=\"helpie-sp-3\"><strong>\u00bfPuedo modificar la hoja despu\u00e9s de integrarla?<\/strong><\/span><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Evita los cambios estructurales en la hoja original despu\u00e9s de integrarla, ya que pueden afectar a los informes. Estos son algunos ejemplos:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Si tu hoja es vertical:<br><br><\/strong>\u274c Eliminar o cambiar el orden de las columnas;<br>\u274c Insertar columnas en medio de la estructura.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Si tu hoja es horizontal:<br><br><\/strong>\u274c Eliminar o cambiar el orden de las filas;<br>\u274c Insertar filas en medio de la estructura.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Si necesitas realizar esos cambios, debes integrar la hoja de nuevo. Consulta\u00a0<strong><em><a href=\"https:\/\/reportei.com\/es\/central-de-ajuda\/integracion-con-sheets-puedo-hacer-cambios-en-mi-hoja-de-calculo-despues-de-integrarla-a-reportei\/\">\u00bfPuedo modificar mi hoja de c\u00e1lculo despu\u00e9s de integrarla a Reportei?\u00a0<\/a><\/em><\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-dica-final\"><span id=\"helpie-sp-3-1\"><strong>\ud83d\udca1 Recomendaci\u00f3n final<\/strong><\/span><\/h4>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Antes de integrar la hoja, rev\u00edsala con atenci\u00f3n. Comprueba que incluya todas las columnas necesarias, con t\u00edtulos claros y organizadas seg\u00fan el uso que tendr\u00e1n en los informes.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Al integrar una hoja de c\u00e1lculo a Reportei, debes definir qu\u00e9 columnas \u2014en hojas verticales\u2014 o filas \u2014en hojas horizontales\u2014 se utilizar\u00e1n para crear m\u00e9tricas, gr\u00e1ficos y tablas, y c\u00f3mo debe interpretar esos datos la herramienta seg\u00fan la&nbsp;clasificaci\u00f3n de las columnas o filas. Estas configuraciones se realizan en la etapa de validaci\u00f3n de los datos [&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":[4452],"helpie_tag":[],"helpie_add_tag":[],"helpie_up_tag":[],"class_list":["post-82694","pauple_helpie","type-pauple_helpie","status-publish","format-standard","hentry","helpdesk_category-google-sheets"],"_links":{"self":[{"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/pauple_helpie\/82694","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/pauple_helpie"}],"about":[{"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/types\/pauple_helpie"}],"author":[{"embeddable":true,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/comments?post=82694"}],"version-history":[{"count":4,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/pauple_helpie\/82694\/revisions"}],"predecessor-version":[{"id":84719,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/pauple_helpie\/82694\/revisions\/84719"}],"wp:attachment":[{"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/media?parent=82694"}],"wp:term":[{"taxonomy":"helpdesk_category","embeddable":true,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/helpdesk_category?post=82694"},{"taxonomy":"helpie_tag","embeddable":true,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/helpie_tag?post=82694"},{"taxonomy":"helpie_add_tag","embeddable":true,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/helpie_add_tag?post=82694"},{"taxonomy":"helpie_up_tag","embeddable":true,"href":"https:\/\/reportei.com\/es\/wp-json\/wp\/v2\/helpie_up_tag?post=82694"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}