CSV Files in Google Sheets are a must know when working with large datasets
Copying and pasting massive datasets in Google Sheets may cause your spreadsheet to crash. This isn't a system problem, you just need to approach it differently. Instead, save the data as a CSV file then import the CSV file directly into Google Sheets. This will allow you to bring in large datasets without a problem.