Import
Defoult mode
in the default download mode, due to available API, the maximum number of downloaded issues is 3000. Depending on the filter used or JQL structure, the first 3000 issues will be downloaded
Read only
in this mode, the maximum number of downloaded issue is 100,000. In this mode, it is not possible to edit issues, its a raw data.
Editing
Automatically coloring cells
In Excel, go to File > Options > Advanced > uncheck "Extend data range formats and formulas". This will have a global impact on your Excel.
JQL
JQL = Jira query lenguage