+ Reply to Thread
Results 1 to 2 of 2

Adding Text files data to Excel

  1. #1
    Registered User
    Join Date
    03-05-2016
    Location
    india
    MS-Off Ver
    2013
    Posts
    10

    Adding Text files data to Excel

    I need to combine data from text files to Excelsheet. Have around 200 files to work with. Please consider example as below:

    Consider below scenario:

    I have 2 files abc.txt & xyz.txt containing below data in location C:\Files\

    abc.txt:
    1.JPG

    xyz.txt:
    2.JPG

    Requirement is to add the data present in the files to Excelsheet and the output in the sheet should be as below:

    3.JPG


    Thanks in advance..

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Adding Text files data to Excel

    Hi Anufed,

    Power Query is your answer. It allows you to scan folders looking for file names and then add the name to the data. You need to install it as an Add-in to Excel 2013 but it is now built into 2016 Excel.

    http://dutchdatadude.com/combining-e...ery-for-excel/
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ 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. Adding same text at the end of each line on external text files
    By Loski in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2016, 05:49 AM
  2. [SOLVED] How to read text data from .dat files and fetch the data in to excel based on input..
    By mahendra.asapu in forum Excel Programming / VBA / Macros
    Replies: 62
    Last Post: 07-19-2015, 04:36 AM
  3. [SOLVED] IMPORTING TEXT FILES TO EXCEL - Multiple Multi-line text files, each in a new column
    By wrenchfry in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2014, 08:37 PM
  4. Adding files to existing Excel dataset, updating Excel data set
    By fdavidwest in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2012, 07:13 PM
  5. [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
  6. Adding leading zero to the date in the text files
    By vinwin06 in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 08-04-2010, 03:10 AM
  7. Import Data from variable Text files into Excel
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2009, 06:08 AM

Tags for this Thread

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