Skip to main content

Exporting to Excel with Advanced Search

The following information represents a quick guide for exporting to Excel with Advanced Search. If you have further questions or need assistance with the Advanced Search, please contact support@posim.com or call 800.553.9314 to speak with a tech support representative.

POSIM 13’s newly enhanced advanced search functionality now allows the direct export of search results to .xlsx format. Prior to this update to advanced search, to export search results directly out of POSIM required the use of POSIM’s reporting modules (Reports or Define a Report). With POSIM 13 it’s now possible to export the rows and columns of any advanced search result list, from any module in POSIM, directly to .xslx format.

To Export Advanced Search Results:

  1. Select the search columns to be exported
    Only columns which are checked in the Search Columns window will export when the search is pulled out of POSIM, so it’s important to ensure that all necessary columns have been selected prior to exporting the search. To select search columns, click on the Columns button and check the desired column names in the window that appears.

export to excel with advanced search 1
Use the Search Columns window to select columns for export

  1. Rearrange columns and use From and To fields to narrow the search
    To minimize further editing once the search has been exported, rearrange columns into the desired order by dragging the column headers. Use as many From and To fields as necessary to narrow the search results to show only the desired data.

export to excel with advanced search 2
Columns can be reordered by clicking the header and dragging (1). Narrow the search using the From and To Fields (2).

  1. Use the Export button to export the search results to .xlsx format
    Use the Item Search window as a preview to make sure the search is returning the desired results. Once the search results are ready, use the Export button to export the search as a spreadsheet.


Use the Export button to save search results in .xlsx format

[gravityform id="17" title="false" description="false" ajax="true" tabindex="88"]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_17' ><div id='gf_17' class='gform_anchor' tabindex='-1'></div><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_17' id='gform_17' action='/knowledgebase/export-excel-advanced-search/#gf_17'> <div class='gform_body'><ul id='gform_fields_17' class='gform_fields top_label form_sublabel_below description_below'><li id='field_17_6' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_6' id='input_17_6' type='hidden' class='gform_hidden' aria-invalid="false" value='https://app-3QNL6WU154.marketingautomation.services/webforms/receivePostback/MzawMDG3NDO0AAA/' /></li><li id='field_17_7' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_7' id='input_17_7' type='hidden' class='gform_hidden' aria-invalid="false" value='0994ba05-06b3-460d-b11c-4f3b11093ec9' /></li><li id='field_17_8' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_8' id='input_17_8' type='hidden' class='gform_hidden' aria-invalid="false" value='POSIM' /></li><li id='field_17_11' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_11' >First<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_11' id='input_17_11' type='text' value='' class='large' tabindex='88' placeholder='First Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_10' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_10' >Last<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_10' id='input_17_10' type='text' value='' class='large' tabindex='89' placeholder='Last Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_2' class='gfield posim-email gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_2' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_17_2' type='text' value='' class='large' tabindex='90' placeholder='Email' aria-required="true" aria-invalid="false" /> </div></li><li id='field_17_3' class='gfield posim-phone gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_3' >Phone<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_phone'><input name='input_3' id='input_17_3' type='text' value='' class='large' tabindex='91' placeholder='Phone' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_5' class='gfield posim-industry gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_5' >Your Industry<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_select'><select name='input_5' id='input_17_5' class='large gfield_select' tabindex='92' aria-required="true" aria-invalid="false"><option value='' selected='selected' class='gf_placeholder'>Your Industry</option><option value='Apparel' >Apparel</option><option value='Hobby' >Hobby</option><option value='Household' >Household</option><option value='Liquor_Wine_Beer' >Liquor, Wine &amp; Beer</option><option value='Needlearts' >Needlearts</option><option value='Quilt_Fabric_Sewing' >Quilt, Fabric &amp; Sewing</option><option value='Outdoor' >Outdoor</option><option value='Other' >Other</option></select></div></li><li id='field_17_9' class='gfield field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_9' >CAPTCHA</label><div id='input_17_9' class='ginput_container ginput_recaptcha' data-sitekey='6LcWicwZAAAAAF6_JZFIf_bEpNSyHe5AsCdrkgmD' data-theme='light' data-tabindex='-1' data-size='invisible' data-badge='bottomright'></div></li><li id='field_17_12' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_17_12' >Comments</label><div class='ginput_container'><input name='input_12' id='input_17_12' type='text' value='' /></div><div class='gfield_description' id='gfield_description_17_12'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type="submit" id="gform_submit_button_17" class="gform_button button om-trigger-conversion" value="Request My Consultation" tabindex="93" onclick='if(window["gf_submitting_17"]){return false;} window["gf_submitting_17"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_17"]){return false;} window["gf_submitting_17"]=true; jQuery("#gform_17").trigger("submit",[true]); }'> <input type='hidden' name='gform_ajax' value='form_id=17&amp;title=&amp;description=&amp;tabindex=88' /> <input type='hidden' class='gform_hidden' name='is_submit_17' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='17' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_17' value='WyJbXSIsIjFmYmJkMmM5NDAyMGYzNTJmZGM3MmU0ODNlNDM2YjBmIl0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_17' id='gform_target_page_number_17' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_17' id='gform_source_page_number_17' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div> <iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_17' id='gform_ajax_frame_17' title='This iframe contains the logic required to handle Ajax powered Gravity Forms.'></iframe> <script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 17, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_17').on('load',function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_17');var is_confirmation = jQuery(this).contents().find('#gform_confirmation_wrapper_17').length > 0;var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = form_content.length > 0 && ! is_redirect && ! is_confirmation;var mt = parseInt(jQuery('html').css('margin-top'), 10) + parseInt(jQuery('body').css('margin-top'), 10) + 100;if(is_form){jQuery('#gform_wrapper_17').html(form_content.html());if(form_content.hasClass('gform_validation_error')){jQuery('#gform_wrapper_17').addClass('gform_validation_error');} else {jQuery('#gform_wrapper_17').removeClass('gform_validation_error');}setTimeout( function() { /* delay the scroll by 50 milliseconds to fix a bug in chrome */ jQuery(document).scrollTop(jQuery('#gform_wrapper_17').offset().top - mt); }, 50 );if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_17').val();gformInitSpinner( 17, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [17, current_page]);window['gf_submitting_17'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('.GF_AJAX_POSTBACK').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_17').replaceWith(confirmation_content);jQuery(document).scrollTop(jQuery('#gf_17').offset().top - mt);jQuery(document).trigger('gform_confirmation_loaded', [17]);window['gf_submitting_17'] = false;}, 50);}else{jQuery('#gform_17').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [17, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 17) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }jQuery('#input_17_3').mask('(999) 999-9999').bind('keypress', function(e){if(e.which == 13){jQuery(this).blur();} } );} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [17, 1]) } ); </script>