{"id":25515,"date":"2021-03-05T02:23:00","date_gmt":"2021-03-05T01:23:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=25515"},"modified":"2021-03-05T02:23:00","modified_gmt":"2021-03-05T01:23:00","slug":"anexar-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/how-to-solve-with-sheetgo\/append-excel\/","title":{"rendered":"Como anexar dados do Excel e registrar valores hist\u00f3ricos"},"content":{"rendered":"

[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][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″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]Many of us collect and analyze dynamic data that changes on a regular basis. If you work in spreadsheets, there are multiple ways of importing data into your files. Thanks to the power of the cloud, you can now pull live data from another online Excel file<\/a> or from Google Sheets<\/a> directly into an Excel workbook.<\/p>\n

You can even import real-time data into your spreadsheets from websites and online databases using functions such as IMPORTHTML<\/a>. If you deal with stocks and shares, both Excel and Google Sheets also have handy formulas that allow you to import stock market data<\/a> into your spreadsheet.<\/p>\n

Having “live” spreadsheets is fantastic, but what if you want to keep a historical record of previous data entries? There’s no inbuilt spreadsheet function that allows you to capture and save cell values for future reference.<\/p>\n

Saving different versions of a file at regular intervals is one option, but that’s extremely time-consuming and you will quickly generate a confusing number of spreadsheets.[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ use_custom_gutter=”on” make_equal=”on” _builder_version=”4.24.1″ _module_preset=”default” background_color=”#d3e3ff” custom_margin=”40px||40px||true|false” custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_module=”44972″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.23.1″ _module_preset=”default” positioning=”none” vertical_offset=”-44px” custom_css_main_element=”margin:auto;” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” header_font_size=”33px” header_4_text_color=”#071623″ header_4_font_size=”24px” header_4_line_height=”1.4em” background_color=”RGBA(255,255,255,0)” custom_margin=”0px|0px|0px|0px|true|true” custom_padding=”0px|0px|0px|0px|true|true” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Ready to streamline<\/span> your data?<\/span><\/h4>\n

[\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.23.1″ _module_preset=”default” custom_css_main_element=”margin:auto;” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”center” _builder_version=”4.23.1″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/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″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Save historical data entries in Excel<\/h4>\n

A better alternative is to append<\/strong> Excel data to another sheet at regular intervals, generating a historical log of data.<\/p>\n

This allows you to:<\/p>\n