Enabling users to download a CSV of all your articles.
At Admin -> Settings -> Switches, you have the option to allow CSV downloads of articles. If you enable this, your site's visitors will have the option to download a CSV file of all your articles which they can open in Excel, LibreOffice Calc or any other spreadsheet program. By default, the CSV download link appears in the member home area. You can use the code <a href="index.php?action=downloadcsv">Download CSV</a> to display it anywhere.
When the switch is enabled, there will be a selector near the bottom of Admin -> Settings -> General where you can select which fields to include in the CSV download.
To download a CSV as an administrator, you can just use Admin Panel -> Miscellaneous -> Export CSV. This does not require the switch to be on.