Comments on: How to merge multiple CSV files into one Excel workbook

If you often export files in the CSV format from different applications, you may end up having a bunch of individual files relating to the same subject matter. The question is - is there a simple way to import them all into a single Excel workbook? Continue reading →

Table of contents

Comments page 2. Total comments: 31

  1. thanks!! But how if there is a extra line in some of the cells, that row will become two rows in the combined file. How to overcome that..

  2. Brilliant. Thank you so much!!

  3. excellent, thank you!

    1. Pls I am working with a project in Excel VBA programming to automate a process that will import multiple .CSV files, merge them, and read it line by line to separate the columns without delimiter, because the file does not have separator.

      I need some lines of code that can do this.

      Can you please help.

      Regards.

  4. Thank you very much, saved my day Svetlana!

Post a comment



Thank you for your comment!
When posting a question, please be very clear and concise. This will help us provide a quick and relevant solution to
your query. We cannot guarantee that we will answer every question, but we'll do our best :)