[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ custom_padding=”54px|0px|2px|0px|false|false” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Spreadsheets have become an integral part of our lives. They have advanced so much over time that embracing them into our work makes more sense by the day.<\/span><\/p>\n Their evolution manifested them from standalone desktop applications to cloud-based applications that can be accessed from any location and device.<\/span><\/p>\n Google Sheets has been the front runner in this space. And true to its innovative spirit, it comes with many built-in features and functions that are very handy.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”importing” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n We will come across many situations where we may have to import data from other files. Google Sheets has a built-in formula that will help us accomplish this \u2013 IMPORTRANGE. While it serves its basic purpose, it is not as flexible and adaptive as we\u2019d like it to be.<\/span><\/p>\n To begin with, the formula isn\u2019t very user-friendly, especially for someone who is not as familiar with Google Sheets formulas. Also, if the source data range changes, we\u2019ll have to manually adjust the formula to ensure we are not missing any of the source data.<\/span><\/p>\n There is one other key aspect that this formula is missing: <\/span>you can\u2019t importrange with formatting<\/b>. It brings in only the source data and completely omits the source formatting. That probably works most of the time, but may not be the ideal scenario every time.<\/span><\/p>\n Sometimes, we may want to retain the source formatting. But unfortunately, the only way to achieve this in Google Sheets is to copy and paste formatting. The problem with this approach is that you have to do it with every new sheet.<\/span><\/p>\n As if that wasn\u2019t enough, chaining importrange functions is really unstable. When troubleshooting errors across multiple linked sheets it is really difficult to pinpoint the initial mistake.\u00a0<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”how” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sheetgo is built solely to take spreadsheet connectivity to the next level. Unlike formulas, this is a very handy, user-friendly and intuitive tool that doesn\u2019t require any advanced knowledge. Within a matter of a few seconds, we can accomplish actions such as importing, exporting, merging, appending and filtering data between multiple Google Sheets files.<\/span><\/p>\n Also, the multitude of configuration capabilities makes it even more customizable. We can configure the conditions, filters, enable transfer formatting, and the frequency with which the data transfer can happen. As one can imagine, all of this is very difficult to achieve using the existing Google Sheets tools.<\/span><\/p>\n We have the option to transfer formatting with both the Import and Export functions of the Sheetgo add-on. We\u2019ll illustrate this feature on the Import option, as it is very similar to the Export function as well. Install the Sheetgo add-on for Google Sheets by clicking the button below.<\/span><\/p>\n [\/et_pb_text][et_pb_text module_id=”step1″ _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n On the file that we want the data imported to, start the Sheetgo add-on by navigating to <\/span>Add-ons > Sheetgo > Start<\/b>. On the Sheetgo sidebar that opens up within the Google Sheets interface, hover the mouse onto the green \u2018+\u2019 button. We\u2019ll see the Import and Export options \u2013 click on the Import button to start creating the connection.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/03\/frame-_16.jpg” alt=”How to Transfer Formatted Google Sheets: Start Add on” title_text=”how-to-transfer-formatted-google-sheets-add-on” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”step2″ _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In the Data Source section, click <\/span>Select file(s)<\/b>. This lets us choose a file from Google Drive, or search for it if it isn\u2019t readily visible. Pick the appropriate file, and consequently choose the sheet within the selected file which we need the data imported from.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/03\/frame-_19.jpg” alt=”Transfer Formatted Google Sheets: Select Files” title_text=”transfer-formatted-google-sheets-select-files” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”step3″ _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Within the Settings section, we may choose to tinker with any of the configuration options available. However, we are particularly interested in the Transfer formatting (Google Sheets only) sub-section.<\/span><\/p>\n Turn on Enable transfer formatting<\/strong> to bring in source formatting along with the data. Please note that this feature works only with Google Sheets. Also, this may slow down the data transfer process a little bit.<\/span><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/03\/frame-_22.jpg” alt=”Enable Transfer Formatting in Google Sheets” title_text=”enable-transfer-formatting-google-sheets” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”step4″ _builder_version=”4.24.1″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once done with the Settings, we may now click <\/span>Save connection<\/b>. <\/span> [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/03\/frame-_21.jpg” alt=”Transfer Formatted Runtime Errors Example Date in Google Sheets” title_text=”transfer-format-runtime-errors” align=”center” align_tablet=”center” align_phone=”” align_last_edited=”on|desktop” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”transfer” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n And there you go! That is how you transfer formatted Google Sheets.<\/p>\n If you\u2019d like to learn more about data formats in Google Sheets, why not take a look at our Google Sheets data format guide<\/a>.<\/a><\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Spreadsheets have become an integral part of our lives. They have advanced so much over time that embracing them into our work makes more sense by the day. Their evolution manifested them from standalone desktop applications to cloud-based applications that can be accessed from any location and device. Google Sheets has been the front runner […]<\/p>\n","protected":false},"author":40,"featured_media":42198,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"\n Spreadsheets have become an integral part of our lives. They have advanced so much over time that embracing them into our work makes more sense by the day. Their evolution manifested them from standalone desktop applications to cloud-based applications that can be accessed from any location and device. Google Sheets has been the front runner in this space. And true to its innovative spirit, it ports with many built-in features and functions that are very handy.<\/p>\n\n\n\n We will come across many situations where we may have to import data from other files. Google Sheets has a built-in formula that will help us accomplish this - IMPORTRANGE. While it serves its basic purpose, it is not as flexible and adaptive as we'd like it to be. <\/p>\n\n\n\n To begin with, the formula isn't very user-friendly, especially for someone who is not as familiar with Google Sheets formulas. Also, if the source data range changes, we'll have to manually adjust the formula to ensure we are not missing any of the source data. There is one other key aspect that the IMPORTRANGE formula misses. It brings in only the source data and completely omits the source formatting. Probably that works most of the times, but may not be the ideal scenario every time. We may want to retain the source formatting in some of the cases probably to maintain consistency with the look and feel. And unfortunately, we can't achieve this with the tools that are already available within Google Sheets. <\/p>\n\n\n\n Sheetgo add-on is built for the sole purpose of taking the spreadsheet connectivity to the next level. Unlike the formulas, this is rather a very handy, user-friendly and intuitive tool that doesn't require any advanced knowledge. Within a matter of a few seconds, we can accomplish actions such as importing, exporting, merging, appending and filtering data between multiple Google Sheets files. Also, the multitude of configuration capabilities makes it even more customizable. We can configure the conditions, filters, enable transfer formatting, and the frequency with which the data transfer can happen. As one can imagine, all of this is very difficult to achieve using the existing Google Sheets tools. <\/p>\n\n\n\n We have the option to transfer formatting with both the Import and Export functions of the Sheetgo add-on. We'll illustrate this feature on the Import option, as it is very similar with the Export function as well. <\/p>\n\n\n\n On the file that we want the data imported to, start the Sheetgo add-on by navigating to Add-ons > Sheetgo > Start. On the Sheetgo sidebar that opens up within the Google Sheets interface, hover the mouse onto the green \u2018+\u2019 button. We\u2019ll see the Import and Export options - click on the Import button to start creating the connection. <\/p>\n\n\n\n In the Data Source section, click on the SELECT FILE(S) button. This lets us choose a file from Google Drive, or search for it if it isn't readily visible. Pick the appropriate file, and consequently choose the sheet within the selected file which we need the data imported from.<\/p>\n\n\n\n Within the Settings section, we may choose to tinker with any of the configuration options available. However we are particularly interested in the Transfer formatting (Google Sheets only) sub-section. Checking the Enable transfer formatting' box true will bring in source formatting along with the data. Please note that this feature works only with Google Sheets. Also, this may slow down the data transfer process a little bit.<\/p>\n\n\n\n Step 4:<\/p>\n\n\n\n Once done with the Settings, we may now click on the SAVE CONNECTION. Importing data using importrange<\/span><\/h2>\n
How to copy Google Sheets with formatting using the Sheetgo add-on<\/span><\/h2>\n
Step 1: Install sheetgo add-on<\/span><\/h3>\n
Step 2: Select files to connect<\/span><\/h3>\n
Step 3: Configure the connection<\/span><\/h3>\n
Step 4: Save connection<\/span><\/h3>\n
<\/span>Congratulations! We established a link that lets us import filtered and formatted data from the source Google Sheets file. We\u2019ll see this in the new sheet that Sheetgo would create for us in a few quick seconds.\u00a0<\/span><\/p>\nTransfer formatted Google Sheets<\/h3>\n
Importing data<\/h4>\n\n\n\n
Solution: Use Sheetgo add-on to import data along with formatting<\/h4>\n\n\n\n
Step 1:<\/h4>\n\n\n\n
Step 2:<\/h4>\n\n\n\n
Step 3:<\/h4>\n\n\n\n
Congratulations! We established a link that lets us import filtered and formatted data from the source Google Sheets file. We'll see this in the new sheet that Sheetgo would create for us in a few quick seconds. <\/p>\n\n\n\n