Power QueryExercises

Import a CSV whose descriptions contain commas (hardware)

Some item descriptions contain commas and quote marks. Import the file so each description stays in one column.

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

Understand CSV quoting: commas inside a quoted field belong to the value.

Tinker Depot (fictional) runs two warehouses for hardware supplies and exports stock levels nightly.

Steps

  1. ItemFile is a comma-separated file. Fields that contain commas or quote marks are wrapped in double quotes, with inner quotes doubled.
  2. Parse it so quoted fields stay whole (QuoteStyle.Csv), and use the first row as headers.
  3. Set OnHand to a whole number. Keep SKU and Description as text. Output SKU, Description, OnHand.

Your result must

  • Three columns: SKU, Description, OnHand
  • "Hinge, small" stays one value
  • Inch marks like 12" survive

Input

  • ItemFile (file)
    • Text file; first line: SKU,Description,OnHand
    • Every field is text until you set types

Expected output columns

SKU (text), Description (text), OnHand (number)

First 3 of 7 expected rows
SKUDescriptionOnHand
SKU-001Hinge, 12" long69
SKU-002Hinge, pack of 1062
SKU-003Wood Screw, 12" long16