Únete gratis

Combine similar Excel worksheets safely

Autor: AILesson8 min de preparaciónProbado con:ChatGPTRevisado el: 2026-08-28

Respuesta rápida

Append recurring sheets after auditing schema drift, provenance, duplicates, types, and totals. Proporciona: Workbook sheets and schemas, Combined schema and record identity, Refresh and validation rules. Resultado esperado: A refreshable consolidation plan with schema mapping, source lineage, and reconciliation controls.

1

Añade tu contexto

Tu texto permanece en este navegador. AILesson Prompts no lo envía a un modelo ni a un servidor.

2

Tu prompt

Los campos sin rellenar permanecen visibles como marcadores de posición, para que puedas copiar y editar el prompt

Design a safe, refreshable method to combine the similar Excel worksheets.

Sheets, inclusion, headers, types, ranges, samples, totals, notes, and known differences:
[sheets]

Target columns, grain, key, provenance, duplicates, mappings, and missing-column behavior:
[target]

Excel version, new-sheet pattern, approval, method, errors, privacy, reconciliations, and archives:
[refresh]

Inventory and compare schemas before appending. Normalize headers through an explicit mapping rather than fuzzy similarity, distinguish missing columns from blank values, and prevent title rows, subtotals, totals, footnotes, hidden helper ranges, and the output sheet from becoming data. Add source lineage before combination. Define type conversion and error quarantine; do not silently coerce identifiers, dates, or amounts. Check duplicate natural keys both within and across sheets and apply only the supplied resolution rule. Prefer Power Query for repeatable refresh and avoid selecting sheets solely by a broad name pattern without an allowlist or schema gate. Return: inclusion/exclusion manifest; schema-drift report; canonical mapping; staged Power Query procedure and key operations; provenance and duplicate controls; row/count/amount reconciliation by source; error quarantine; refresh checklist; sample combined rows; and stop conditions.
Probar en Playground
Privado de forma predeterminadaLa preparación del prompt se realiza localmente en tu navegador. Evita introducir información confidencial en cualquier servicio de IA, a menos que tu organización lo permita.

De la entrada al resultado

Un ejemplo completo

Mira cómo un contexto concreto convierte esta receta en un resultado que puedes usar

Entrada real

Workbook sheets and schemas
Workbook has Excel Tables Sales_Jan on sheet Jan, Sales_Feb on Feb, Sales_Mar on Mar, plus Summary and Lookup sheets. Jan columns Order ID text, Order Date date, Region text, Net Sales decimal; 102 data rows, sum 48,320.50. Feb uses OrderID, Date, Region, Net Sales; 98 rows, sum 46,105.00. Mar adds Sales Rep between Region and Net Sales; 110 rows, sum 52,880.25. Each table has no total row. Summary must be excluded. Order IDs have leading zeroes. One Feb date cell contains text ‘TBD’. Sample duplicate: order 00481 appears in Jan and Feb because Feb corrected the amount.
Combined schema and record identity
Canonical columns Order ID, Order Date, Region, Sales Rep, Net Sales, Source Sheet, Source Table, Source Row. Grain is one current record per Order ID. Explicit mappings OrderID -> Order ID and Date -> Order Date. Missing Sales Rep in Jan/Feb remains null. Cross-sheet duplicate: later month wins only when a supplied Corrections table lists that Order ID and replacement month; otherwise quarantine both. Keep original source rows for audit.
Refresh and validation rules
Microsoft 365, Power Query. Approved source tables are Sales_Jan, Sales_Feb, Sales_Mar; future Sales_Apr etc require schema validation and explicit addition to allowlist. Type errors go to an Errors query, not dropped. Validate listed source counts/sums and combined counts. Output table is ConsolidatedSales and must never be read as input. No external files or personal customer data.

Ejemplo de salida

Manifest: include only Sales_Jan, Sales_Feb, Sales_Mar; exclude Summary, Lookup, ConsolidatedSales, and every future table until approved. Drift: Feb renames two columns; Mar adds optional Sales Rep; Feb has one Order Date type error. Canonical mapping is exact: OrderID→Order ID, Date→Order Date; all other headers must match. Missing Sales Rep becomes typed null, not an empty string.

Power Query staging: create one query per approved table with Source Sheet/Table and an index-based Source Row added before transformation. Rename from the mapping record, add missing Sales Rep as nullable text, select canonical columns, and apply types while retaining a pre-type copy or Try-based record for error capture. Append only the three staged valid-row queries. Build Errors from rows where date or amount conversion fails; the Feb TBD row appears there with its raw value and lineage. Do not delete it silently. Build DuplicateAudit by grouping Order ID and keeping all nested rows. Join duplicates to Corrections; select a replacement only when the listed month/table matches, otherwise exclude both from CurrentSales and keep them in quarantine.

Reconciliation before duplicate resolution: Jan 102 / 48,320.50; Feb 98 / 46,105.00 subject to the quarantined TBD date but Net Sales still traceable; Mar 110 / 52,880.25; appended raw count 310 and raw sum 147,305.75. Reconcile valid, error, duplicate-quarantine, and final-current row counts back to 310 with mutually exclusive statuses. Stop refresh on an unknown header, missing required column, unapproved source table, amount conversion error without quarantine, unlisted duplicate, or source count/total mismatch. A future April table is not auto-included.

Por qué funciona

  1. 1

    Schema gating prevents a similarly named summary or changed sheet from entering the dataset unnoticed.

  2. 2

    Per-source reconciliation makes dropped rows and duplicate ingestion traceable to one sheet.

Comprueba el resultado

  • Is every included sheet approved by name and canonical schema rather than name pattern alone?

  • Are provenance, missing columns, type errors, and duplicates visible after refresh?

  • Do row counts and material totals reconcile for every source sheet and the combined result?

Úsalo con confianza

Preguntas frecuentes

Respuestas prácticas sobre cuándo usar esta receta, qué debes proporcionar y en qué casos la revisión humana sigue siendo importante

What should I prepare before using “Combine similar Excel worksheets safely”?

For “Combine similar Excel worksheets safely,” prepare Workbook sheets and schemas, Combined schema and record identity, and Refresh and validation rules. Replace placeholders only with information you can verify. If a detail is unknown, preserve that uncertainty explicitly instead of asking the model to infer it.

When is the “Combine similar Excel worksheets safely” result not ready to use?

The result is not ready if it does not yet deliver the stated outcome—A refreshable consolidation plan with schema mapping, source lineage, and reconciliation controls—from the supplied evidence, or if it relies on unresolved assumptions, missing approvals, or invented details. Use the checks as release gates: revise the source inputs or assign a named, authorized reviewer instead of polishing an unsupported output.

Which AI tools have recorded tests for “Combine similar Excel worksheets safely”?

The published test record for “Combine similar Excel worksheets safely” lists ChatGPT as of 2026-08-28. This confirms recorded runs, not guaranteed compatibility or identical results in later product versions. For another tool or version, keep every constraint visible and repeat the result checks before use.

Más formas de explorar

Dónde encaja esta receta

Indicaciones de textoExcel y hojas de cálculo

Mantén el trabajo en marcha

AILesson · Cursos recomendados

Tu próximo paso: pon la IA a trabajar

Pasa de entender la IA a poner manos a la obra. Practica cómo dar instrucciones, revisar y mejorar resultados con lecciones interactivas para el trabajo y la vida cotidiana.

Explora todos los cursos
Portada de IA para principiantes

15 lecciones interactivas

IA para principiantes

Inicia una conversación útil con la IA, mejora la respuesta, comprueba lo importante y reconoce cuándo te corresponde dar el siguiente paso.

Explora este curso
Portada de Fundamentos de ChatGPT

10 lecciones interactivas

Fundamentos de ChatGPT

Aprende a usar ChatGPT mediante tres flujos de trabajo prácticos: completa una primera conversación, trabaja con un archivo y usa Projects para llevar un plan comprobado a una nueva conversación.

Explora este curso
Portada de Cómo funciona la IA generativa

7 lecciones interactivas

Cómo funciona la IA generativa

Comprende cómo los chats de IA habituales aprenden patrones del lenguaje, usan los mensajes actuales, construyen respuestas e incorporan fuentes y herramientas.

Explora este curso