CodableCSV alternatives and similar libraries
Based on the "CSV" category.
Alternatively, view CodableCSV alternatives based on common mentions on social networks and blogs.
Do you think we are missing an alternative of CodableCSV or a related project?
Popular Comparisons
README
CodableCSV provides:
- Imperative CSV reader/writer.
- Declarative CSV encoder/decoder.
- Support multiple inputs/outputs:
String
s,Data
blobs,URL
s, andStream
s (commonly used forstdin
). - Support numerous string encodings and Byte Order Markers (BOM).
- Extensive configuration: delimiters, escaping scalar, trim strategy, codable strategies, presampling, etc.
- RFC4180 compliant with default configuration and CRLF (
\r\n
) row delimiter. - Multiplatform support with no dependencies (the Swift Standard Library and Foundation are implicit dependencies).
Usage
To use this library, you need to:
Add CodableCSV to your project.
You can choose to add the library through SPM or Cocoapods:
SPM (Swift Package Manager).
// swift-tools-version:5.1 import PackageDescription let package = Package( /* Your package name, supported platforms, and generated products go here */ dependencies: [ .package(url: "https://github.com/dehesa/CodableCSV.git", from: "0.6.7") ], targets: [ .target(name: /* Your target name here */, dependencies: ["CodableCSV"]) ] )
-
pod 'CodableCSV', '~> 0.6.7'
Import CodableCSV in the file that needs it.
import CodableCSV
There are two ways to use this library:
- imperatively, as a row-by-row and field-by-field reader/writer.
- declaratively, through Swift's
Codable
interface.
Imperative Reader/Writer
The following types provide imperative control on how to read/write CSV data.
CSVReader
A CSVReader
parses CSV data from a given input (String
, Data
, URL
, or InputStream
) and returns CSV rows as a String
s array. CSVReader
can be used at a high-level, in which case it parses an input completely; or at a low-level, in which each row is decoded when requested.
Complete input parsing.
let data: Data = ... let result = try CSVReader.decode(input: data)
Once the input is completely parsed, you can choose how to access the decoded data:
let headers: [String] = result.headers // Access the CSV rows (i.e. raw [String] values) let rows = result.rows let row = result[0] // Access the CSV record (i.e. convenience structure over a single row) let records = result.records let record = result[record: 0] // Access the CSV columns through indices or header values. let columns = result.columns let column = result[column: 0] let column = result[column: "Name"] // Access fields through indices or header values. let fieldB: String = result[row: 3, column: 2] let fieldA: String? = result[row: 2, column: "Age"]
Row-by-row parsing.
let reader = try CSVReader(input: string) { $0.headerStrategy = .firstLine } let rowA = try reader.readRow()
Parse a row at a time, till
nil
is returned; or exit the scope and the reader will clean up all used memory.// Let's assume the input is: let string = "numA,numB,numC\n1,2,3\n4,5,6\n7,8,9" // The headers property can be accessed at any point after initialization. let headers: [String] = reader.headers // ["numA", "numB", "numC"] // Keep querying rows till `nil` is received. guard let rowB = try reader.readRow(), // ["4", "5", "6"] let rowC = try reader.readRow() /* ["7", "8", "9"] */ else { ... }
Alternatively you can use the
readRecord()
function which also returns the next CSV row, but it wraps the result in a convenience structure. This structure lets you access each field with the header name (as long as theheaderStrategy
is marked with.firstLine
).let reader = try CSVReader(input: string) { $0.headerStrategy = .firstLine } let headers = reader.headers // ["numA", "numB", "numC"] let recordA = try reader.readRecord() let rowA = recordA.row // ["1", "2", "3"] let fieldA = recordA[0] // "1" let fieldB = recordA["numB"] // "2" let recordB = try reader.readRecord()
Sequence
syntax parsing.let reader = try CSVReader(input: URL(...), configuration: ...) for row in reader { // Do something with the row: [String] }
Please note the
Sequence
syntax (i.e.IteratorProtocol
) doesn't throw errors; therefore if the CSV data is invalid, the previous code will crash. If you don't control the CSV data origin, usereadRow()
instead.
Reader Configuration
CSVReader
accepts the following configuration properties:
encoding
(defaultnil
) specify the CSV file encoding.This
String.Encoding
value specify how each underlying byte is represented (e.g..utf8
,.utf32littleEndian
, etc.). If it isnil
, the library will try to figure out the file encoding through the file's Byte Order Marker. If the file doesn't contain a BOM,.utf8
is presumed.delimiters
(default(field: ",", row: "\n")
) specify the field and row delimiters.CSV fields are separated within a row with field delimiters (commonly a "comma"). CSV rows are separated through row delimiters (commonly a "line feed"). You can specify any unicode scalar,
String
value, ornil
for unknown delimiters.escapingStrategy
(default"
) specify the Unicode scalar used to escape fields.CSV fields can be escaped in case they contain privilege characters, such as field/row delimiters. Commonly the escaping character is a double quote (i.e.
"
), by setting this configuration value you can change it (e.g. a single quote), or disable the escaping functionality.headerStrategy
(default.none
) indicates whether the CSV data has a header row or not.CSV files may contain an optional header row at the very beginning. This configuration value lets you specify whether the file has a header row or not, or whether you want the library to figure it out.
trimStrategy
(default empty set) trims the given characters at the beginning and end of each parsed field.The trim characters are applied for the escaped and unescaped fields. The set cannot include any of the delimiter characters or the escaping scalar. If so, an error will be thrown during initialization.
presample
(defaultfalse
) indicates whether the CSV data should be completely loaded into memory before parsing begins.Loading all data into memory may provide faster iteration for small to medium size files, since you get rid of the overhead of managing an
InputStream
.
The configuration values are set during initialization and can be passed to the CSVReader
instance through a structure or with a convenience closure syntax:
let reader = CSVReader(input: ...) {
$0.encoding = .utf8
$0.delimiters.row = "\r\n"
$0.headerStrategy = .firstLine
$0.trimStrategy = .whitespaces
}
CSVWriter
A CSVWriter
encodes CSV information into a specified target (i.e. a String
, or Data
, or a file). It can be used at a high-level, by encoding completely a prepared set of information; or at a low-level, in which case rows or fields can be written individually.
Complete CSV rows encoding.
let input = [ ["numA", "numB", "name" ], ["1" , "2" , "Marcos" ], ["4" , "5" , "Marine-Anaïs"] ] let data = try CSVWriter.encode(rows: input) let string = try CSVWriter.encode(rows: input, into: String.self) try CSVWriter.encode(rows: input, into: URL("~/Desktop/Test.csv")!, append: false)
Row-by-row encoding.
let writer = try CSVWriter(fileURL: URL("~/Desktop/Test.csv")!, append: false) for row in input { try writer.write(row: row) } try writer.endEncoding()
Alternatively, you may write directly to a buffer in memory and access its
Data
representation.let writer = try CSVWriter { $0.headers = input[0] } for row in input.dropFirst() { try writer.write(row: row) } try writer.endEncoding() let result = try writer.data()
Field-by-field encoding.
let writer = try CSVWriter(fileURL: URL("~/Desktop/Test.csv")!, append: false) try writer.write(row: input[0]) input[1].forEach { try writer.write(field: field) } try writer.endRow() try writer.write(fields: input[2]) try writer.endRow() try writer.endEncoding()
CSVWriter
has a wealth of low-level imperative APIs, that let you write one field, several fields at a time, end a row, write an empty row, etc.Please notice that a CSV requires all rows to have the same amount of fields.
CSVWriter
enforces this by throwing an error when you try to write more the expected amount of fields, or filling a row with empty fields when you callendRow()
but not all fields have been written.
Writer Configuration
CSVWriter
accepts the following configuration properties:
delimiters
(default(field: ",", row: "\n")
) specify the field and row delimiters.CSV fields are separated within a row with field delimiters (commonly a "comma"). CSV rows are separated through row delimiters (commonly a "line feed"). You can specify any unicode scalar,
String
value, ornil
for unknown delimiters.escapingStrategy
(default.doubleQuote
) specify the Unicode scalar used to escape fields.CSV fields can be escaped in case they contain privilege characters, such as field/row delimiters. Commonly the escaping character is a double quote (i.e.
"
), by setting this configuration value you can change it (e.g. a single quote), or disable the escaping functionality.headers
(default[]
) indicates whether the CSV data has a header row or not.CSV files may contain an optional header row at the very beginning. If this configuration value is empty, no header row is written.
encoding
(defaultnil
) specify the CSV file encoding.This
String.Encoding
value specify how each underlying byte is represented (e.g..utf8
,.utf32littleEndian
, etc.). If it isnil
, the library will try to figure out the file encoding through the file's Byte Order Marker. If the file doesn't contain a BOM,.utf8
is presumed.bomStrategy
(default.convention
) indicates whether a Byte Order Marker will be included at the beginning of the CSV representation.The OS convention is that BOMs are never written, except when
.utf16
,.utf32
, or.unicode
string encodings are specified. You could however indicate that you always want the BOM written (.always
) or that is never written (.never
).
The configuration values are set during initialization and can be passed to the CSVWriter
instance through a structure or with a convenience closure syntax:
let writer = CSVWriter(fileURL: ...) {
$0.delimiters.row = "\r\n"
$0.headers = ["Name", "Age", "Pet"]
$0.encoding = .utf8
$0.bomStrategy = .never
}
CSVError
Many of CodableCSV
's imperative functions may throw errors due to invalid configuration values, invalid CSV input, file stream failures, etc. All these throwing operations exclusively throw CSVError
s that can be easily caught with do
-catch
clause.
do {
let writer = try CSVWriter()
for row in customData {
try writer.write(row: row)
}
} catch let error {
print(error)
}
CSVError
adopts Swift Evolution's SE-112 protocols and CustomDebugStringConvertible
. The error's properties provide rich commentary explaining what went wrong and indicate how to fix the problem.
-
type
: The error group category. -
failureReason
: Explanation of what went wrong. -
helpAnchor
: Advice on how to solve the problem. -
errorUserInfo
: Arguments associated with the operation that threw the error. -
underlyingError
: Optional underlying error, which provoked the operation to fail (most of the time isnil
). -
localizedDescription
: Returns a human readable string with all the information contained in the error.
You can get all the information by simply printing the error or calling the localizedDescription
property on a properly casted CSVError<CSVReader>
or CSVError<CSVWriter>
.
Declarative Decoder/Encoder
The encoders/decoders provided by this library let you use Swift's Codable
declarative approach to encode/decode CSV data.
CSVDecoder
CSVDecoder
transforms CSV data into a Swift type conforming to Decodable
. The decoding process is very simple and it only requires creating a decoding instance and call its decode
function passing the Decodable
type and the input data.
let decoder = CSVDecoder()
let result = try decoder.decode(CustomType.self, from: data)
CSVDecoder
can decode CSVs represented as a Data
blob, a String
, an actual file in the file system, or an InputStream
(e.g. stdin
).
let decoder = CSVDecoder { $0.bufferingStrategy = .sequential }
let content = try decoder.decode([Student].self, from: URL("~/Desktop/Student.csv"))
If you are dealing with a big CSV file, it is preferred to used direct file decoding, a .sequential
or .unrequested
buffering strategy, and set presampling to false; since then memory usage is drastically reduced.
Decoder Configuration
The decoding process can be tweaked by specifying configuration values at initialization time. CSVDecoder
accepts the same configuration values as CSVReader
plus the following ones:
nilStrategy
(default:.empty
) indicates how thenil
concept (absence of value) is represented on the CSV.boolStrategy
(default:.insensitive
) defines how strings are decoded toBool
values.nonConformingFloatStrategy
(default.throw
) specifies how to handle non-numbers (e.g.NaN
and infinity).decimalStrategy
(default.locale
) indicates how strings are decoded toDecimal
values.dateStrategy
(default.deferredToDate
) specify how strings are decoded toDate
values.dataStrategy
(default.base64
) indicates how strings are decoded toData
values.bufferingStrategy
(default.keepAll
) controls the behavior ofKeyedDecodingContainer
s.Selecting a buffering strategy affects the decoding performance and the amount of memory used during the decoding process. For more information check the README's Tips using
Codable
section and the [Strategy.DecodingBuffer
definition](sources/declarative/decodable/DecoderConfiguration.swift).
The configuration values can be set during CSVDecoder
initialization or at any point before the decode
function is called.
let decoder = CSVDecoder {
$0.encoding = .utf8
$0.delimiters.field = "\t"
$0.headerStrategy = .firstLine
$0.bufferingStrategy = .keepAll
$0.decimalStrategy = .custom({ (decoder) in
let value = try Float(from: decoder)
return Decimal(value)
})
}
CSVDecoder.Lazy
A CSV input can be decoded on demand (i.e. row-by-row) with the decoder's lazy(from:)
function.
let decoder = CSVDecoder(configuration: config).lazy(from: fileURL)
let student1 = try decoder.decodeRow(Student.self)
let student2 = try decoder.decodeRow(Student.self)
CSVDecoder.Lazy
conforms to Swift's Sequence
protocol, letting you use functionality such as map()
, allSatisfy()
, etc. Please note, CSVDecoder.Lazy
cannot be used for repeated access; It consumes the input CSV.
let decoder = CSVDecoder().lazy(from: fileData)
let students = try decoder.map { try $0.decode(Student.self) }
A nice benefit of using the lazy operation, is that it lets you switch how a row is decoded at any point. For example:
let decoder = CSVDecoder().lazy(from: fileString)
// The first 100 rows are students.
let students = ( 0..<100).map { _ in try decoder.decode(Student.self) }
// The second 100 rows are teachers.
let teachers = (100..<110).map { _ in try decoder.decode(Teacher.self) }
Since CSVDecoder.Lazy
exclusively provides sequential access; setting the buffering strategy to .sequential
will reduce the decoder's memory usage.
let decoder = CSVDecoder {
$0.headerStrategy = .firstLine
$0.bufferingStrategy = .sequential
}.lazy(from: fileURL)
CSVEncoder
CSVEncoder
transforms Swift types conforming to Encodable
into CSV data. The encoding process is very simple and it only requires creating an encoding instance and call its encode
function passing the Encodable
value.
let encoder = CSVEncoder()
let data = try encoder.encode(value, into: Data.self)
The Encoder
's encode()
function creates a CSV file as a Data
blob, a String
, or an actual file in the file system.
let encoder = CSVEncoder { $0.headers = ["name", "age", "hasPet"] }
try encoder.encode(value, into: URL("~/Desktop/Students.csv"))
If you are dealing with a big CSV content, it is preferred to use direct file encoding and a .sequential
or .assembled
buffering strategy, since then memory usage is drastically reduced.
Encoder Configuration
The encoding process can be tweaked by specifying configuration values. CSVEncoder
accepts the same configuration values as CSVWriter
plus the following ones:
nilStrategy
(default:.empty
) indicates how thenil
concept (absence of value) is represented on the CSV.boolStrategy
(default:.deferredToString
) defines how Boolean values are encoded toString
values.nonConformingFloatStrategy
(default.throw
) specifies how to handle non-numbers (i.e.NaN
and infinity).decimalStrategy
(default.locale
) indicates how decimal numbers are encoded toString
values.dateStrategy
(default.deferredToDate
) specify how dates are encoded toString
values.dataStrategy
(default.base64
) indicates how data blobs are encoded toString
values.bufferingStrategy
(default.keepAll
) controls the behavior ofKeyedEncodingContainer
s.Selecting a buffering strategy directly affect the encoding performance and the amount of memory used during the process. For more information check this README's Tips using
Codable
section and the [Strategy.EncodingBuffer
definition](sources/declarative/encodable/EncoderConfiguration.swift).
The configuration values can be set during CSVEncoder
initialization or at any point before the encode
function is called.
let encoder = CSVEncoder {
$0.headers = ["name", "age", "hasPet"]
$0.delimiters = (field: ";", row: "\r\n")
$0.dateStrategy = .iso8601
$0.bufferingStrategy = .sequential
$0.floatStrategy = .convert(positiveInfinity: "∞", negativeInfinity: "-∞", nan: "≁")
$0.dataStrategy = .custom({ (data, encoder) in
let string = customTransformation(data)
var container = try encoder.singleValueContainer()
try container.encode(string)
})
}
The
.headers
configuration is required if you are using keyed encoding container.
CSVEncoder.Lazy
A series of codable types (representing CSV rows) can be encoded on demand with the encoder's lazy(into:)
function.
let encoder = CSVEncoder().lazy(into: Data.self)
for student in students {
try encoder.encodeRow(student)
}
let data = try encoder.endEncoding()
Call endEncoding()
once there is no more values to be encoded. The function will return the encoded CSV.
let encoder = CSVEncoder().lazy(into: String.self)
students.forEach {
try encoder.encode($0)
}
let string = try encoder.endEncoding()
A nice benefit of using the lazy operation, is that it lets you switch how a row is encoded at any point. For example:
let encoder = CSVEncoder(configuration: config).lazy(into: fileURL)
students.forEach { try encoder.encode($0) }
teachers.forEach { try encoder.encode($0) }
try encoder.endEncoding()
Since CSVEncoder.Lazy
exclusively provides sequential encoding; setting the buffering strategy to .sequential
will reduce the encoder's memory usage.
let encoder = CSVEncoder {
$0.bufferingStrategy = .sequential
}.lazy(into: String.self)
Tips using Codable
Codable
is fairly easy to use and most Swift standard library types already conform to it. However, sometimes it is tricky to get custom types to comply to Codable
for specific functionality.
Basic adoption.
When a custom type conforms to Codable
, the type is stating that it has the ability to decode itself from and encode itself to a external representation. Which representation depends on the decoder or encoder chosen. Foundation provides support for JSON and Property Lists and the community provide many other formats, such as: YAML, XML, BSON, and CSV (through this library).
Usually a CSV represents a long list of entities. The following is a simple example representing a list of students.
let string = """
name,age,hasPet
John,22,true
Marine,23,false
Alta,24,true
"""
A student can be represented as a structure:
struct Student: Codable {
var name: String
var age: Int
var hasPet: Bool
}
To decode the list of students, create a decoder and call decode
on it passing the CSV sample.
let decoder = CSVDecoder { $0.headerStrategy = .firstLine }
let students = try decoder.decode([Student].self, from: string)
The inverse process (from Swift to CSV) is very similar (and simple).
let encoder = CSVEncoder { $0.headers = ["name", "age", "hasPet"] }
let newData = try encoder.encode(students)
Specific behavior for CSV data.
When encoding/decoding CSV data, it is important to keep several points in mind:
Codable's automatic synthesis requires CSV files with a headers row.
Codable
is able to synthesize init(from:)
and encode(to:)
for your custom types when all its members/properties conform to Codable
. This automatic synthesis create a hidden CodingKeys
enumeration containing all your property names.
During decoding, CSVDecoder
tries to match the enumeration string values with a field position within a row. For this to work the CSV data must contain a headers row with the property names. If your CSV doesn't contain a headers row, you can specify coding keys with integer values representing the field index.
struct Student: Codable {
var name: String
var age: Int
var hasPet: Bool
private enum CodingKeys: Int, CodingKey {
case name = 0
case age = 1
case hasPet = 2
}
}
Using integer coding keys has the added benefit of better encoder/decoder performance. By explicitly indicating the field index, you let the decoder skip the functionality of matching coding keys string values to headers.
A CSV is a long list of rows/records.
CSV formatted data is commonly used with flat hierarchies (e.g. a list of students, a list of car models, etc.). Nested structures, such as the ones found in JSON files, are not supported by default in CSV implementations (e.g. a list of users, where each user has a list of services she uses, and each service has a list of the user's configuration values).
You can support complex structures in CSV, but you would have to flatten the hierarchy in a single model or build a custom encoding/decoding process. This process would make sure there is always a maximum of two keyed/unkeyed containers.
As an example, we can create a nested structure for a school with students who own pets.
struct School: Codable {
let students: [Student]
}
struct Student: Codable {
var name: String
var age: Int
var pet: Pet
}
struct Pet: Codable {
var nickname: String
var gender: Gender
enum Gender: Codable {
case male, female
}
}
By default the previous example wouldn't work. If you want to keep the nested structure, you need to overwrite the custom init(from:)
implementation (to support Decodable
).
extension School {
init(from decoder: Decoder) throws {
var container = try decoder.unkeyedContainer()
while !container.isAtEnd {
self.student.append(try container.decode(Student.self))
}
}
}
extension Student {
init(from decoder: Decoder) throws {
var container = try decoder.container(keyedBy: CustomKeys.self)
self.name = try container.decode(String.self, forKey: .name)
self.age = try container.decode(Int.self, forKey: .age)
self.pet = try decoder.singleValueContainer.decode(Pet.self)
}
}
extension Pet {
init(from decoder: Decoder) throws {
var container = try decoder.container(keyedBy: CustomKeys.self)
self.nickname = try container.decode(String.self, forKey: .nickname)
self.gender = try container.decode(Gender.self, forKey: .gender)
}
}
extension Pet.Gender {
init(from decoder: Decoder) throws {
var container = try decoder.singleValueContainer()
self = try container.decode(Int.self) == 1 ? .male : .female
}
}
private CustomKeys: Int, CodingKey {
case name = 0
case age = 1
case nickname = 2
case gender = 3
}
You could have avoided building the initializers overhead by defining a flat structure such as:
struct Student: Codable {
var name: String
var age: Int
var nickname: String
var gender: Gender
enum Gender: Int, Codable {
case male = 1
case female = 2
}
}
Encoding/decoding strategies.
SE167 proposal introduced to Foundation JSON and PLIST encoders/decoders. This proposal also featured encoding/decoding strategies as a new way to configure the encoding/decoding process. CodableCSV
continues this tradition and mirrors such strategies including some new ones specific to the CSV file format.
To configure the encoding/decoding process, you need to set the configuration values of the CSVEncoder
/CSVDecoder
before calling the encode()
/decode()
functions. There are two ways to set configuration values:
At initialization time, passing the
Configuration
structure to the initializer.var config = CSVDecoder.Configuration() config.nilStrategy = .empty config.decimalStrategy = .locale(.current) config.dataStrategy = .base64 config.bufferingStrategy = .sequential config.trimStrategy = .whitespaces config.encoding = .utf16 config.delimiters.row = "\r\n" let decoder = CSVDecoder(configuration: config)
Alternatively, there are convenience initializers accepting a closure with a
inout Configuration
value.let decoder = CSVDecoder { $0.nilStrategy = .empty $0.decimalStrategy = .locale(.current) // and so on and so forth }
CSVEncoder
andCSVDecoder
implement@dynamicMemberLookup
exclusively for their configuration values. Therefore you can set configuration values after initialization or after a encoding/decoding process has been performed.let decoder = CSVDecoder() decoder.bufferingStrategy = .sequential decoder.decode([Student].self, from: url1) decoder.bufferingStrategy = .keepAll decoder.decode([Pets].self, from: url2)
The strategies labeled with .custom
let you insert behavior into the encoding/decoding process without forcing you to manually conform to init(from:)
and encode(to:)
. When set, they will reference the targeted type for the whole process. For example, if you want to encode a CSV file where empty fields are marked with the word null
(for some reason). You could do the following:
let decoder = CSVDecoder()
decoder.nilStrategy = .custom({ (encoder) in
var container = encoder.singleValueContainer()
try container.encode("null")
})
Type-safe headers row.
You can generate type-safe name headers using Swift introspection tools (i.e. Mirror
) or explicitly defining the CodingKey
enum with String
raw value conforming to CaseIterable
.
struct Student {
var name: String
var age: Int
var hasPet: Bool
enum CodingKeys: String, CodingKey, CaseIterable {
case name, age, hasPet
}
}
Then configure your encoder with explicit headers.
let encoder = CSVEncoder {
$0.headers = Student.CodingKeys.allCases.map { $0.rawValue }
}
Performance advices.
warning("TODO:")
Roadmap
The library has been heavily documented and any contribution is welcome. Check the small [How to contribute](docs/CONTRIBUTING.md) document or take a look at the Github projects for a more in-depth roadmap.
Community
If CodableCSV
is not of your liking, the Swift community offers other CSV solutions:
- CSV.swift contains an imperative CSV reader/writer and a lazy row decoder and adheres to the RFC4180 standard.
- SwiftCSV is a well-tested parse-only library which loads the whole CSV in memory (not intended for large files).
- CSwiftV is a parse-only library which loads the CSV in memory and parses it in a single go (no imperative reading).
- CSVImporter is an asynchronous parse-only library with support for big CSV files (incremental loading).
- SwiftCSVExport reads/writes CSV imperatively with Objective-C support.
- swift-csv offers an imperative CSV reader/writer based on Foundation's streams.
There are many good tools outside the Swift community. Since writing them all would be a hard task, I will just point you to the great AwesomeCSV github repo. There are a lot of treasures to be found there.
*Note that all licence references and agreements mentioned in the CodableCSV README section above
are relevant to that project's source code only.