CSV Saver

Save all tabs in an Excel Workbook as individual CSV files. Includes archive option.

Microsoft Excel is required to be installed on your computer to use this file.

The CSV Saver is used to easily convert, store, and archive data on the users computer or a shared drive.

The purpose of the CSV Saver is to compile multiple reports into CSV files.  The CSV files created are then saved for live reporting.  You can choose to archive a copy in a separate folder and adding a timestamp to the filename.

The CSV Saver will convert any and every tab in the workbook to a separate CSV file.  You choose the name and the file path.  The date is automatically added to archived copies.

You can choose to do one or both of the following

  1. Create a CSV for each tab that will continually be overwritten the next time you run the CSV saver (Live Copy).
  2. Create a CSV for each tab that will archive the data.  The filename will include the current date and file and can go to a separate folder your designate.

Possible Uses Include

  • Creating a data warehouse for other reporting platforms (Dashboards, Power BI’s, etc.)
  • Regularly archiving certain shared trackers or or data sources
  • Link any report to the CSV savor.  Allowing a quick refresh and export.

 

View Demo Below