Ignore a line in a CSV file

E

Emil

Hi all,

is it possible to write a line in a CSV file in such a manner, that if
somebody open the file in Excel cannot read the line? I want to write
something like comments between lines, but this should not be visible in
Excel. For any idea thanks in advance.

Best Regards,
Emil
 
D

Dave Peterson

CSV files are plain old text files. So excel will see each line just like any
other.

There are ways that may work for you...

Rename the .csv file to .txt
Create a macro that opens the file (parsing the data the way you want).
Delete the lines you don't want to include in excel.

But if the lines are top secret, then this is not a good idea. Both .txt and
..csv files can be open in any text editor and viewed by anyone.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting to CSV with embedded line breaks 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Can I include functions in a CSV file? 5
Excel parsing unicode csv file 2
Creating a csv 4
Performing a comparison between two .csv files to extract data 0
Open .csv file and run a macro????? 4
.CSV Files 2

Top