Power QueryExercises

Import a CSV that has no header row (kiosks)

The till system writes daily takings without a header line. Name the columns yourself and type them.

Level
beginner
Time
~6 min
Task
Build the query
Access
Pro
Checking your access…

About this exercise

What you'll practise

Import headerless CSV data without losing the first row, and name columns from a known layout.

The scenario, sample data, step list, hints and solution open with Pro. Grading checks your query against hidden data as well as the visible sample, so a query that only fits the sample doesn't pass.

Input

  • TakingsFile (file)
    • Text file; first line: Harbour,2026-04-06,2320.20
    • Every field is text until you set types

Expected output columns

Store (text), Date (date), Amount (number)