Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Create a .csv file

16 Feb 2016   #1
DickH

Windows 7 64 bit
 
 
Create a .csv file

I need to create a .csv file. How can I do it? I do not have Excel.


My System SpecsSystem Spec
.
16 Feb 2016   #2
ThrashZone

Win-7-Pro64bit 7-H-Prem-64bit
 
 

Hi,
There are freeware you could use Open Office...
Google doc's is free and a lot of people already use Chrome.
https://www.google.com/docs/about/
My System SpecsSystem Spec
16 Feb 2016   #3
whs
Microsoft MVP

Vista, Windows7, Mint Mate, Zorin, Windows 8
 
 

My System SpecsSystem Spec
.

16 Feb 2016   #4
DickH

Windows 7 64 bit
 
 

Quote   Quote: Originally Posted by ThrashZone View Post
Hi,
There are freeware you could use Open Office...
Google doc's is free and a lot of people already use Chrome.
https://www.google.com/docs/about/
Thanks. I made a new document and put my list in it, but there is no "Save As" or any way to save it as a .csv document.
My System SpecsSystem Spec
16 Feb 2016   #5
UsernameIssues

W7 Pro SP1 64bit
 
 

If you are using OpenOffice, then you should put your list into a document created by the Calc app.

You could also create a CSV file using Windows notepad app.

The list would look like:
Code:
Jones, Jackie, address
Smith, Sam, address
My System SpecsSystem Spec
16 Feb 2016   #6
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Comma Separated Values (csv) is the way the information gets separated within the document or whatever. If you want a program that can save a spreadsheet as a .csv file then you will need a spreadsheet program such as Excel or Open Office or another as shown in the above Posts.

You can make a csv type document in any word processor, as shown in Post #5, but it will not be shown as .csv file.
My System SpecsSystem Spec
16 Feb 2016   #7
UsernameIssues

W7 Pro SP1 64bit
 
 

Quote   Quote: Originally Posted by UsernameIssues View Post
If you are using OpenOffice, then you should put your list into a document created by the Calc app.

You could also create a CSV file using Windows notepad app.

The list would look like:
Code:
Jones, Jackie, address
Smith, Sam, address
Quote   Quote: Originally Posted by Ranger4 View Post
Comma Separated Values (csv) is the way the information gets separated within the document or whatever. If you want a program that can save a spreadsheet as a .csv file then you will need a spreadsheet program such as Excel or Open Office or another as shown in the above Posts.

You can make a csv type document in any word processor, as shown in Post #5, but it will not be shown as .csv file.
I'm not sure what you mean by that.

I figured that the OP needed to make a CSV file because that format was requested by some app or human. A CSV file created via notepad can be saved with the CSV file extension. The simplest way to do this is to put quotation marks around the file name when saving it. (e.g. "test.csv"). If you have Windows set to show file extensions for known file types, then you can easily rename a TXT file extension to CSV.

Once saved as a CSV file, double clicking on that file should give the user the opportunity to associate notepad with that CSV file extension (if needed).

If you are going to use CSV files a lot - then get an app like MS Office's Excel, LibreOffice's Calc or OpenOffice's Calc or one of the other free office suites. But for those that seldom use this file format, it is hardly worth installing an entire office suite.


I word suggest LibreOffice instead of OpenOffice.
My System SpecsSystem Spec
16 Feb 2016   #8
DickH

Windows 7 64 bit
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
... If you have Windows set to show file extensions for known file types, then you can easily rename a TXT file extension to CSV. ...
How do I set Windows to show file extensions ?
My System SpecsSystem Spec
16 Feb 2016   #9
Ztruker

Windows 10 Pro X64
 
 

Control Panel, Folder Options, View tab.
Uncheck Hide extensions for known filetypes.
My System SpecsSystem Spec
16 Feb 2016   #10
Ranger4

Windows 7 Home Premium 64 bit sp1
 
 

Quote   Quote: Originally Posted by Ranger4 View Post
Comma Separated Values (csv) is the way the information gets separated within the document or whatever. If you want a program that can save a spreadsheet as a .csv file then you will need a spreadsheet program such as Excel or Open Office or another as shown in the above Posts.

You can make a csv type document in any word processor, as shown in Post #5, but it will not be shown as .csv file.

I'm not sure what you mean by that.
I was referring to a file saved in Word that would automatically save it as a .doc or .docx file.
My System SpecsSystem Spec
Reply

 Create a .csv file




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
How to create .bat file to change the text in an .ini file?
I have the original Zoo Tycoon. It has no built in widescreen support, but it's possible to get it by changing some information in its .ini file. I don't want to leave it at that though, as I also have a 4:3 monitor, and I switch between the two. I don't want to have to go into the ini file and...
Gaming
ISO file. How to create one?
I am new to virtualization. I have VMWare Player on my system and I want to install XP Pro on a VHD using the player. I understand that I will need to create an ISO file to do this. All I have is the XP original CD and its product key. How to create this ISO file? I never did it...
Virtualization
why can't I create any file where I want it?
in xp whereever i right click i get to create a large number of new document types (depending on my software suite ofc) in 7 this only works in certain (very few) folders, in most i can only create a new folder (in which creating whatever seems to work) i read that on system partitions this is...
General Discussion
How to create a batch file that will move files based on the file type
How to create a batch file that will move files based on the file type? My Requirement : I need a batch file to copy all .doc files in all my HardDisk to a removable disk say (Z: drive) . Can anyone make it possible using a batch file?Please...Its urgent...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:35.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App