+ Reply to Thread
Results 1 to 2 of 2

Excel data to separate csv files

  1. #1
    Registered User
    Join Date
    02-19-2018
    Location
    bangalore
    MS-Off Ver
    7
    Posts
    1

    Excel data to separate csv files

    Hello Experts,

    I have a excel sheet with 64k records i need to separate those datas into separate CSV files based on unique entries in certain column.

    For Example:

    In column H i have entries like
    a
    a
    b
    a
    c
    b
    c

    Then i need entries of a in separate csv file, b entries in another csv file and c in another csv file.

    Note: need to copy data of row entries to csv files.

    Is there any macros or formula as we need this for daily work to separate the file to csv and import the data to the tool.

    Appreciate your help

    Thank You
    Pratham

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Excel data to separate csv files

    Hi Pratham

    Welcome to the Forum...
    This will give you an idea...save this file to your desktop
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 02-20-2018 at 06:10 AM.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro to separate data based on contents of a column to 2 new excel files
    By beautify5 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-18-2015, 11:19 AM
  2. Split the excel data in worksheet to save it in two separate excel files
    By sat1591 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-20-2014, 04:52 AM
  3. Replies: 8
    Last Post: 10-18-2012, 05:42 PM
  4. [SOLVED] Writing Excel data to 2 separate text files
    By new2vb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-06-2011, 12:51 PM
  5. how do I match data from two separate files in excel
    By roger f brennan in forum Excel General
    Replies: 1
    Last Post: 07-13-2006, 10:12 AM
  6. Open Separate Excel Files in Separate Windows
    By JTWood in forum Excel General
    Replies: 3
    Last Post: 05-07-2006, 05:18 PM
  7. Open Excel files in separate sessions, not just separate windows?
    By Bob at Dexia Design in forum Excel General
    Replies: 1
    Last Post: 10-18-2005, 01:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1