This page contains enriched content visible when JavaScript is enabled or by clicking here. Skip to main content
 

Dataset Tools: Main

This guide provides a number of tools for working with datasets.

Data Management

Managing a dataset often includes tasks such as sorting data, subsetting data into separate samples, merging multiple sources of data, aggregating of data based on some key indicator, or restructuring a dataset. These types of data management tasks are sometimes called data cleaning, data munging, or data wrangling. This guide covers these types of "cleaning tasks". 

Working with Excel Files

Splitting Multiple Sheets Into Separate CSV Files

These are two tools I recommend for using to split your dataset excel files into separate csv files. The first option is a bit cleaner as you do not have to install any extra software on your PC.

VBA Macro:

1. Create a new folder for the csv files to be saved to, for example c:\test.

2. Open the Excel file that you want to split.

3. Hold down the ALT + F11 keys in Excel, and it opens the Microsoft Visual Basic for Applications window.

4. Click Insert Module, and paste the code from answer #52 from this discussion board:
http://stackoverflow.com/questions/59075/save-each-sheet-in-a-workbook-to-separate-csv-files/59114#59114

5. Press the F5 key to run the code.

6. You will be prompted for your delimiter, choose "," and then choose the folder to save the files to.

Kutools for Excel:

1. This option requires you to install a add-on for Excel called Kutools. There is a free version you can use for sixty days.

2. Once you install it, follow the steps here:
https://www.extendoffice.com/product/kutools-for-excel/split-the-current-excel-workbook.html

Systems Librarian

Bill Kelm's picture
Bill Kelm
Contact:
Mark O. Hatfield Library
Willamette University
900 State Street
Salem, OR 97301
503-375-5332
Website / Blog Page