Audit Excel headers, field definitions, and data types

작성자: AILesson7 분 소요테스트::ChatGPT검토일: 2026-08-28

빠른 답변

Compare a workbook with its intended schema before import, analysis, or automation. 제공할 내용: Workbook purpose and consumer, Expected schema, Observed headers and sample values. 예상 결과: A schema dictionary, conformance report, and row-level validation plan.

맥락 추가

텍스트는 이 브라우저에 유지됩니다. AILesson Prompts는 이를 모델이나 서버로 보내지 않습니다.

Workbook purpose and consumerExpected schemaObserved headers and sample values

프롬프트

채워지지 않은 필드는 플레이스홀더로 표시되므로 프롬프트를 복사하고 편집할 수 있습니다

Audit an Excel workbook against its intended schema.

Purpose and downstream consumer:
[purpose]

Expected schema:
[expected]

Observed headers and representative values:
[observed]

Check header names, order only when order matters, missing and unexpected fields, data types, date and number storage, requiredness, uniqueness, allowed values, and cross-field rules. Distinguish cell formatting from underlying value type. Return a data dictionary, schema-difference table with severity, row-level validation formulas, blocking issues, and an acceptance checklist. Do not declare conformance from display appearance alone.

Playground에서 사용해 보기

기본적으로 비공개프롬프트 구성은 브라우저에서 로컬로 이루어집니다. 조직에서 허용하지 않는 한 기밀 정보를 AI 서비스에 입력하지 마세요.

입력에서 결과까지

적용 예시

구체적인 맥락이 이 레시피를 바로 사용할 수 있는 결과로 바꾸는 방법을 확인하세요

실제 입력

Workbook purpose and consumer: Upload weekly orders to an operations system. Column order is irrelevant, but exact header names and field types are required.
Expected schema: OrderID required unique text; OrderDate required Excel date; CustomerID required text; Amount required number >=0; Currency required one of USD, EUR, GBP; Cancelled optional TRUE/FALSE. No extra fields containing notes may be uploaded.
Observed headers and sample values: Headers: Order ID, OrderDate, CustomerID, Amount, Currency, Cancelled, InternalNotes. Samples include Order ID 00125; OrderDate displayed 08/27/2026 but imported as text in some rows; Amount '$1,240.00' stored as text; Currency usd; Cancelled Yes.

예시 출력

Schema differences

Issue	Severity	Evidence	Required action
Order ID header differs from OrderID	Blocking	observed space	rename exactly
InternalNotes is unexpected	Blocking/privacy	extra sensitive-capable field	exclude from upload
OrderDate mixed type	Blocking	some values are text	convert and validate, do not only reformat
Amount stored as currency text	Blocking	$ and comma in text	parse under confirmed locale, retain raw
Currency uses lowercase	Fixable	usd	map approved case to USD
Cancelled uses Yes	Blocking until mapped	contract requires Boolean	approve Yes/No mapping or reject

Create a data dictionary with field, definition, stored type, required, allowed values, example, and validation. Row checks can include =AND(ISTEXT([@OrderID]),[@OrderID]<>""), =ISNUMBER([@OrderDate]), =AND(ISNUMBER([@Amount]),[@Amount]>=0), =ISNUMBER(XMATCH([@Currency],{"USD","EUR","GBP"})), and =OR([@Cancelled]=TRUE,[@Cancelled]=FALSE,[@Cancelled]=""). Check uniqueness with COUNTIF. Accept only when exact required headers exist, InternalNotes is excluded, every row passes type and domain checks, OrderID count equals unique OrderID count, and rejected rows are listed separately. Preserve 00125 as text.

효과가 있는 이유

1
A schema contract catches structural failures before they become misleading analysis results.
2
Testing underlying value types reveals dates and numbers that only look correctly formatted.

결과 확인

Are required fields, keys, and allowed values explicitly documented?
Do validation checks inspect stored types rather than display formats?
Are blocking import failures separated from nonblocking presentation differences?

안심하고 사용하세요

자주 묻는 질문

이 레시피를 언제 사용해야 하는지, 무엇을 제공해야 하는지, 그리고 어떤 부분에서 사람의 검토가 여전히 중요한지에 대한 실용적인 답변

What should I prepare before using “Audit Excel headers, field definitions, and data types”?

For “Audit Excel headers, field definitions, and data types,” prepare Workbook purpose and consumer, Expected schema, and Observed headers and sample values. 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 “Audit Excel headers, field definitions, and data types” result not ready to use?

The result is not ready if it does not yet deliver the stated outcome—A schema dictionary, conformance report, and row-level validation plan—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 “Audit Excel headers, field definitions, and data types”?

The published test record for “Audit Excel headers, field definitions, and data types” 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.

더 많은 탐색 방법