Excel And Notepad

  • Thread starter Thread starter Bob
  • Start date Start date
B

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
 
Bob said:
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 ?
Click to expand...

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.
 
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 ?
Click to expand...

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