# How to Read a CSV File in Shortcuts on iPhone and Mac

Updated: November 15, 2026

- [Actions](https://sindresorhus.com/actions.md): Additional actions for the Shortcuts app. Price: Free. Platforms: macOS, iOS, visionOS. Get it from: [App Store](https://apps.apple.com/app/id1586435171). Requires macOS, iOS, or visionOS 26 or later. Free older versions for macOS 15, 14, 13, and 12: [download](https://sindresorhus.com/actions#older-versions).

URL: https://sindresorhus.com/guides/shortcuts-parse-csv

Add the “Parse CSV” action of the free [Actions](https://sindresorhus.com/actions.md) app, and give it the CSV file or text. The result is a list with a dictionary for each row, so “Get Dictionary Value” gets a value by the name of its column. The Shortcuts app itself has no action for CSV, only “Split Text”.

## With Actions

1. Install [Actions](https://sindresorhus.com/actions.md), and open it once.
1. In your shortcut, add the “Parse CSV” action of Actions.
1. In “CSV”, choose the file, or select the result of an earlier action, like “Select File” or the text of “Get Contents of URL”.
1. Expand the action. If the first row of the file has no column names, turn off “First Row Is Header”. For a file with tabs between the values, change “Delimiter” to “Tab”. For another character, like a semicolon, choose “Custom”, and type the character.
1. Add “Repeat with Each” below it, and in the repeat, add “Get Dictionary Value” with the name of a column as the key, like `Email`.

The result, “Parsed CSV”, has one dictionary for each row. A value can have commas and line breaks in quotes, like in the CSV files of Numbers and Excel.

- To keep only some rows, use “Filter List of Dictionaries” of Actions. To sort them by a column, use “Sort List of Dictionaries”.
- To show the rows as a table, use “Make Markdown Table”. To make a CSV file, use “Generate CSV”.
- A row that has no value in a column has no key for it. Turn on “Consistent Structure” to give each row all the columns.

## Without an app

The Shortcuts app can split the text of a simple CSV file:

1. Add “Split Text”, and split the CSV text by “New Lines”.
1. Add “Repeat with Each”, and in the repeat, add a second “Split Text” with “Custom” and a comma.
1. Use “Get Item from List” to get the value of a column by its number.

This works only when no value has a comma or a line break, as Shortcuts splits them too. You must also skip the row with the column names yourself.