+ Reply to Thread
Results 1 to 1 of 1

Can multiple input CSV files be combined into a single table in Excel for Mac?

  1. #1
    Registered User
    Join Date
    04-22-2021
    Location
    Burlington, MA
    MS-Off Ver
    Office 365
    Posts
    1

    Can multiple input CSV files be combined into a single table in Excel for Mac?

    Hi Folks,

    New to the group and this is my first post, sorry if I have missed any protocols! I am limited to using Excel for Mac (version 16.47.1) and have a problem I cannot find a solution for. I believe this problem would be fairly well supported on the full Excel version on a Windows machine. Since Excel for Mac does not support that I have guessed this is the right subgroup in which to post!

    Say I have "N" number of CSV input text files (only 2 shown):

    data1.txt:

    name,value1,value2, value3
    Tom,100,200,alpha
    Jane,1000,2000,beta
    Raj,10,20,gamma

    data2.txt:

    name,value1,value2,value3
    Larry,800,900,delta
    Vin,8000,9000,epsilon

    The task is to allow the data files to be imported AND refreshed. The end result is required to be a Table that combines the results of the input files - that would be 5 total rows plus the common header. Since the input files can be refreshed, if a fourth line was added to data1.txt then the Table should update to combine the refreshed results.

    The columns of the input files will always be the same. The total number of input files will also not change. I am not certain of the total yet though - it will be between 5-8 though. There can be any number of sheets, and any number of tables as long as one finally exists with the combined results.
    I believe a Macro would be required to make this work in Excel for Mac? Is that a lot of work - I do not really know Excel Macros so it would not be something i could easily achieve on my own.

    UPDATE:

    As noted, I am new here. I just learned about the "Commercial Services" forum. If someone can assure me that what I want is achievable within Excel for Mac and let me know an appropriate number of points, I will move or add this post there with the requisite points!
    Last edited by JoeG_345; 04-23-2021 at 10:20 AM.

+ 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. Combining multiple excel files into a single sheet
    By Santhi28595 in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 08-04-2019, 09:51 AM
  2. [SOLVED] VBA Macro to Filter with Input box, Split files, Convert into Excel Table and Sort
    By Khalidngo in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-16-2017, 11:49 AM
  3. Handling multiple txt files within single excel sheet
    By 5mkh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2012, 08:12 AM
  4. Split single Excel file into multiple files
    By Michael_O in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2012, 06:27 AM
  5. [SOLVED] Help! How to import multiple .txt files into a single excel spreadsheet
    By blu37ay713 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-16-2011, 06:50 AM
  6. Replies: 1
    Last Post: 01-27-2010, 03:06 AM
  7. [SOLVED] Merging multiple excel files into a single doc
    By -------------------- in forum Excel General
    Replies: 1
    Last Post: 01-07-2006, 08:25 PM

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