Csv Exports - Ordering Of Columns Using Scrapy Crawl -o Output.csv

Is there a way to specify the order of the columns in a CSV output using the -o parameter? It seems to follow a random order and does not follow the order in the items.py file or w

Solution 1:

There is a relevant field_to_export attribute in CsvItemExporter, but, as far as I understand, there is no way to set it from the command-line. You need to do it through the pipeline, see:

• How can I use the fields_to_export attribute in BaseItemExporter to order my Scrapy CSV data?

Solution 2:

You can solve it from adding a line in settings.py

FEED_EXPORT_FIELDS = ['field1', 'field2', 'field3']