When dealing with large dataset (i.e., datasets with more than 10,000 rows), uploading and transferring data may be a challenge in [[Google Sheets]], since you cannot copy that much data to the clipboard.
To upload data, use the File > Import feature to load data from a CSV or other source.
To transfer data between sheets, use `IMPORTRANGE` to import the data first, and then copy and paste values within the same sheet (wait for the blue dashed outline around the data range before pasting, this may take a few seconds to appear depending on the size of the dataset). This avoids copying the data to your operating system's clipboard as Google Sheets handles the copy/paste functionality for data in the same sheet. However, you'll notice that you cannot copy/paste from one sheet to another sheet with sufficiently large datasets.