Batch Data Import to Google Sheets

somnathbabu

New Member
Joined
Oct 3, 2017
Messages
3
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.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,213,530
Messages
6,114,162
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top