How to parse a 900mb yml file?

Question

PHP

You need to parse the yml file, which weighs 900mb.
Take data from it and put it in excel.
The file is huge. Recommend a library to do this quickly. Need to be done on an ongoing basis (to update prices)

Answer 1

YML is valid XML.
You can parse, for example, with this: php.net/manual/ru/class.xmlreader.php You
read streaming, process each node and write to your Excel.

Answer 2

Parsing multi-gigabyte xml with this either - https://github.com/prewk/xml-string-streamer - everything is fine.
Good luck!