Skip to content

2 Methods to Copy Data From View Only Google Sheets File

May 9, 20243 minute read

It is easy to make your Google Sheets file view-only to protect your data from unauthorized copying or accidental changes when sharing it with others. You can use the native permission settings to make a spreadsheet file view-only when you want to share data but not allow others to edit or modify it.

While Google Sheets’s “View-only” modes offer security benefits, they can limit functionality like data sorting, filtering, and copying large amounts of data. This can be inconvenient for working with large spreadsheet files. Fortunately, there are a few methods to extract data from View Only Google Sheets files, albeit with some potential workarounds.

How to Copy Data From View-Only Google Sheets File?

While View-only mode in Google Sheets discourages copying data directly, it doesn’t completely prevent it. There are methods to extract information from these files, so View-only mode serves as a restriction rather than an absolute security measure.

By converting Google Sheets into Preview mode or HTML View mode, you can copy data from View-only Google Sheets file. It doesn’t require any application.

First Method: Converting to Preview Mode

1. Open the View-Only Google Sheets File:

  • First, open a view-only Google Sheets file in any web browser.

2. Modify the URL:

  • In the address bar, locate the word “edit.”
Google Sheets preview mode

3. Change to Preview Mode:

  • Replace the word “edit” with “preview” and press Enter.
  • This action will open a preview window displaying the Google Sheets data.
Copy data from view only mode Google Sheets

4. Copy the Data:

  • Now, select and copy the desired data to your clipboard.

5. Open a New Spreadsheet Software:

  • Next, open a new Google Sheets or any other spreadsheet software.

6. Paste as Values Only:

  • To paste the copied data into the new Google Sheets, right-click and choose “Paste Special.”
  • Select the “Values only” option from the menu.
Paste data from a view only mode Google Sheets

7. Full Access for Editing and Formatting:

  • You now have full access to edit and format this data according to your requirements.

Second Method: Converting to HTML View Mode

1. Open the View-Only Google Sheets File:

  • Begin by opening the View-only Google Sheets file.

2. Modify the URL:

  • In the address bar, locate the phrase “edit#gid=567064581” at the end.

3. Change to HTML View:

  • Replace “edit#gid=567064581” with “htmlview” and press Enter.
  • The data will now be accessible in an HTML format.
Convert view only mode Google Sheets to html view mode

4. Copy the Data:

  • Select and copy the desired data from this Google Sheets file.
Copy data from a html view mode Google Sheets

5. Open a New Google Sheets:

  • Now, open a new Google Sheets document.

6. Paste as Values Only:

  • Right-click within the new sheet and choose the “Values only” option.
  • Alternatively, use the Ctrl+Shift+V shortcut.
Copy-and-paste-data-from-a-view-only-mode-Google-Sheet

7. Editable and Formattable Data:

  • The data is now available in an editable form, allowing you to format it according to your needs.

Conclusion

With these techniques, you’ve learned how to extract data from View-only Google Sheets files. It’s important to note that additional tools like the Spreadsheet Copy Google Chrome extension may exist to further streamline this process. However, remember to always prioritize ethical data practices and only use these methods for information you have permission to access.

More Resources

No Comments

Back To Top