Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Batch Data Import to Google Sheets

  1. #1
    New Member
    Join Date
    Oct 2017
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Batch Data Import to Google Sheets

    Hi,

    Thank you very much for taking out time and trying to help me out. Here is what I am stuck with :

    1. I have a list of around 4000 companies
    2. Each of those companies have three financial statements (two of them enclosed for reference)
    3. Therefore I have around 12000 sheets to work with
    4. Each of these sheets update every 3 months, but only the data changes. Headings and Column 1 does not change. Nor does the number of fields.
    5. I need to upload these to Google Sheets every 3 months.
    6. Another master Google Sheet references data from these 12000 sheets.
    7. Therefore, the cell data can change, but not the references.

    Here is what I have figured out :


    1. Manually upload each of these 12000 sheets to Google sheets using the Import option.
    2. Every 3 months, repeat the action using the "replace sheet"option. This leaves the sheet URL unchanged, which is required for referencing data on another Master sheet using the IMPORTRANGE function.
    This is a tedious process.

    Is there any way I could

    1. merge 3 sheets for the same company in a batch operation so that I need to upload only 4000 times ? OR
    2. Auto import the data if I replace the existing files in my hard drive with the newly downloaded files ? The filenames will be exactly the same OR
    3. The simplest option would be to import data directly from a page like this. I am unable to do it.

    The whole idea is to automate this tedious process to the largest extent possible. Request your suggestions and advice please.

    P.S. I am a basic excel user and have no coding knowledge.

    best,
    Somnath.

  2. #2
    New Member
    Join Date
    Oct 2017
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Batch Data Import to Google Sheets


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •