It occurs to me that we should maybe have some general guidelines for working with/producing CSVs. Currently the IATI Datastore, Dashboard, Codelist API, the Registry and the CSV Conversion tool linked to from the registry produce csvs. The Registry, CSV2IATI and AidStream also accept CSVs as inputs. If I have missed any active CSV producing/consuming IATI tools/APIs, please post them below.
Guidlines might include might include:
- What format should be used (ie. what should the separator be, and what type of escaping should be used)
- How should new lines be treated (the behaviour of quoted new lines seems to vary a lot)
- What encoding should be used (I would suggest UTF-8)
If these choices are consistent between multiple APIs, then they can share one piece of user guidance (ie. How to open this file in your spreadsheet program of choice). The most common user mistake I see is opening UTF-8 encoded files as windows code page.