LinkBack URL
About LinkBacks
Hi All,
I have many csv files in a specific path, each has its own number of headers and its relevant data (differs from file to file). Is there any option to extract only the headers from all the csv files in the specific path.
Thanks in advance !!
Extracting top row in CSV file
Hi All,
I have many csv files in a specific path, each has its own number of headers and its relevant data (differs from file to file). Is there any option to extract only the headers from all the csv files in the specific path.
Thanks in advance !!
I think you could probably do it with PowerQuery (Get & Transform on the Data ribbon).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Yeah !! but my headers aren't identical across files. Couldn't grab headers across all files.
Provide two files with different headers and I'll have a look and see. Otherwise it's guesswork.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks