How I would like to see the output in csv:

YAML file code: 9313ĮlectiveGroups: #this is the section i need to extract yaml file and converts it into a csv.Īn example of what is in the. yaml files (about 300 files in the same directory) and extracts a certain section (electives only) from the. I'm very new to python but I would appreciate your help in guiding me in creating a simple script that reads through a bunch of. I have solved maybe 90% of my problem with some ruby scripting. I need to get from a plain-text Key-Value pair format into two columns of a Google Spreadsheet, in as few steps as possible. It would make my like a lot better if I could cobble together a script or bunch of tools that would let me convert and upload from a single terminal command.

WHY NOT JUST COPY-AND-PASTE? (Or - man up and type into the dang spreadsheet) Nothing about this worked, and I ended up replacing all the 'r' characters, which was really stupid. I've also tried the yaml-to-csv converter at but that errors out if the yaml keys have spaces.įinally, I tried running a sed command to turn my colons and new lines into pipes (or something else) so that I could use pandoc to generate an html table. The first thing I tried was writing it as if it was a table in pandoc's pipe_tables format, but I hated it. I also am okay with a slightly different markup format.īoth the questions and answers are English content, and use all normal punctuation. I wouldn't mind if the output was a csv file or an html table and I had to do some copy-and-pasting or something. No, nothing that shows up seems to work.)Ī combination of tools or whatnot that would allow me to write a little script so I can go from that to a Google Drive spreadsheet in one step. My idea is to run this through some kind of YAML-to- CSV converter, but I can't find any that seem to work. People don't ask that question very frequently. Here's the format I'd like to write in (and have been): (For previous deliverables, I've been able to use a markdown processor with a cobbled-together script to deal with some of their other issues.)

I prefer to compose text in a plain-text editor, using markdown (or similar). I am not going to write paragraphs of text into a spreadsheet.

I know it's stupid, so let's not get into it here. I am required to deliver the content in the format specified. A Google Spreadsheet, with the questions in one column and the answers in the next.

Convert xml to csv google sheets