Turning an Excel file into CSV

Have you tried just saving the file as a .csv? That is, File | Save | choose CSV from the list of file types. You shouldn't need to concatenate the data into one cell.

When you create a CSV file, each row of data will become one record in the CSV file. The data in the cells will appear in the row separated by commas. If you have empty cells, you'll get two commas.

Have a look at the attached examples. One is a sample from another thread, the second is the same file saved as a CSV file. View it in NotePad.

Open the CSV file in Notepad and you will see that it is correctly laid out. CSV files are plain text and don't contain formatting.

You're welcome.

As rorya and I both said, view the file in NotePad. Often, if not always these days, CSV files default to opening in Excel. In which case, the data should appear in the same cells/rows/columns, which is what you want, and without formatting, which you (and the other programs) don't need.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.