SEER Blog

  • Graeme Benge

    Aichlee, what a great post. Not played with Macros too much but Screaming Frog is going to get the treatment now as well as a few link profiling tools! Great work.

  • Aichlee Bushnell

    Thanks, Graeme. Have fun with it!

  • Zach

    Aichlee, great you finally shared this with the public, I use this all the time since you’ve sent it to me.

  • Aichlee Bushnell

    Thanks, Zach. I’m glad that you’re using it :)

  • http://dannyfries.com/ Danny

    Aichlee, you’re awesome. I Google’d: “screamingfrog multiple exports imports to excel” and what comes up? A FULL GUIDE. Thank you thank you thank you.

    I ran into a couple snafus, maybe you can help. First, is there a best practice for naming and saving the macros from the visual basic editor? I saved mine locally for the time being. Second, when I clicked “Run” at the end, nothing happened. Do I need to have ScreamingFrog exports ready in some folder before running the macro?

    I’m using Excel 2010, Windows 7.

    THANK YOU AGAIN!

  • Aichlee Bushnell

    Ah, good. Sorry that I missed your question! Glad it worked for you :)

  • Matthew Deming

    Aichlee,

    Thanks for posting this macro. Love it…style points to you as well as functionality. I’m working on modifying it so I can delete multiple columns when the files are imported as I do not need certain columns. Can you point me to the area in the code where I would enter the columns to be deleted? Thanks.

  • Aichlee Bushnell

    You should be able to add column deletions under this line in the macro:

    ws.Rows(1).Delete

    Hope that helps!

  • Matthew Deming

    Aichlee,

    Good morning. I was successful in deleting the unnecessary columns, thanks. I’ve been working on modifying the code to only import one csv file but I keep coming up empty handed regarding the correct syntax for this. Might you be able to point me in the right direction for this modification? Thanks again. Matthew

  • Aichlee Bushnell

    Hi Matthew,

    Sure, replace the asterisk in this line, with the file name of your csv:

    fCSV = Dir(fPath & “*.csv”)

    This will allow you to import that singular file into whatever Excel spreadsheet you have open.

    Hope that helps!

    Aichlee

  • Matthew Deming

    Aichlee,

    Thanks for getting back to me. I’ll give it a try once I’m back from vacation.

    Matthew