There are many work-based scenarios where you\u2019d want to import your CSV file into Google Sheets. For example, let\u2019s say you have a set of data relating to products that various departments need to access for their own operations.<\/p>\n
Some of these departments may not even have experience in working with CSV files. Moreover, Google Sheets offers more features that you can take advantage of in your operations. Let\u2019s take a look at these benefits in more detail.<\/p>\n
[\/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″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” 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_video src=”https:\/\/www.youtube.com\/watch?v=NsfbOolr-S0″ _builder_version=”4.23.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_video][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” background_color=”#f6f8f9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to import CSV to Google Sheets automatically<\/h3>\n\n- Why import CSV to Google Sheets?
\n<\/a><\/li>\n- How to import CSV to Google Sheets automatically
\n<\/a><\/li>\n- Connecting CSV files to Google Sheets
\n<\/a><\/li>\n- Looking to convert Excel to Google Sheets?<\/a><\/li>\n<\/ol>\n
[\/et_pb_text][et_pb_text module_id=”Why-import-CSV-to-Google Sheets” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Why import CSV to Google Sheets?<\/h2>\n
CSV (Comma Separated Values) files are tabular files with a very basic format used to store raw data or move it between software programs. Although it\u2019s great for general storage, it lacks the features you might need to effectively analyze, process, and share that data. Features that Google Sheets has.<\/p>\n
Here are just a few of the advantages of importing CSV to Google Sheets:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
\n- Access to analytical features:<\/b> Google Sheets has a variety of analytical features from graphs to formulas that you can use to calculate specific insights or visual represent your data.<\/li>\n
- Remote collaboration:<\/b> Google Sheets allows multiple team members to work together on a single file at the same time. What\u2019s more, you can do this anywhere at any time – you don\u2019t even need to have internet access!<\/li>\n
- Sharing ability:<\/b> Google Sheets has multiple sharing options and integrations so that you can send over files to others in a matter of seconds.<\/li>\n
[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
There are many work-based scenarios where you\u2019d want to import your CSV file into Google Sheets to make the most of these benefits. For example, let\u2019s say you have a set of data relating to products that various departments need to access for their own operations.<\/p>\n
Firstly, some of these departments may not even have experience in working with CSV files. Moreover, each department could work on the spreadsheet at the same time for ultimate productivity.<\/p>\n
Importing CSV to Google Sheets automatically<\/strong> through Sheetgo offers even more advantages for your operations. Not only are you saving the time it would take to manually import CSV files, but you are also creating connections that will sync changes made to the CSV file with the Google Sheets file.<\/p>\nThis means that any changes to the original data will be automatically updated in your new file, so you and your team always receive the latest accurate insights.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”How-to-import-CSV-to-Google-Sheets-automatically” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to import CSV to Google Sheets automatically<\/h2>\n
Now that we understand the various benefits of importing these files, let\u2019s go through a step by step on how to automatically import CSV to Google Sheets using the Sheetgo web app.<\/p>\n
For this example, I have a CSV file on product inventory data that I need to import into Google Sheets to share with the Sales department.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-1-1.png” alt=”import csv to google sheets 1″ title_text=”import csv to google sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Import CSV to Google Sheets<\/h3>\nStep 1: Sign in on the Sheetgo web app<\/h4>\n
Click the blue button below to open the Sheetgo web app and sign in with either your Google, Dropbox, or Microsoft account.[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SIGN UP FOR FREE” button_alignment=”center” _builder_version=”4.22.2″ _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=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” global_module=”44753″ saved_tabs=”all” 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_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Upload your CSV files to the cloud<\/h4>\n
To create an automated connection, your CSV files must be stored online in one of the main cloud storage platforms.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ background_color=”#e4f4f9″ custom_padding=”20px|20px|20px|20px|true|true” border_color_all=”#6ae8ff” border_width_left=”5px” border_color_left=”#00b6ff” global_module=”26467″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Are your files stored on your computer?<\/h3>\n
If you want to connect files that are stored locally (on your computer) you can set up an automated system to back up and sync files from your desktop to your online cloud storage service.<\/p>\n
This enables you to create automated data flows using Sheetgo. It also keeps your files secure and allows you to access them from anywhere. Learn more<\/a>.<\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 3: Create a new workflow<\/h4>\n
With the the Sheetgo web app open, select Create workflow<\/b>. Make sure you label your new workflow clearly.<\/p>\n
To start the importing process, click Connect files<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-2.png” alt=”import csv to google sheets 2″ title_text=”import csv to google sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Locate your CSV file<\/h4>\n
It\u2019s time to locate your CSV file in your storage solution (Google Drive, OneDrive, Sharepoint, or Dropbox).<\/p>\n
Under Select source data<\/b>, you can choose whether to import a single file or multiple files from your computer.<\/p>\n
In this example, I will choose a single file. Then, press Select file<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-3.png” alt=”import csv to google sheets 3″ title_text=”import csv to google sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]To upload a file from your computer once (manually), select the Upload file<\/b> button located just under the search bar and choose your file. It should now appear in the list of files below.<\/p>\n
Once you have selected the file, press Continue<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-4.png” alt=”import csv to google sheets 4″ title_text=”import csv to google sheets 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ make_equal=”on” custom_padding_last_edited=”on|phone” _builder_version=”4.23.1″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”50px|30px|50px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44982″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.23.1″ _module_preset=”default” custom_padding=”50px||50px||true|false” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_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_text _builder_version=”4.24.1″ _module_preset=”default” text_font=”|800|||||||” text_text_color=”#071623″ text_font_size=”28px” text_line_height=”1.2em” header_font=”|700|||||||” header_text_color=”#0a0000″ header_font_size=”35px” header_line_height=”1.2em” header_4_font=”|700|||||||” header_4_font_size=”22px” header_4_line_height=”1.2em” custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|desktop” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\nConnect<\/span>\u00a0your spreadsheets to your data sources<\/span><\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _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=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” 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.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 5: Connect to a new spreadsheet<\/h4>\n
Now we must import the CSV file to Google Sheets.<\/p>\n
Under the \u2018Send to\u2019 section, click A single file<\/b> to import your data into a single spreadsheet.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-5.png” alt=”import csv to google sheets 5″ title_text=”import csv to google sheets 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You can adjust the settings here to suit your needs. Either choose to upload your data to a new or existing file, and name your spreadsheet. Just make sure that the Google Sheets option is highlighted under the File type<\/b> section.<\/p>\n
Once completed, click Finish and save<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-6.png” alt=”import csv to google sheets 6″ title_text=”import csv to google sheets 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 6: Enjoy your new Google Sheets file!<\/h4>\n
You should now have a new Google Sheets file with all of your imported CSV data!<\/p>\n
Whenever you make changes to the original CSV file, Sheetgo will automatically update your new spreadsheet. So you\u2019ll have all the latest data insights to work from.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-7.png” alt=”import csv to google sheets 7″ title_text=”import csv to google sheets 7″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”Connecting-CSV-files-to-Google-Sheets” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connecting CSV files to Google Sheets<\/h3>\n
And there you have it! With the Sheetgo web app, you have the opportunity to import multiple CSV files to Google Sheets in just a few clicks of a button.<\/p>\n
This gives you the flexibility to consolidate multiple datasets in just one location, or even create multiple files that you can send to various members of your organization.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”Looking-to-convert-Excel-to-Google-Sheets” _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Looking to convert Excel to Google Sheets?<\/h3>\n
Are you interested in importing your Excel files to Google Sheets automatically too? Take a look at our blog post on How to convert Excel to Google Sheets automatically.<\/a><\/p>\nAlternatively, discover more of our articles on How to solve with Sheetgo below!<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.24.1″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44987″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” header_4_font=”|700|||||||” header_4_text_color=”#071623″ header_4_font_size=”22px” header_4_line_height=”1.4em” custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _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=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Cloud-based spreadsheet tools like Google Sheets have completely transformed the way we can work with data. From real-time collaboration to extensive sharing capabilities, it makes sense why you\u2019d want to import your CSV files to a place like Google Sheets for more flexibility. However, manually transferring your CSV files to Google Sheets can take up […]<\/p>\n","protected":false},"author":40,"featured_media":42079,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"
Spreadsheets of today are built with a prime purpose - location independent collaboration. And,\u00a0Google Sheets<\/a>\u00a0has been leading this innovative front. We can store these spreadsheets online and manage\u00a0them across the team using\u00a0appropriate access controls. While they have covered a lot of ground with these advancements, not everything is hassle-free yet. For instance there isn't an easy approach to automatically import CSV data to Google Sheets.<\/span><\/p>Why import from CSV to Google Sheets?<\/h3>
Grace is a sports analyst and her job requires her to gather insights from data sets. She travels a lot to gather data on the field. Due to the nature of her job, she needs to use different devices to collect data while on the run. Sometimes an iPad. At times, her Thinkpad. And, once she is done with field work, she uses a heavy-duty desktop at her office. Given the convenience of accessibility from anywhere and any device, she uses Google Sheets to store her data.<\/span><\/p>However, she has associates who extensively work on statistical software tools like Matlab and R. These statisticians, for the interest of other technically less advanced employees, share the outputs from these tools in a CSV or TSV file format. Grace usually receives individual data sets from them, and she strings the pieces together. To date, their approach has been the following:<\/span><\/p>- The associates send CSV files over email.<\/span><\/li>
- Grace downloads them onto her computer.<\/span><\/li>
- Imports the downloaded CSV spreadsheets to her Google Sheets.<\/span><\/li><\/ul>
That is certainly a time taking process (accounting for possible communication delays), and needs manual intervention every time. Therefore, with lot of other important things going on, she'd rather prefer not worrying about repeating this process day-in day-out. But, how can she accomplish that?<\/span><\/p>Solution: Automate the CSV data import with Sheetgo<\/h3>
For this use case, the configuration is going to be a simple two-step procedure.<\/span><\/p>- Install Google Drive<\/a>\u00a0and store the CSV file on the Google Drive.<\/span><\/li>
- Create a connection between the uploaded CSV file and Google Sheets file, using Sheetgo add-on.<\/span><\/li><\/ol>
[panel type=\"default\"] Configuration process<\/strong><\/span><\/p>![\"Automatically](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/07\/Automatically-Import-CSV-Data-Illustration-1.png\")
<\/p>
[\/panel]<\/span><\/p>While, the first step obviates the need for the associates sending CSV files through emails, it is a\u00a0must that we have the file on our Google Drive with read access permissions. The second step automates the downloading and importing rituals that Grace regularly does.<\/span><\/p>I. Upload CSV file to Google Drive<\/h4>
David is Grace's associate. He just got an important data set ready to share with Grace, who will plug this alongside her existing data. Here's how the CSV file looks like.<\/span><\/p>[panel type=\"default\"] Example CSV File<\/strong><\/span><\/p>![\"Automatically](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/automatically1.png\")
<\/p>
[\/panel]<\/span><\/p>Upload approach<\/em><\/h4>We can upload this to Google Drive with the help of\u00a0Google Drive software<\/a> on PC\/Mac. If we do not have this installed, we can download the software from here<\/a> and install.<\/span><\/p>Now, going back to our example, all that David has to do is drop the above mentioned CSV file onto the Google Drive folder on his computer!\u00a0And, David can grant Grace access to this file by doing this:\u00a0Right click on the file name > <\/strong>Choose 'Google Drive' > <\/strong>Click 'Share'<\/strong>.\u00a0<\/span><\/p>On the resulting pop-up window, key in Grace's email and hit the 'Send<\/strong>' button.\u00a0<\/span><\/p>[panel type=\"default\"] Example<\/strong><\/span><\/p>![\"Automatically](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/automatically2.png\")
<\/p>
[\/panel]<\/span><\/p>II. Create a connection using Sheetgo add-on and automatically import CSV data.<\/h4>
Now that Grace has all the dependent tasks done, she will go through the following sequence of steps to establish a connection and automatically import CSV data that David shared.\u00a0<\/span><\/p>- Open the Google Sheets file that we want to import data to.<\/span><\/li>
- If the Sheetgo add-on isn't installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application. [panel][ccj id=\"Install Widget\"][\/panel]<\/span><\/li>
- Go to menu Add-ons<\/strong> > Sheetgo<\/strong>\u00a0>\u00a0Start<\/strong>.<\/span><\/li>
- Click on the green +<\/strong> button and select the \"Import data<\/strong>\" option<\/span><\/li>
- Choose \"Connect<\/strong>\".<\/span><\/li>
- Find and select the required CSV file from our Google Drive.\u00a0<\/span><\/li>
- We may choose to adjust the frequency settings (in the Automatic update<\/strong> section) to automate the import on a scheduled basis, but for now we leave it as is.<\/span><\/li>
- Finally, we click on the \"Connect<\/strong>\" button.<\/span><\/li><\/ol>
[panel type=\"default\"] Sheetgo will now\u00a0<\/strong>automatically import CSV data to Google Sheets<\/b><\/span><\/p>![\"Automatically](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2017\/11\/automatically3.png\")
<\/p>
[\/panel]<\/span><\/p>The data import keeps happening automatically and periodically\u00a0once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic update altogether. Shown below is how we navigate to the corresponding settings pane.<\/span><\/p>Connection name\u00a0<\/strong>(in this case \u201cSG_Major League Ball Players.csv\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update > edit<\/strong>.<\/span><\/p>Click on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.<\/span><\/p>Keeping the connection active<\/h3>
We have accomplished the automation all the way from CSV file upload to Google Sheet importing data using Sheetgo add-on (please see the first snapshot). But, how do we make sure Sheetgo always fetches current information? It is very simple! If David needs to make any changes to the file, he can open the corresponding file directly from the Google Drive folder on his computer and proceed. Once done, he can save the file in the same folder.\u00a0Doing this will ensure the changes get synchronized with the Google Drive. And therefore, the existing Sheetgo connection will automatically import CSV data which is the latest.<\/span><\/p>
Icons made by Vectors Market<\/a> from www.flaticon.com<\/a> is licensed by CC 3.0 BY<\/a><\/em><\/span><\/div>","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-3967","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=3967"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3967\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42079"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=3967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=3967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=3967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n
- Why import CSV to Google Sheets?
\n<\/a><\/li>\n- How to import CSV to Google Sheets automatically
\n<\/a><\/li>\n- Connecting CSV files to Google Sheets
\n<\/a><\/li>\n- Looking to convert Excel to Google Sheets?<\/a><\/li>\n<\/ol>\n
[\/et_pb_text][et_pb_text module_id=”Why-import-CSV-to-Google Sheets” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Why import CSV to Google Sheets?<\/h2>\n
CSV (Comma Separated Values) files are tabular files with a very basic format used to store raw data or move it between software programs. Although it\u2019s great for general storage, it lacks the features you might need to effectively analyze, process, and share that data. Features that Google Sheets has.<\/p>\n
Here are just a few of the advantages of importing CSV to Google Sheets:<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
- \n
- Access to analytical features:<\/b> Google Sheets has a variety of analytical features from graphs to formulas that you can use to calculate specific insights or visual represent your data.<\/li>\n
- Remote collaboration:<\/b> Google Sheets allows multiple team members to work together on a single file at the same time. What\u2019s more, you can do this anywhere at any time – you don\u2019t even need to have internet access!<\/li>\n
- Sharing ability:<\/b> Google Sheets has multiple sharing options and integrations so that you can send over files to others in a matter of seconds.<\/li>\n
[\/et_pb_text][et_pb_text _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
There are many work-based scenarios where you\u2019d want to import your CSV file into Google Sheets to make the most of these benefits. For example, let\u2019s say you have a set of data relating to products that various departments need to access for their own operations.<\/p>\n
Firstly, some of these departments may not even have experience in working with CSV files. Moreover, each department could work on the spreadsheet at the same time for ultimate productivity.<\/p>\n
Importing CSV to Google Sheets automatically<\/strong> through Sheetgo offers even more advantages for your operations. Not only are you saving the time it would take to manually import CSV files, but you are also creating connections that will sync changes made to the CSV file with the Google Sheets file.<\/p>\n
This means that any changes to the original data will be automatically updated in your new file, so you and your team always receive the latest accurate insights.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”How-to-import-CSV-to-Google-Sheets-automatically” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
How to import CSV to Google Sheets automatically<\/h2>\n
Now that we understand the various benefits of importing these files, let\u2019s go through a step by step on how to automatically import CSV to Google Sheets using the Sheetgo web app.<\/p>\n
For this example, I have a CSV file on product inventory data that I need to import into Google Sheets to share with the Sales department.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-1-1.png” alt=”import csv to google sheets 1″ title_text=”import csv to google sheets 1″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Import CSV to Google Sheets<\/h3>\n
Step 1: Sign in on the Sheetgo web app<\/h4>\n
Click the blue button below to open the Sheetgo web app and sign in with either your Google, Dropbox, or Microsoft account.[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”SIGN UP FOR FREE” button_alignment=”center” _builder_version=”4.22.2″ _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=”30px||30px||true|false” custom_padding=”15px|20px|15px|20px|true|true” global_module=”44753″ saved_tabs=”all” 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_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 2: Upload your CSV files to the cloud<\/h4>\n
To create an automated connection, your CSV files must be stored online in one of the main cloud storage platforms.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.27.2″ background_color=”#e4f4f9″ custom_padding=”20px|20px|20px|20px|true|true” border_color_all=”#6ae8ff” border_width_left=”5px” border_color_left=”#00b6ff” global_module=”26467″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Are your files stored on your computer?<\/h3>\n
If you want to connect files that are stored locally (on your computer) you can set up an automated system to back up and sync files from your desktop to your online cloud storage service.<\/p>\n
This enables you to create automated data flows using Sheetgo. It also keeps your files secure and allows you to access them from anywhere. Learn more<\/a>.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 3: Create a new workflow<\/h4>\n
With the the Sheetgo web app open, select Create workflow<\/b>. Make sure you label your new workflow clearly.<\/p>\n
To start the importing process, click Connect files<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-2.png” alt=”import csv to google sheets 2″ title_text=”import csv to google sheets 2″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 4: Locate your CSV file<\/h4>\n
It\u2019s time to locate your CSV file in your storage solution (Google Drive, OneDrive, Sharepoint, or Dropbox).<\/p>\n
Under Select source data<\/b>, you can choose whether to import a single file or multiple files from your computer.<\/p>\n
In this example, I will choose a single file. Then, press Select file<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-3.png” alt=”import csv to google sheets 3″ title_text=”import csv to google sheets 3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]To upload a file from your computer once (manually), select the Upload file<\/b> button located just under the search bar and choose your file. It should now appear in the list of files below.<\/p>\n
Once you have selected the file, press Continue<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-4.png” alt=”import csv to google sheets 4″ title_text=”import csv to google sheets 4″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ make_equal=”on” custom_padding_last_edited=”on|phone” _builder_version=”4.23.1″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”50px|30px|50px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44982″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.23.1″ _module_preset=”default” custom_padding=”50px||50px||true|false” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_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_text _builder_version=”4.24.1″ _module_preset=”default” text_font=”|800|||||||” text_text_color=”#071623″ text_font_size=”28px” text_line_height=”1.2em” header_font=”|700|||||||” header_text_color=”#0a0000″ header_font_size=”35px” header_line_height=”1.2em” header_4_font=”|700|||||||” header_4_font_size=”22px” header_4_line_height=”1.2em” custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|desktop” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect<\/span>\u00a0your spreadsheets to your data sources<\/span><\/h4>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _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=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” 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.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 5: Connect to a new spreadsheet<\/h4>\n
Now we must import the CSV file to Google Sheets.<\/p>\n
Under the \u2018Send to\u2019 section, click A single file<\/b> to import your data into a single spreadsheet.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-5.png” alt=”import csv to google sheets 5″ title_text=”import csv to google sheets 5″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You can adjust the settings here to suit your needs. Either choose to upload your data to a new or existing file, and name your spreadsheet. Just make sure that the Google Sheets option is highlighted under the File type<\/b> section.<\/p>\n
Once completed, click Finish and save<\/b>.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-6.png” alt=”import csv to google sheets 6″ title_text=”import csv to google sheets 6″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Step 6: Enjoy your new Google Sheets file!<\/h4>\n
You should now have a new Google Sheets file with all of your imported CSV data!<\/p>\n
Whenever you make changes to the original CSV file, Sheetgo will automatically update your new spreadsheet. So you\u2019ll have all the latest data insights to work from.<\/p>\n
[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/10\/import-csv-to-google-sheets-7.png” alt=”import csv to google sheets 7″ title_text=”import csv to google sheets 7″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”Connecting-CSV-files-to-Google-Sheets” _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connecting CSV files to Google Sheets<\/h3>\n
And there you have it! With the Sheetgo web app, you have the opportunity to import multiple CSV files to Google Sheets in just a few clicks of a button.<\/p>\n
This gives you the flexibility to consolidate multiple datasets in just one location, or even create multiple files that you can send to various members of your organization.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”Looking-to-convert-Excel-to-Google-Sheets” _builder_version=”4.27.2″ _module_preset=”default” hover_enabled=”0″ global_colors_info=”{}” theme_builder_area=”post_content” sticky_enabled=”0″]<\/p>\n
Looking to convert Excel to Google Sheets?<\/h3>\n
Are you interested in importing your Excel files to Google Sheets automatically too? Take a look at our blog post on How to convert Excel to Google Sheets automatically.<\/a><\/p>\n
Alternatively, discover more of our articles on How to solve with Sheetgo below!<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.22.2″ background_color=”#f9f9ff” custom_margin=”40px||40px||false|false” custom_padding=”15px|25px|15px|25px|true|true” border_width_left=”3px” border_color_left=”#808e95″ global_module=”26540″ saved_tabs=”all” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n
[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”2_5,3_5″ custom_padding_last_edited=”on|phone” _builder_version=”4.24.1″ _module_preset=”default” background_image=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2023\/10\/background-connection-all-left.png” custom_margin=”30px||30px||true|false” custom_padding=”30px|30px|30px|30px|true|true” custom_padding_tablet=”20px||||false|true” custom_padding_phone=”30px||||false|true” background_color_phone=”#f6f8f9″ background_last_edited=”on|tablet” background_enable_color_phone=”on” background_enable_image_phone=”off” background_size_tablet=”cover” border_radii=”on|12px|12px|12px|12px” global_module=”44987″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_column][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” header_4_font=”|700|||||||” header_4_text_color=”#071623″ header_4_font_size=”22px” header_4_line_height=”1.4em” custom_margin=”0px||0px||true|false” custom_padding=”0px||0px||true|false” custom_padding_tablet=”|||200px|false|false” custom_padding_phone=”|||0px|false|false” custom_padding_last_edited=”on|phone” text_orientation_tablet=”right” text_orientation_phone=”center” text_orientation_last_edited=”on|tablet” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Connect everything and automate<\/span> entire business processes<\/h4>\n
[\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/” url_new_window=”on” button_text=”START NOW” button_alignment=”left” button_alignment_tablet=”right” button_alignment_phone=”center” button_alignment_last_edited=”on|phone” _builder_version=”4.22.2″ _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=”20px||0px||false|false” custom_padding=”15px|20px|15px|20px|true|true” global_colors_info=”{}” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_color__hover_enabled=”on|hover” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Cloud-based spreadsheet tools like Google Sheets have completely transformed the way we can work with data. From real-time collaboration to extensive sharing capabilities, it makes sense why you\u2019d want to import your CSV files to a place like Google Sheets for more flexibility. However, manually transferring your CSV files to Google Sheets can take up […]<\/p>\n","protected":false},"author":40,"featured_media":42079,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"
Spreadsheets of today are built with a prime purpose - location independent collaboration. And,\u00a0Google Sheets<\/a>\u00a0has been leading this innovative front. We can store these spreadsheets online and manage\u00a0them across the team using\u00a0appropriate access controls. While they have covered a lot of ground with these advancements, not everything is hassle-free yet. For instance there isn't an easy approach to automatically import CSV data to Google Sheets.<\/span><\/p>
Why import from CSV to Google Sheets?<\/h3>
Grace is a sports analyst and her job requires her to gather insights from data sets. She travels a lot to gather data on the field. Due to the nature of her job, she needs to use different devices to collect data while on the run. Sometimes an iPad. At times, her Thinkpad. And, once she is done with field work, she uses a heavy-duty desktop at her office. Given the convenience of accessibility from anywhere and any device, she uses Google Sheets to store her data.<\/span><\/p>
However, she has associates who extensively work on statistical software tools like Matlab and R. These statisticians, for the interest of other technically less advanced employees, share the outputs from these tools in a CSV or TSV file format. Grace usually receives individual data sets from them, and she strings the pieces together. To date, their approach has been the following:<\/span><\/p>
- The associates send CSV files over email.<\/span><\/li>
- Grace downloads them onto her computer.<\/span><\/li>
- Imports the downloaded CSV spreadsheets to her Google Sheets.<\/span><\/li><\/ul>
That is certainly a time taking process (accounting for possible communication delays), and needs manual intervention every time. Therefore, with lot of other important things going on, she'd rather prefer not worrying about repeating this process day-in day-out. But, how can she accomplish that?<\/span><\/p>
Solution: Automate the CSV data import with Sheetgo<\/h3>
For this use case, the configuration is going to be a simple two-step procedure.<\/span><\/p>
- Install Google Drive<\/a>\u00a0and store the CSV file on the Google Drive.<\/span><\/li>
- Create a connection between the uploaded CSV file and Google Sheets file, using Sheetgo add-on.<\/span><\/li><\/ol>
[panel type=\"default\"] Configuration process<\/strong><\/span><\/p>
<\/p>[\/panel]<\/span><\/p>
While, the first step obviates the need for the associates sending CSV files through emails, it is a\u00a0must that we have the file on our Google Drive with read access permissions. The second step automates the downloading and importing rituals that Grace regularly does.<\/span><\/p>
I. Upload CSV file to Google Drive<\/h4>
David is Grace's associate. He just got an important data set ready to share with Grace, who will plug this alongside her existing data. Here's how the CSV file looks like.<\/span><\/p>
[panel type=\"default\"] Example CSV File<\/strong><\/span><\/p>
<\/p>[\/panel]<\/span><\/p>
Upload approach<\/em><\/h4>
We can upload this to Google Drive with the help of\u00a0Google Drive software<\/a> on PC\/Mac. If we do not have this installed, we can download the software from here<\/a> and install.<\/span><\/p>
Now, going back to our example, all that David has to do is drop the above mentioned CSV file onto the Google Drive folder on his computer!\u00a0And, David can grant Grace access to this file by doing this:\u00a0Right click on the file name > <\/strong>Choose 'Google Drive' > <\/strong>Click 'Share'<\/strong>.\u00a0<\/span><\/p>
On the resulting pop-up window, key in Grace's email and hit the 'Send<\/strong>' button.\u00a0<\/span><\/p>
[panel type=\"default\"] Example<\/strong><\/span><\/p>
<\/p>[\/panel]<\/span><\/p>
II. Create a connection using Sheetgo add-on and automatically import CSV data.<\/h4>
Now that Grace has all the dependent tasks done, she will go through the following sequence of steps to establish a connection and automatically import CSV data that David shared.\u00a0<\/span><\/p>
- Open the Google Sheets file that we want to import data to.<\/span><\/li>
- If the Sheetgo add-on isn't installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application. [panel][ccj id=\"Install Widget\"][\/panel]<\/span><\/li>
- Go to menu Add-ons<\/strong> > Sheetgo<\/strong>\u00a0>\u00a0Start<\/strong>.<\/span><\/li>
- Click on the green +<\/strong> button and select the \"Import data<\/strong>\" option<\/span><\/li>
- Choose \"Connect<\/strong>\".<\/span><\/li>
- Find and select the required CSV file from our Google Drive.\u00a0<\/span><\/li>
- We may choose to adjust the frequency settings (in the Automatic update<\/strong> section) to automate the import on a scheduled basis, but for now we leave it as is.<\/span><\/li>
- Finally, we click on the \"Connect<\/strong>\" button.<\/span><\/li><\/ol>
[panel type=\"default\"] Sheetgo will now\u00a0<\/strong>automatically import CSV data to Google Sheets<\/b><\/span><\/p>
<\/p>[\/panel]<\/span><\/p>
The data import keeps happening automatically and periodically\u00a0once the appropriate connection is in place. Please note that we can change the frequency with which these data imports happen or even turn off the automatic update altogether. Shown below is how we navigate to the corresponding settings pane.<\/span><\/p>
Connection name\u00a0<\/strong>(in this case \u201cSG_Major League Ball Players.csv\u201d)\u00a0> edit\u00a0<\/strong>(the pencil icon)\u00a0> Automatic update > edit<\/strong>.<\/span><\/p>
Click on the green slider button to turn the automatic update off. Instead, we can keep the automatic update active, and change the scheduling frequency and execution time as required. Once done, click OK<\/strong> and then on SAVE<\/strong> button.<\/span><\/p>
Keeping the connection active<\/h3>
We have accomplished the automation all the way from CSV file upload to Google Sheet importing data using Sheetgo add-on (please see the first snapshot). But, how do we make sure Sheetgo always fetches current information? It is very simple! If David needs to make any changes to the file, he can open the corresponding file directly from the Google Drive folder on his computer and proceed. Once done, he can save the file in the same folder.\u00a0Doing this will ensure the changes get synchronized with the Google Drive. And therefore, the existing Sheetgo connection will automatically import CSV data which is the latest.<\/span><\/p>
Icons made by Vectors Market<\/a> from www.flaticon.com<\/a> is licensed by CC 3.0 BY<\/a><\/em><\/span><\/div>","_et_gb_content_width":"","footnotes":""},"categories":[33],"tags":[43],"class_list":["post-3967","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-how-to-solve-with-sheetgo","tag-sheetgo"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=3967"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/3967\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/42079"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=3967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=3967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=3967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - If the Sheetgo add-on isn't installed already, we can click the button below to install Sheetgo\u00a0in our Google Sheets application. [panel][ccj id=\"Install Widget\"][\/panel]<\/span><\/li>
- Create a connection between the uploaded CSV file and Google Sheets file, using Sheetgo add-on.<\/span><\/li><\/ol>
- Grace downloads them onto her computer.<\/span><\/li>
- Remote collaboration:<\/b> Google Sheets allows multiple team members to work together on a single file at the same time. What\u2019s more, you can do this anywhere at any time – you don\u2019t even need to have internet access!<\/li>\n
- How to import CSV to Google Sheets automatically