How to Save Links Into a Google Spreadsheet in Chrome

Doing research on the web is one of the conveniences of our digital era. Information is easily accessible with a click of a button, and you don’t need to make that trip to your local library to pour over pages of books.

The challenge, however, is organizing information when it’s scattered all over the web. When you’re doing research that’s heavy on citations, simply bookmarking webpages may not be enough for you to track each source of information.

A helpful Chrome extension called Citable addresses this challenge by enabling you to save a website’s link, along with your notes, to a Google Spreadsheet document.

Installing and using Citable

Upon installing the extension, you will find a quotation mark icon on the top-right corner of the browser.

With the webpage that you want to save in the current tab, click on the icon.

citable_newdoc

If this is your first time to use the extension, a Google sign up window should prompt you to log in and allow access to your Google Drive account. This is where your saved links will be stored. Click on the “Allow” button to authorize the extension.

Once you’re signed in to your Google account, you should now see a drop-down notepad when you click on the quote icon.

In most cases, the notepad should already have a current webpage’s information, such as article title, author and URL. If it doesn’t appear, you can add it manually. You can also add a tag and a summary that will be included in the Google spreadsheet.

When done, click on “Create Document” on the drop-down list on the bottom, and give your document a name. Click the Save button.

citable_viewdoc

The new document will be stored as a spreadsheet file in a folder called Citable on the main page of your Google Drive account.

Once saved, there should be a link to view the document. Clicking the link will open a new tab and take you directly to the document in Google Drive.

The spreadsheet is organized into six columns which are comprised of the title, URL, date, author, summary and tag of saved webpages.

citable_doc

Repeat the same process for each webpage you want to cite as your source.

If you are researching a different topic, you can create another document so you can separate sources accordingly.

New webpages that are added are updated in the spreadsheet in real time, so you see them on the spreadsheet as soon as they’re added.

If you want to learn keyboard shortcuts, you can right-click on the quotation icon and go to “Options.” You should see four hotkeys for navigating and using the extension.

citable_options

Citable is a perfect solution for heavy research work that requires a lot of citations from different sources. Getting all citation information organized into a nice spreadsheet is also a huge time saver which cuts down extra work for the busy researcher.

Having Google spreadsheet as a way to save the document is also a great feature, so it’s safely backed up in your Google Drive account, and you don’t have to worry about the file getting accidentally deleted or lost.

Subscribe to our newsletter!

Our latest tutorials delivered straight to your inbox

Kim Barloso Avatar

Read next

Suzanne Simard sealed paper birch and Douglas fir seedlings inside plastic bags, fed them carbon-14 and carbon-13 dioxide, and nine days later found carbon had crossed between species through fungal threads in the British Columbia soil beneath her boots
A species of jellyfish called Turritopsis dohrnii can revert its adult cells back to a juvenile polyp stage when injured or starving, effectively restarting its life cycle, and biologists have so far failed to identify any natural limit to how many times it can do this.
A Japanese man named Jiroemon Kimura, who lived to 116, was born in 1897 when Queen Victoria still ruled and died in 2013, meaning a single human life personally overlapped with the invention of the airplane, the atomic bomb, the internet, and Instagram
The Hollywood sign originally read HOLLYWOODLAND when it was built in 1923 as a real estate advertisement for a housing development, and it was only meant to stand for 18 months, but nobody ever got around to taking it down and the city eventually adopted it as a landmark
Almost all of the world’s internet traffic does not travel by satellite but through fibre-optic cables lying on the ocean floor, a hidden web of wires crossing the deepest parts of the sea to connect the continents.
People who flip their phone face down on every table aren’t being secretive. They figured out that staying interruptible meant handing their time to whoever rang first
Twitch vs. Facebook Gaming vs. YouTube Gaming: What’s the Best Live Game Streaming Platform?
Chrome Extensions Ownership Transfer is a Direct Threat to You: How to Stay Safe