Power QueryExercises

Import a CSV that has no header row (cafes)

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
Free — no account needed
Loading the practice workspace…

About this exercise

What you'll practise

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

Bean There Cafés (fictional) send each site's daily takings from the till as a plain CSV with no header.

Steps

  1. TakingsFile has no header row. Every line is: store, date (yyyy-mm-dd), amount.
  2. Don't promote headers (the first line is data). Name the columns Store, Date and Amount.
  3. Set Date to a date and Amount to a decimal number (en-US).

Your result must

  • The first line is a data row, not a header
  • Columns: Store, Date, Amount
  • Date is a date, Amount a number

Input

  • TakingsFile (file)
    • Text file; first line: Riverside,2026-04-14,1231.41
    • Every field is text until you set types

Expected output columns

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

First 3 of 5 expected rows
StoreDateAmount
Riverside2026-04-141231.41
Market Sq2026-03-07340.92
Mill Lane2026-04-06971.18