Difference between revisions of "Exporting List View Results to Microsoft Excel"

From SmartWiki
Jump to: navigation, search
Line 14: Line 14:
 
* You can also tell the system where you want the results of the list view export to be positioned in the resultant Excel spreadsheet. Visit [[Positioning Exported List View Results in your Excel Spreadsheet|this page]] for instructions.
 
* You can also tell the system where you want the results of the list view export to be positioned in the resultant Excel spreadsheet. Visit [[Positioning Exported List View Results in your Excel Spreadsheet|this page]] for instructions.
 
* 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.
 
* 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.
 
{{ListViewFooter}}
 
{{ListViewFooter}}
 
* [[Positioning Exported List View Results in your Excel Spreadsheet]]
 
* [[Positioning Exported List View Results in your Excel Spreadsheet]]

Revision as of 13:08, 21 June 2013

caption Click here to watch a video on creating and editing List Views.


A major feature of SmartSimple list views is that list view results can be easily exported to Microsoft Excel. Once your list view has been created, take the following steps to enable exporting to Excel:

  1. Go to the list view configuration page.
  2. Click into the list view for which you wish to enable exporting.
  3. Click on the "Export" tab.
  4. Select the ExportListView enableexport.PNG option.
  5. Click the "Save" button.

ExportListView exportenabled.png

  • The Export button will now be enabled for your list view.

  • You can also tell the system where you want the results of the list view export to be positioned in the resultant Excel spreadsheet. Visit this page for instructions.
  • Additionally, you can upload an Excel spreadsheet to be used as a template for list view result exports. Visit this page for instructions.
  • SmartSimple uses special rules for exporting values stored in currency formats to Excel. Visit this page for detailed information.


See Also

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Exporting_List_View_Results_to_Microsoft_Excel&oldid=15481’