Export Data from Excel to .txt File with Commas as Column Separators: Step by Step Guide

Hello,

I was looking for a long time, but I did not find a solution to my problem, so I am writing here.

I would like to export data from excel file to txt file and separate each column with comma.
Specifically, it is about exporting from excel -> txt.

The data that I want to export from Excel look like the screenshot below.


I would like it to be written in the .txt file like this:

1, the text, text, text, text, text ,,,,
2, text, text, text, text, text ,,,,
3, text, text, text, text, text ,,,,
...


How can I fix this problem?

best regards

Comma separated values are excel file export to cvs format. https://pl.wikipedia.org/wiki/CSV_(format_pliku)

zen3x wrote:

Comma separated values are excel file export to cvs format. https://pl.wikipedia.org/wiki/CSV_(format_pliku)

Thank you for your answer

I saved the file in CSV format and opened it via a .txt file, however now the column contents have been separated by a semicolon, not a comma.

How can I separate them with a comma?

best regards

Hello
It could be a macro

The .csv format uses the list separator declared in the operating system settings. If in the Control Panel in the international settings (region) you change the list separator from a semicolon to a comma, and the decimal separator from a comma to a period (so there is no conflict), then the entry in the .csv format will be with a comma, not with a semicolon.