Comments on: How to convert (open or import) CSV file to Excel

Generally, there are two ways to convert a CSV file to Excel: by opening it in Excel or importing as external data. This article provides the detailed guidance on both methods and points out the strengths and limitations of each. We will also red-flag possible pitfalls and suggest the most effective solutions. Continue reading →

Comments page 3. Total comments: 97

  1. MANYYYYY THANKKKKKKKKSSSSSSSSSSSSSSSSSSSSSSS

  2. Thank you, thank you, thank you sooooooooo much!!! You've saved me tons of workload!!!! Thank you!!!

  3. tank u so much

  4. How to automatically load a csv file where all fields are treated as "Text and where "separator=," is done by default?

    1. Sorry, I cannot help with this. Automatic loading may be done via a VBA script only.

      1. I have CSV file which have Chinese character when we saved this CSV file in excel by "save as" option. Chinese char had been change.Could you please let me a solution for this?

      2. sep=, on fist csv line

  5. Dear Admin,

    Thank you so much for this useful information.
    Your detailed guidance has resolved my issue.

    Thanks again,
    Trevor

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 :)