Is it possible to convert a csv formatted file to text, if so how can I do this?

Question

The information needs to go into a database that does not read a csv file.

Answer 1

Here are the steps:

1. Open it in Excel (it will do an import that results in a spreadsheet)

2. Do a "Save As"

3. Pick Text (tab delimited or space delimited doesn't matter)

4. Check the extension of the file you saved - make sure it is a .txt

5. Import the file into your database

Answer 2

A CSV file is just a text file with values separated by commas. If your database insists on a filetype of TXT, just rename the file. It's already in plain text format.

Answer 3

They are text files, all you need to do is rename it with .txt at the end instead of .csv

By default, Windows does not show file extensions, so you need to get into windows explorer and click:

tools / folder options / view
and uncheck hide extensions for known file types.

Then you will see the file.csv and just rename it file.txt and double click on it.

If you don't want the commas in it, then you can do a save as tab delimitted file from Excel.

PS: The easiest thing to do might just be to right click on the file and choose open with then choose Notepad.

Answer 4

just import the CSV into Excel. Once there you can save it as a text file.

Answer 5

Microsoft seen complication-unfastened Is already tied to each thing on the subject remember of text cloth managers on homestead windows. look into the source for a technique to export a text cloth record with the two comma and quote delimiters in Excel.

Answer 6

You can convert it in Excel, Access, or Word.

Answer 7

I totally agree with the guy in the cool hat.