--- title: Merge Data as You Open It description: Merge Data as You Open It image: https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/beryl_130023-Jul-05-2025-11-17-32-7750-PM.jpg --- English - [English](https://blog.minitab.com/en/?hsLang=en) - [Français](https://blog.minitab.com/fr/?hsLang=en) - [Deutsch](https://blog.minitab.com/de/?hsLang=en) - [Português](https://blog.minitab.com/pt/?hsLang=en) - [Español](https://blog.minitab.com/es/?hsLang=en) - [日本語](https://blog.minitab.com/ja/?hsLang=en) - [한국어](https://blog.minitab.com/ko/?hsLang=en) - [中文（简体）](https://blog.minitab.com/zh/?hsLang=en) - [![Icon Partners](https://blog.minitab.com/hubfs/WCM/Partners.png) Partners](https://www.minitab.com/en-us/company/partners/) - [![Icon Contact](https://blog.minitab.com/hubfs/WCM/Contact.png) Contact](https://www.minitab.com/en-us/company/contact-us/) - [![Icon Talk to Minitab](https://blog.minitab.com/hubfs/WCM/Phone.png) Talk to Minitab](https://www.minitab.com/en-us/talk-to-minitab/) - [![Icon My Account](https://blog.minitab.com/hubfs/WCM/MyAcct.png) My Account](https://licensing.minitab.com/account/manage) [![Minitab](https://blog.minitab.com/hubfs/WCM/minitab-corp-logo.svg)](https://www.minitab.com/en-us/) - Products Back [Products](https://www.minitab.com/en-us/products/) [All Products](https://www.minitab.com/en-us/products/) - [Minitab Solution Center](https://www.minitab.com/en-us/products/minitab-solution-center/) - [Minitab Statistical Software](https://www.minitab.com/en-us/products/minitab/) - [Minitab Connect](https://www.minitab.com/en-us/products/connect/) - [Minitab Model Ops](https://www.minitab.com/en-us/products/model-ops/) - [Minitab Education Hub](https://www.minitab.com/en-us/products/education-hub/) - [Minitab Engage](https://www.minitab.com/en-us/products/engage/) - [Minitab Workspace](https://www.minitab.com/en-us/products/workspace/) - [Real-Time SPC](https://www.minitab.com/en-us/products/real-time-spc/) - [Prolink Data Collection & SPC](https://www.minitab.com/en-us/products/prolink) - [Simul8 Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [SPM](https://www.minitab.com/en-us/products/spm/) - Solutions Back [Solutions](https://www.minitab.com/en-us/solutions/) [All Solutions](https://www.minitab.com/en-us/solutions/) - [Analytics](https://www.minitab.com/en-us/solutions/analytics/) - [Statistics & Predictive Analytics](https://www.minitab.com/en-us/solutions/analytics/statistical-analysis-predictive-analytics/) - [Data Science & Machine Learning](https://www.minitab.com/en-us/solutions/analytics/data-science-machine-learning/) - [Business Analytics & Intelligence](https://www.minitab.com/en-us/solutions/analytics/business-analytics-intelligence/) - [Statistical Process Control](https://www.minitab.com/en-us/solutions/analytics/statistical-process-control/) - [Quality Analytics](https://www.minitab.com/en-us/solutions/analytics/quality-analytics/) - [Live Analytics](https://www.minitab.com/en-us/solutions/analytics/live-analytics/) - [Reliability & Life Data Analysis](https://www.minitab.com/en-us/solutions/analytics/reliability/) - [Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [Process Mining](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [Key Capabilities](https://www.minitab.com/en-us/solutions/key-capabilities/) - [Continuous Improvement](https://www.minitab.com/en-us/solutions/key-capabilities/continuous-improvement/) - [Data Integration & Data Prep](https://www.minitab.com/en-us/solutions/key-capabilities/data-integration-data-prep/) - [Diagramming & Mind Mapping](https://www.minitab.com/en-us/solutions/key-capabilities/diagramming-mind-mapping/) - [Digital Twins](https://info.minitab.com/en/new-to-simul8?hsLang=en) - [Model Deployment & ML Ops](https://www.minitab.com/en-us/solutions/key-capabilities/model-deployment-ml-ops/) - [Innovation & Project Management](https://www.minitab.com/en-us/solutions/key-capabilities/innovation-project-management/) - [Process Excellence: Detect, Correct & Prevent](https://www.minitab.com/en-us/solutions/key-capabilities/process-excellence/) - [Featured Industries](https://www.minitab.com/en-us/solutions/industry/) - [Academic](https://www.minitab.com/en-us/solutions/industry/academic/) - [Energy & Natural Resources](https://www.minitab.com/en-us/solutions/industry/energy-resources/) - [Government & Public Sector](https://www.minitab.com/en-us/solutions/industry/government/) - [Healthcare](https://www.minitab.com/en-us/solutions/industry/healthcare/) - [Insurance](https://www.minitab.com/en-us/solutions/industry/insurance/) - [Manufacturing & Industrial](https://www.minitab.com/en-us/solutions/industry/manufacturing-industrial/) - [Services](https://www.minitab.com/en-us/solutions/industry/service-industries/) - [Software & Technology](https://www.minitab.com/en-us/solutions/industry/software-technology/) - [Construction](https://www.minitab.com/en-us/solutions/industry/construction/) - [Featured Roles](https://www.minitab.com/en-us/solutions/role/) - [Engineering](https://www.minitab.com/en-us/solutions/role/engineering/) - [Business Analysis](https://www.minitab.com/en-us/solutions/role/business-analysts/) - [Information Technology](https://www.minitab.com/en-us/solutions/role/information-technology/) - [Supply Chain](https://www.minitab.com/en-us/solutions/role/supply-chain/) - [Customer Service & Contact Center](https://www.minitab.com/en-us/solutions/role/customer-service-contact-center/) - [Human Resources](https://www.minitab.com/en-us/solutions/role/human-resources/) - [Marketing](https://www.minitab.com/en-us/solutions/role/marketing/) - [Research and Development](https://www.minitab.com/en-us/solutions/role/research-and-development/) - Resources & Services Back [Resources & Services](https://www.minitab.com/en-us/resources-services/) [All Resources & Services](https://www.minitab.com/en-us/resources-services/) - [Resources](https://www.minitab.com/en-us/resources-services/resources/) - [Case Studies](https://www.minitab.com/en-us/resources-services/resources/case-studies/) - [eBooks & White Papers](https://www.minitab.com/en-us/resources-services/resources/ebooks-and-white-papers/) - [Blog](https://blog.minitab.com/blog/?hsLang=en) - [Data Sets](https://www.minitab.com/en-us/resources-services/resources/data-set/) - [Webinars & Events](https://www.minitab.com/en-us/resources-services/resources/events/) - [Education Hub](https://www.minitab.com/en-us/resources-services/resources/education-hub/) - [Services](https://www.minitab.com/en-us/resources-services/services/) - [Training](https://www.minitab.com/en-us/resources-services/services/training/) - [Deployment](https://www.minitab.com/en-us/resources-services/services/deployment/) - [Consulting](https://www.minitab.com/en-us/resources-services/services/statistical-consulting/) - [Self-Paced Learning](https://www.minitab.com/en-us/resources-services/services/self-paced-learning/) - [Continuing Education](https://www.minitab.com/en-us/resources-services/services/continuing-education/) - Support Back [Support](https://www.minitab.com/en-us/support/) [Technical Support](https://www.minitab.com/en-us/support/) - [Subscriptions & Activation](https://www.minitab.com/en-us/support/subscriptions-and-activation/) - [Minitab Quick Start](https://www.minitab.com/en-us/support/quick-start/) - [Training](https://www.minitab.com/en-us/resources-services/services/training/) - [Installation Support](https://www.minitab.com/en-us/support/installation/) - [Support Videos](https://www.minitab.com/en-us/support/videos/) - [Support Documentation](https://www.minitab.com/en-us/support/documents/) - [Software Updates](https://www.minitab.com/en-us/support/software-updates/) - [Product Downloads](https://www.minitab.com/en-us/support/downloads/) - [Support Policy](https://www.minitab.com/en-us/support/policy/) - Company Back [Company](https://www.minitab.com/en-us/company/) [Company](https://www.minitab.com/en-us/company/) - [About Us](https://www.minitab.com/en-us/company/our-company/) - [Leadership Team](https://www.minitab.com/en-us/company/leadership-team/) - [Partners](https://www.minitab.com/en-us/company/partners/) - [Careers](https://www.minitab.com/en-us/company/careers/) - [Contact](https://www.minitab.com/en-us/company/contact-us/) - [News](https://www.minitab.com/en-us/company/press-releases/) [Try/Buy](https://www.minitab.com/en-us/try-buy/) - [Statistics](https://blog.minitab.com/en/blog/tag/statistics) - [Data Analysis](https://blog.minitab.com/en/blog/tag/data-analysis) - - [Quality Improvement](https://blog.minitab.com/en/blog/tag/quality-improvement) - [Subscribe](https://info.minitab.com/blog/subscribe?hsLang=en) ![Minitab](https://20853177.fs1.hubspotusercontent-na1.net/hubfs/20853177/minitab-corp-logo.svg?t=1755011311618) ## Notice You are now leaving minitab.com. Click Continue to proceed to: Continue Go Back # Merge Data as You Open It [Cody Steele](https://blog.minitab.com/en/blog/author/cody-steele) | 2/5/2014 - [Share](https://www.linkedin.com/shareArticle?mini=true&url=https://blog.minitab.com/en/blog/statistics-and-quality-improvement/merge-data-as-you-open-it) - [Share](https://www.facebook.com/sharer.php?u=https://blog.minitab.com/en/blog/statistics-and-quality-improvement/merge-data-as-you-open-it) Did you know about the [Minitab Network group on LinkedIn](http://www.linkedin.com/groups?gid=166220&trk=my_groups-b-grp-v)? It’s the one managed by [Eston Martz, of Minitab blog fame](https://blog.minitab.com/blog/understanding-statistics?hsLang=en). I like to see what the members are talking about, which recently got me into some discussions about Raman spectroscopy data. ![An incredibly fine 5-carat emerald crystal, that has it all: bright grass-green color, glassy luster, a fine termination, and most of all, TOP gemminess.](https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/beryl_130023-Jul-05-2025-11-17-32-7750-PM.jpg)Not having much experience with Raman spectroscopy data, I thought I’d learn more about it and found [the RRUFFTM Project](http://rruff.info/about/about_general.php). The idea is that if you have a Raman device, you can analyze a mineral sample and compare your results to information in the database so that you can identify your mineral. Not having a Raman device, the site is still exciting to me because all of the RRUFFTM data are available in ZIP files that you can download and use to illustrate some neat things in Minitab. So let’s say that you download [one of the ZIP files from the RRUFFTM Project](http://rruff.info/repository/zipped_data_files/raman/excellent_oriented.zip). The ZIP file contains a few thousand text files with intensity data for different minerals. Some minerals have a small number of files. Some minerals, like beryl, have many files. Turns out beryl’s pretty cool. In its pure form, it’s colorless, but it comes in a variety of colors. In the presence of different ions, beryl can be aquamarine, maxixe, goshenite, heliodor, and emerald. I extracted just the beryl files into a folder on my computer. Now, I want to analyze the files in Minitab. If I open the worksheet in Minitab without any adjustments, I get something like this: ![This worksheet puts sample identification information with the measurements, so you can't analyze the data.](https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/bad_worksheet-Jul-05-2025-11-17-34-8679-PM.png) While I could certainly rearrange this with formulas, I need only a few steps to open the file ready to analyze. 1. ![Use the preview to find where the data begin.](https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/find_row_narrow-3.png)Choose **File > Open Worksheet**. 2. Select the text file. 3. Click **Preview**. 4. Scroll down so that you can see the first row of numbers, in this case, row 13. 5. Click **OK** to close the preview. 6. Click **Options**. 7. In **First Row of Data**, select **Use row**. Enter the row that had the data in the preview. In this case, 13. Now you’ve solved the problem of including identifying information about the mineral in the worksheet. The other problem is that Minitab places all of the data in a single column unless you tell it how to divide the data. If you click **OK** in **Options** and click **Preview** again, you can see the problem. Finish the **Options** with these steps: 1. In **Single character separator**, select **Comma**. 2. Click **OK** twice. Now your data is in a nice, analyzable format. But remember that there are more than 30 files with data on beryl. To analyze them together in Minitab, the data need to be in same worksheet. Minitab has two nice features that make this easy to do. - If the file organization stays the same, then you don’t have to respecify the first row of data or the single character separator. Minitab remembers the settings. - Minitab gives you the option to merge the worksheet that you’re opening into the active worksheet.  Try these steps: 1. Choose **File > Open Worksheet**. (Minitab even remembers that you want to open a text file.) 2. Select the next text file. 3. Select **Merge**. 4. Click **OK**. ![You can choose to merge a worksheet with the active worksheet instead of opening a new worksheet.](https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/merge_worksheet_w640-3.png) The new data appears in the worksheet with the first data. You can finish this with the rest of the files to get all of the data in a single worksheet. ![The new worksheet contains the data from both text files.](https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/end_data-3.png) The options that Minitab provides for opening and merging data sources make it easy to get a wide variety of data ready for analysis. The data features are a good complement to the easy graphs and analyses that you can do in Minitab. ##### *The image of the emerald is by [**Rob Lavinsky**](http://www.irocks.com/) and is licensed under this [Creative Commons License](http://creativecommons.org/licenses/by-sa/3.0/deed.en).* --- - [Careers](https://www.minitab.com/en-us/company/careers/) - [Trust Center](https://www.minitab.com/en-us/trust-center/) - [Suppliers](https://www.minitab.com/en-us/suppliers/) - [Site Map](https://www.minitab.com/en-us/site-map/) - [![linkedin](https://blog.minitab.com/hubfs/WCM/linkedin-1.png)](https://www.linkedin.com/company/minitab/) - [![facebook](https://blog.minitab.com/hubfs/WCM/facebook.png)](https://www.facebook.com/Minitab/) - [![youtube](https://blog.minitab.com/hubfs/WCM/youtube.png)](https://www.youtube.com/user/MinitabInc) - [![instagram](https://blog.minitab.com/hubfs/WCM/instagram.png)](https://www.instagram.com/minitab/) --- © 2025 Minitab, LLC. All Rights Reserved. - [Terms of Use](https://www.minitab.com/en-us/legal/terms-of-use/) - [Privacy Policy](https://www.minitab.com/en-us/legal/privacy-policy/) - [Legal](https://www.minitab.com/en-us/legal/) - Cookies Settings