Changes

Jump to: navigation, search

Exporting List View Results to Microsoft Excel

279 bytes added, 15:04, 7 January 2014
m
Modified the note and added a note to point out that the extra column in the basic search which is added when searching for a value in a custom field does not export to the excel file.
* Additionally, you can upload an Excel spreadsheet to be used as a template for list view result exports. Visit [[Using an Excel Template for List View Export Results|this page]] for instructions.
* SmartSimple uses special rules for exporting values stored in currency formats to Excel. Visit [[Exporting Currency Values to Excel from List Views|this page]] for detailed information.
 '''Note:'''* Note that buttons Buttons displayed on the list view, such as [[Quick Edit]] buttons and {{WPV}}s, will not be exported. A blank column in the Excel file will result for columns containing only buttons.* In the basic search, when searching on a custom field, an additional column is added to the list view showing the values for that custom field. This additional column will not be exported to the Excel spreadsheet, an additional list view export can be configured for that. 
{{ListViewFooter}}
* [[Positioning Exported List View Results in your Excel Spreadsheet]]
15
edits

Navigation menu