fb

Merge CSV Files Into One Combined Workbook, with Separate Tabs for each sheet.

If you work with CSV exports, you’ve undoubtedly had to create workbooks created from those sheets, and if you’re like me, you may even create a table of contents page for easy navigation.

Years ago, I looked for a way to do this efficiently, and the best I came across, without buying a 3rd party product for Excel, was to create a new Excel workbook, then open each CSV file separately, dragging the active tab from the bottom over into the new Workbook.

The monotony of putting together those reports became a tedious task, and added unnecessary time to the delivery of an audit.

In addition, this Add-in will go through each of the tabs and “enable” any hyperlinks that may be on the sheets, as well as create a table of content page for the entire workbook with links to each tab.

Update: June 2023

After Unzipping, you must take two additional steps, because Windows it trying to protect you from yourself.

  1. Right click on the unzilled folder, and change the status from Read Only. The box should be empty. If it looks like this, UNcheck it.  

Uncheckk this box.

2. Open the folder and right click on the xlam file, go to properties, and “UNBLOCK” the file – 

Unblock Media

 

 

Here’s a video showing what this add-in does:

Instructions:

First Time Installation:

  • Place the downloaded file in any folder and UNZIP, taking note of the folder location.
  • Open Excel to a blank workbook
  • Click File and then Options
  • Click Add-ins and at the bottom you’ll see Manage:
  • Select Excel Add-ins and click Go
  • Click Browse and navigate to the Consolidate Files.xlam file, click the Consolidate Files.xlam file name and Open
  • “Consolidate Files’ will appear on the Add-ins list; put a check mark next to it and click OK.
  • The Consolidate Files add-in will appear on the Data Menu
  • The Add-in will then be there very time you open an Excel file

After Installation – Consolidate Files Each Time:

  1. Open a blank Excel file
  2. Name that file and place it in the same folder where the csv files are located
  3. Click the button for Consolidate Files on the Data Tab and you’re done.

Are you looking for a set of tools to manage your own website? Ranking reports, visibility competitive intelligence, on page SEO ideas, etc.?  Check out SEMrush for a free trial

I've been a customer and affiliate of theirs for years, and use it for nearly 100% of our SEO clients.  In fact, if you sign up for a brand new account through my link, I'll offer you a free phone consultation to set up and review your first site audit once it runs. 

2 Comments

  1. Jonathan Pape

    That is pretty cool. I bet it would be really helpful if you had Screaming Frog reports or another application that only exports CSVs.

    • Scott Hendison

      Thanks, yep, that’s exactly what I needed it for 😉

Share This