Eric Valente
Eric Valente

Reputation: 439

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 when the item fields get populated in the scrape.

Thanks!

Upvotes: 17

Views: 7323

Answers (2)

Md. Sazol
Md. Sazol

Reputation: 91

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

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

Upvotes: 9

alecxe
alecxe

Reputation: 474003

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:

Upvotes: 10

Related Questions