How do you combine multiple csv files into one file?

B

Brian Wenner

Hello,

I have six comma delimited files with a csv extensions on my desktop. I want
to combine the six files into one file and load them into Excel. Right now I
am loading all six into one session of excel then I copying the contents of
one book and paste into the first book, copy paste, copy paste, copy paste,
etc... I figure there has to be a better way. So my question is:

How do you combine multiple csv files into one file with Excel?


Brian
 
M

Microsoft

As I recall, arent the CSV files just text with Comma Seperators? If that is
the case open them in notepad and paste them together!
MArcos
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Combining three files when middle file has sections with endnotes 2
Merging from an Excel file with graphics 1
New computer, how do i move outlook 365 ENTIRELY? 0
batch extract all tables from multiple word documents 1
CSV files and having numbers and strings in there... 9
Moving data from CSV to Excel sheet 1
How can I combine several excel files into one? 3

Top