Open up any Google sheet that you have worked with today. We are going to look at the options for how to move data in and out of sheets.
File Formats:
XLS/XLSX are Microsoft Excel spreadsheets and are editable by almost any program that can utilise a spreadsheet.
CSV (Comma Separated Values) is a very common data interchange format for sheet data. This is what you will get from most websites that dump data that you need to process.
To Import:
FILE >> "Import" will allow you to bring data into Sheets from Excel, from a CSV file, and a few other sources.
To Export:
FILE >> "Download As" lets you export your sheet in a number of formats for export to Excel or even as a PDF report.