Yes, you can convert many different file types into Sheets format. The original file will remain intact.

With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people's changes as they make them, and every change is saved automatically. 

When it comes to Google Sheets, there is a Google Sheets cell limit your spreadsheet can contain only 10 million cells or 18,278 columns.

The IMPORT RANGE function can only import data from up to 50 different sheets. Formatting: It can't retain formatting, which means you may need to spend some time reformatting the data after it has been imported. 

To Perform data into columns, follow these steps:

1. Click on  Data and then Split the text to columns.

2. To change which character Sheets uses to split the data, next to "Separator" click the dropdown menu.

3. To fix how your columns spread out after you split your text, click the menu next to "Separator" and then Detect automatically.

To turn off pivot table suggestions:

1. At the top, click Tools  Autocomplete.

2. Turn off Enable Pivot table suggestions.

1. On your computer, open a spreadsheet in Google Sheets

2. Highlight the group of cells you'd like to sort.

3. If your sheet includes a header row, freeze the first row.

4. Click Data Sort range Advanced range sorting options.

5. If your columns have titles, click Data has header row.

6. Select the column you'd like to be sorted first and choose a sorting order.

   • To add another sorting rule, click Add another sort column.

7. Click Sort.

1. On your computer, open a spreadsheet in Google sheets and select the cells you want to apply format rules to.

2. Click Format Conditional formatting a toolbar will open to the right.

3. Create a rule.

   • Single color: Under "Format cells if," choose the condition that you want to trigger the rule. Under "Formatting style, choose what the cell will look like when conditions are met.

   • Color scale: Under "Preview," select the color scale. Then, choose a minimum and maximum value, and an optional midpoint value. To choose the value category, click the Down arrow .

4. Click Done.

On your computer, open a file in Google Docs, Sheets, Slides, or Jam board. At the top right >  click Meet.

To start a new meeting > click Start a new meeting. On the right, a side panel shows your meeting. 

You can convert macros in Microsoft Excel spreadsheets to Google Sheets by re-creating them using Google Apps Script. Apps Script powers macros in Sheets, just like Microsoft Visual Basic for Applications  does for Excel. 

Re-create and edit a macro in Sheets using Apps Script:

1. Make a note of the macros in your original Excel spreadsheet that you need to re-create in Sheets.

2. In Sheets, open a spreadsheet and click ToolsMacrosRecord macro.

3. Select the type of cell reference to use and click Save.

4. Complete the task that you want to record and click Save.

5. Enter a name for the macro and, optionally, a shortcut number and click Save.

6. Click ToolsMacrosManage macros to edit your script.

7. Next to the macro that you want to edit, click MoreEdit script.

8. In the macros.gs section, make your changes to the code. If needed, use the Sheets Apps Script documentation or search online for the JavaScript concept that you need.

9. Click Save macro  and close the tab to return to your spreadsheet.

10. Repeat steps 2–7 for any additional macros that you want to re-create from your original spreadsheet.

Activate a macro in Sheets

1. Click ToolsMacrosyour saved macro. You can also run your macro by using its keyboard shortcut.

2. If it’s the first time you run the macro, allow authorization.

When password protected files are uploaded on the Google Drive then the original password is retained therefore when user attempts to open it in Google Drive It opens in preview mode and challenges the user with password authentication. Hence, no change in functionality.