Practical playbook · comfortable · 15 minutes
Understand a file or spreadsheet
Look inside an unfamiliar document or dataset, surface its quality problems, and check the number by hand before you rely on it.
- This is for you when
- You have a report, PDF, CSV or spreadsheet and need to know what is actually in it before you draw any conclusion.
- What you will leave with
- A checked summary, calculation or chart that stays anchored to the material you gave it.
The Human Partnership
Use the capability. Keep the part that needs a person.
The hard part is rarely producing a chart. It is knowing what the fields mean, whether the data is fit for this purpose, and whether the result survives a trace back to the source.
AI contribution
Choose a capability for a real job.
Each capability removes a different kind of effort. Its value depends on the human context beside it.
File extraction and schema inspection
File tools can read spreadsheets, CSV files, PDFs and documents, list sheets and fields, identify apparent data types and surface missing, duplicated or inconsistent values before analysis begins.
- The person contributes
- The person supplies definitions, explains how the file was produced and distinguishes a true zero, a blank, an unknown and a value that was never collected.
- Do not assume
- A tool can infer a column meaning from its label and still be wrong, especially when business definitions differ from ordinary language or changed over time.
Code backed analysis and formula generation
Data analysis tools can run Python or spreadsheet logic to clean data, calculate measures, join files, test patterns and create a reproducible table or chart.
- The person contributes
- The analyst chooses the correct population, denominator, exclusions and method, then inspects the code or formula rather than accepting the displayed answer alone.
- Do not assume
- Correctly executed code can produce a wrong answer when the definition, filter, unit or time grain is wrong, and a generated workbook can carry broken formulas into future periods.
Cross file synthesis and editable outputs
AI can reconcile several files, draft a quality note and return an editable spreadsheet, document or presentation that keeps calculations and findings together.
- The person contributes
- The person decides which source is authoritative, resolves conflicting totals and documents limitations so a polished output does not erase the uncertainty in the inputs.
- Do not assume
- Large, complex or image based files may be only partly read, and visual polish can make an incomplete analysis look finished.
Human expertise
The resources already inside the work.
Experience, relationships, definitions and accountability are inputs to the workflow, not a final check after AI has finished.
Definition ownership
You know what each field, status and measure means in the business, which definition is current and which exceptions must be handled deliberately.
Source process knowledge
You know how the data was collected, transformed and refreshed, where manual behaviour enters, and which changes in process can create a false trend.
Domain interpretation
You can judge whether the pattern makes sense in the real world, identify confounding events and translate a statistical result into an appropriate operational conclusion.
Shared workflow
See where the work changes hands.
The useful pattern is not one prompt followed by one check. The person and AI shape the work at different moments.
- 01 · person
Define the question and the data meaning
State the decision or question, provide approved files, explain critical fields and identify any privacy, access or retention limits before analysis.
- 02 · ai
Profile before calculating
File inspection, data profiling and code executionInspect the file structure, list assumptions, flag missing or inconsistent values and propose a calculation method before generating a headline finding.
- 03 · together
Correct definitions and rerun
Resolve ambiguous columns, inspect samples, agree filters and denominators, then rerun the analysis with the method and exclusions visible.
- 04 · decision
Decide whether the data is fit for purpose
The person decides whether the source quality supports the intended conclusion and whether the finding can guide action, needs qualification or should not be used.
- 05 · verification
Trace the answer back
Reconcile totals, hand check representative rows, inspect formulas or code, verify units and time periods, and retain enough method detail for another person to reproduce the result.
The decision stays human
Someone must be able to stand behind the result.
The person decides what the data means, whether it is fit for the stated purpose and which action the evidence justifies. The tool can calculate quickly, but it does not own the business definition or the consequence of a misleading metric.
Verification required
- Confirm source, refresh date, coverage, units, grain, definitions and known collection changes.
- Reconcile totals to an authoritative control and hand check a sample of source rows.
- Inspect generated code, formulas, filters, joins and denominators for the measures that drive the conclusion.
- Document missing data, exclusions, quality limitations and any finding that depends on an assumption.
- Check that uploaded information was authorised for the selected product, account and workspace.
Failure to watch
The main failure is a technically clean answer to the wrong data question. Errors in definitions, units, coverage or source process can survive every calculation and become more persuasive once they are charted.
Skill strengthened
Analytical scepticism
Used well, the workflow strengthens data literacy, definition discipline, source tracing and the habit of testing whether a result is both mathematically correct and meaningful in context.
Worked example
Watch the judgement change the draft.
The first pass is useful. The human correction is what makes it specific, appropriate and worth using.
The honest starting point
A customer-feedback CSV with date, channel, category, free-text comment and resolution-time columns.
A useful first pass
Initial finding: delivery complaints rose 18 per cent. Quality note: 12 per cent of category cells are blank and resolution time mixes hours and days.
Context changes the answer
The analyst gets the units onto one scale, reads twenty rows by hand, and realises a channel migration was being counted as a jump in complaints.
The version a person can stand behind
A verified chart showing delivery complaints were actually flat once the channel mix was corrected, alongside a written note of the data-quality problem that was found.
Try it on your work
Start with the real material.
Remove anything you cannot share, fill in the brackets and keep the decision and verification steps visible.
- Do not upload data you are not authorised to share.
- Do not lean on a calculation you cannot sample yourself or explain to someone else, because a wrong count often comes back looking clean and confident with nothing flagged.
- Read a generated spreadsheet before forwarding it: a common trap is a formula copied flat across future columns instead of rolling forward, which the file will not warn you about and which travels with the file once it looks polished.
- Check the file-size limit first, since these tools cap how much you can upload at once and a dataset that is too large will be quietly truncated or refused rather than analysed in full.
Before analysing this file, tell me what each field appears to mean, identify missing or inconsistent data and ask about ambiguous columns. Then answer: [question]. Show the calculation method, call out assumptions, keep source rows traceable and give me one chart only if it makes the result easier to verify.
Tools that can support this
Pick the tool after the job is clear.
These are evidence backed starting points, not universal winners. Open a guide or ask Bit to help you weigh the fit.
Its reviewed guide includes uploading files and running data analysis that writes and runs its own code, then returns charts.
inferred · moderate confidenceSee why it may fit →KimiIts reviewed guide leans toward large mixed file sets and editable document or spreadsheet outputs.
inferred · moderate confidenceSee why it may fit →Reviewed guidance
Where this came from
- Reviewed
- Review by
- Owner
- The Human Bit editorial
One quick check