The Google Chrome Extension That Will Save You Hours

The Google Chrome Extension That Will Save You HoursA whopping 70% of Admin Hero readers access the website from Google Chrome. It’s a modern browser and part of the reason for its popularity, aside from its speed, are the powerful extensions.

So, what is this mysterious extension that can save you hours? ColumnCopy. ColumnCopy allows you to click right on a list on any website and essentially copy the values. Not only does it copy columns, but it can also copy table values. Once copied, the values of the column or table can be dropped into Excel, Google Docs or right into Salesforce.

Here are some examples of ways that I’ve used it over the past few weeks to save me hours.

Copy Picklist Values

Every Salesforce Administrator has experienced this; you have created a new picklist field and wanted to use the values in another picklist field elsewhere in Salesforce. So you intend to copy the values out of the field before saving, but you forgot to do so. Face palm. I don’t know how many times this has happened to me as an Administrator.

I ran into this very same issue last week while configuring a client’s org. But, with ColumnCopy, I was able to copy all of the picklist values of the field with a simple right-click of my mouse and copy the values for use elsewhere in Salesforce! Without the extension, I would have had to rekey all of the picklist values.

Note that a new Salesforce feature called Global Picklists is available in the Spring ’16 release which could eliminate the need for this headache!

Copy Field Labels on a Page Layout

Again, working in a client org last week, I was doing a “stare and compare” on a series of fields created on the Account. I was reviewing the list of fields on the layout to determine if they match the new updated values provided to me in an Excel spreadsheet.

I realized that if I could capture the field labels from the layout and put them into Excel next to the new values, I could more readily indicate which fields needed to be updated, added or removed. ColumnCopy to the rescue! With a simple right-click, I had the values of the Account fields copied and pasted into Excel for review.

Object Metadata Export

Exporting Salesforce object-level metadata such as fields, field values, and data types is relatively easy, but what if you want to audit the fields and field values for a single object? Use ColumnCopy to copy the entire fields table and paste it into Salesforce!

Exporting validation rules and workflow rules are nearly impossible. Using ColumnCopy, the Validation rules page values or Workflow rules can easy be copied out of Salesforce and into a Google Sheet for evaluation and note taking as part of the audit.

Falling Short

The extension is really great, but it does fall short in a few areas. The values are copied only as text so if there is a need to have an HTML version copied, try Copytables – a similar Chrome extension.

Also, it doesn’t do a good job of capturing checkboxes in Setup. Notice in the last example above the Track History column values didn’t copy over. A small price to pay in my opinion!

Extension Security

It’s important to note that Chrome Extensions are generally created by a third party – and not all of those third parties are reputable companies. Google does not have an official security review process for extensions which means that any developer can create an extension and publish the app.

For this reason, it’s important to review the app privacy policy and understand not only what information needs to be granted to the app to work, but also what the app developer plans to do with the information the app has access to. Always be aware of the extensions you’re installing – not just those that are Salesforce specific.

I hope you find this tool valuable! I know I have. It’s become one of the very few Chrome extensions that I use on a daily basis!

Load More Related Articles
Load More By Brent Downey
Load More In AppExchange & Reviews


  1. Rachel Dew

    February 8, 2016 at 9:07 am

    Hi Brent,

    Oh this is exciting! Thank you so much for highlight each use case and for sharing the chrome extension.


  2. Ishrat Fatima

    February 8, 2016 at 9:08 am

    Hi Brent – thank you for alerting us about the “copy this column” feature with Chrome – super useful and I know it will save me some time! I also use the “Enhance Salesforce Dashboard” feature which auto refreshes the dashboard and allows for up to 7 columns.


    • Brent Downey

      February 8, 2016 at 11:26 am

      I’ve heard good things about this extension as well, but haven’t used it myself. I’ll have to give it a spin!


      • Rand Thompson

        December 29, 2016 at 12:59 pm

        I’ve used Enhance Salesforce Dashboard extension and it’s AWESOME! Not sure how it works with LEX, though. Hey, I’ll go check that out right now!


    • Chirag Mehta

      February 9, 2016 at 2:37 am

      Thanks Ishrat!
      Brent – Do check out “Enhance Salesforce Dashboard” extension and let me know if you have any feedback.
      PS : I’ve developed Enhance Salesforce Dashboard 🙂


  3. Matt Nesci

    February 8, 2016 at 9:12 am

    Brent great tool!!!

    Just a note on picklist values. You can click on the printable view for picklists and copy the values from that view. However, this extension makes it even easier !!


    • Brent Downey

      February 8, 2016 at 11:26 am

      Still a great trick to know about Matt! Thanks for sharing.


  4. David Limiero

    February 8, 2016 at 9:12 am

    Great find. Thanks!


  5. Bruce Dixon

    February 8, 2016 at 9:17 am

    Whoa. This is fantastic.


  6. Eddie Trumble

    February 8, 2016 at 9:24 am

    Thank you for highlighting this great tool! Just another reason to subscribe to Admin Hero!


  7. Kelly Kanches

    February 8, 2016 at 9:24 am

    This is awesome!!! Thanks for sharing! Massive time saver!!!


  8. Tiffany Parker

    February 8, 2016 at 9:40 am

    Fanfreakingtastic Brent!!!! What a good find. Thanks for sharing this will be SUPER helpful while documenting my current org.


  9. Mark Aman

    February 8, 2016 at 10:18 am

    If you’re need to use Firefox, it has a column copy feature built-in. On a Mac at least, press the Command key, then drag through the copy values you want to copy and press Command+C.


    • Brent Downey

      February 8, 2016 at 11:27 am

      Thanks for sharing Mark! There may even be an available extension for Firefox, but I’m a Chrome user and didn’t think to check the Firefox marketplace!


    • Glenn Weinstein

      March 6, 2016 at 3:24 pm

      Trust me, this extension is way better than a vanilla Command+C on a Mac.


  10. Mark Aman

    February 8, 2016 at 10:19 am

    If you need to use Firefox, it has a column copy feature built-in. On a Mac at least, press the Command key, then drag through the copy values you want to copy and press Command+C.


  11. Jeff Jones

    February 8, 2016 at 10:19 am

    Brent, I figured I’d click on the post and see an extension I already use, but I was wrong! More time saved ahead for me! Thank you. Are you open to seeing the other extensions your readers are using, saving additional hours?


  12. Brian Fey

    February 8, 2016 at 10:41 am

    Nice. Thanks!


  13. Hilit

    February 8, 2016 at 10:56 am

    This is really great! I was hoping to be able to copy a column or a table right out of the records view for contacts or any other object but it didn’t work. Any idea if it’s possible at all?


    • Brent Downey

      February 8, 2016 at 11:29 am

      I did hear that for some folks, a restart of the browser was needed to get this to work correctly. I haven’t experienced any issues with it however. You may want to try the alternative extension mentioned at the end of the post if this one isn’t doing what you want.


  14. Jackie

    February 8, 2016 at 12:11 pm

    Stopped what I was doing and installed this little gem! Thanks for sharing your great find!


  15. Mary

    February 8, 2016 at 3:15 pm

    Love it! Thanks for the tip.


  16. Vedrana Madiah

    February 8, 2016 at 3:31 pm

    It is like you read my mind this week. Thank you! This is awesome.


  17. Chirag Mehta

    February 9, 2016 at 2:38 am

    This looks really good extension. Thanks B, for sharing same.


  18. Ragnhild

    February 9, 2016 at 4:46 am

    Have used it for an hour now and is absolutely thrilled! Will be extremely helpful in my admin work.
    Especially like copying a summery report and be able to paste it in to Excel exactly the way it looks, instead of exporting the report.


  19. Justin Mitchell

    February 9, 2016 at 10:26 am

    Thanks for sharing, I’ll definitely be using this.

    Regarding the hyperlinks issue: if you look at the options for the extension (Settings > Extensions > ColumnCopy > Options) you can choose to either have it copy “raw text” or “Create Excel style CSV hyperlinks, ie: =HYPERLINK(“”, “Example”)” so that mostly eliminates the shortcomings you mentioned!


    • Brent Downey

      February 24, 2016 at 3:48 pm

      Oh, that’s awesome Justin! I’ll have to go in and take a look right now!


  20. Jake Schmitz

    February 11, 2016 at 7:20 pm

    Thanks, Brent! Here are some must-haves for time saving!!! I’m sure lots of admins and consultants out there already know about these, but I have saved so many hours of my life I feel like I just have to share:

    1. LOGINS: a must-have for all consultants! (

    2. Salesforce API Fieldnames: for those of us too lazy and like avoid clicks! (

    3. Salesforce Navigator: this extension has saved me HOURS of “useless clicking” (

    4. Enhanced Formula Editor: helps you keep track of all your parenthesis, haha (

    5. Quick Login As: helps with troubleshooting an ironing out security profiles FAST (


  21. Raja Islam

    February 15, 2016 at 10:49 pm

    Interesting. Thanks for sharing.


  22. Mathieu Szymkiewicz

    February 17, 2016 at 3:40 am

    Thank you so much. This tool is totaly awesome.



    February 19, 2016 at 11:49 am

    Thanks Brent for sharing the info on the chrome extension. It certainly saves me tons of time.


  24. Katie

    February 26, 2016 at 3:46 pm


    Wanted to let you know that I downloaded the extension mere minutes after you posted this article and in the weeks since, have found it a tremendous time saver! I’ve passed the “secret” to my boss and several of my end users who all have the same enthusiastic response as I did when reading your blog post.

    Thanks for providing a solution to a problem I didn’t realize could be solved!



  25. Andres

    April 9, 2016 at 8:26 pm

    Great article, thanks, made me look into many other free salesforce chrome extensions out there!


  26. Jack

    December 22, 2016 at 4:07 am

    There is a share meeting after lunch every Thursday in our company.
    In this meeting, some coworker will share their story, experiences they got in their work with us.

    Last week, I shared some useful Mac tools and Chrome Extensions. I got a lot of good feedbacks from my coworkers.

    Here is the list of the most useful and frequently used Chrome Extensions:
    1. [QR Code Maker]( – Generate a QR Code of the website you are visiting. Then you can use your mobile to scan it and visit it on your phone. No need to type.

    2. [Draft]( – A new tab is just like a draft. Open a tab and write. It will save for you.

    3. [Evernote]( – Product of Evernote. It helps sync the article reading to your Evernote account.

    4. [One Tab]( – You opened too many tabs? No worries, it helps you save them in one tab.

    5. [Bookmark Manager]( – It has a much better UI than default Chrome browser.

    6. [QR Reader Beta]( – You want to scan a QR Code on PC? This is exactly what it does.

    7. [Send to kindle]( – Sync articles to your Kindle device.

    8. [[For Developer] Postman]( – It is a very useful tool to test APIs. You can imitate POST & GET.

    9. [[For Developer] JSON View]( – It will help you display a JSON in a readable way.


  27. Rachel Burcher

    January 23, 2017 at 2:59 pm

    ColumnCopy is great and I’ve been using it ever since I saw your recommendation, but sad times! It doesn’t appear to work with Lightning Experience 🙁 – you need to switch back to classic to be able to use it


  28. Abhishek Verma

    February 13, 2017 at 5:40 am

    I have developed a chrome extension “VFWIZARD” for salesforce developer which is the first chrome extension which allows you to create your HTML/Visualforce code using Drag n Drop.
    Please download by clicking below link and share your feedback
    Thanks and regards
    Abhishek Verma


  29. Enrico Murru

    March 13, 2017 at 10:46 am

    Hi Brent, have a look at my Salesforce ORGanizer Chrome Extension…lots of dev/admin releated useful features


  30. Javlon Sodikov

    June 13, 2018 at 11:25 am

    here is another column/cell copy extension for Chrome Browser.


  31. Javlon Sodikov

    June 13, 2018 at 11:25 am

Leave a Reply

Your email address will not be published. Required fields are marked *




Join the bomb diggity Admin Hero email list and never miss a post. Like, never ever!

Hizza! You're subscribed! Nothing but good times ahead!