Excel And Notepad

[Bob]

Hello,

Have an Excel Spreadsheet that I saved in CSV format.

The program that imports and uses it, manages to import most of it
correctly, but messes up on some of the cells.

If I look at it in Notepad, or Notepad++ it looks 100% fine.

So, I thought I would like to try importing into the program
directly from Notepad or Notepad++

From what I can see in their Save As options, neither seems to allow
Saving as a CSV. A bit surprised, as I thought a CSV is pretty much a
text file, so CSV Saving should be easy from Notepad, or
Notepad++ which certainly has a lot of other Save options, though.

Does anyone know if it is possible to save a Notepad or Notepad++ file
as a CSV ? How ?

Thanks,
Bob

 

[joeu2004]

Have an Excel Spreadsheet that I saved in CSV format.
The program that imports and uses it, manages to import most
of it correctly, but messes up on some of the cells.
If I look at it in Notepad, or Notepad++ it looks 100% fine.
So, I thought I would like to try importing into the program
directly from Notepad or Notepad++ [...].
From what I can see in their Save As options, neither seems
to allow Saving as a CSV. [....]
Does anyone know if it is possible to save a Notepad or
Notepad++ file as a CSV ? How ?

In the Notepad Save As dialog box, select All Files in the "Save as type"
drop-down list. Then enter the file name, complete with the file extension
".csv".

But that might not solve your problem. Or it might not be necessary.

What language or application is "the program that imports and uses" the CSV
file?

How would you "try importing into the program directly from Notepad"?

What syntax in the CSV file save from Excel causes problems for the "the
program that imports" it?

If the "the program that imports" the file is another Excel workbook, and if
you intend to use VBA to invoke Notepad to "import into the program
directly" somehow, you could simply write your own macro to parse the CSV
file directly using the Line Input# statement.

 

[Steve Hayes]

Hello,

Have an Excel Spreadsheet that I saved in CSV format.

The program that imports and uses it, manages to import most of it
correctly, but messes up on some of the cells.

If I look at it in Notepad, or Notepad++ it looks 100% fine.

So, I thought I would like to try importing into the program
directly from Notepad or Notepad++

From what I can see in their Save As options, neither seems to allow
Saving as a CSV. A bit surprised, as I thought a CSV is pretty much a
text file, so CSV Saving should be easy from Notepad, or
Notepad++ which certainly has a lot of other Save options, though.

Does anyone know if it is possible to save a Notepad or Notepad++ file
as a CSV ? How ?

If it displays as a CSV file in Notepad, then that's what it will save as.

 

[Bob]

Hello,

Thank you all for the help. Very appreciated

All set now.

Bob