Windows 10: Saving an MS Execl csv to a txt file

  1.    04 Nov 2015 #1

    Saving an MS Execl csv to a txt file


    Ok I am a bit stuck here as I need to save a very large csv file to a txt file that has a certain format for it to be used in another application as an import file, I will attach the sample csv files here

    My sheet will look like this

    Click image for larger version. 

Name:	2015_11_04_17_29_211.png 
Views:	13 
Size:	10.2 KB 
ID:	46311

    And the saved txt file needs to look like this in this format with the first line reflecting the same headings as below.

    Saving an MS Execl csv to a txt file Attached Files
      My ComputerSystem Spec


  2. Posts : 407
    Windows 10 Pro x64, Windows 7 Ultimate x64 SP1, Windows 8.1 Pro x64
       04 Nov 2015 #2

    After you open the .csv file in Excel, select save as and use the pull down menu next to select Save as type and pick Text
      My ComputerSystem Spec

  3.    04 Nov 2015 #3

    pbcopter said: View Post
    After you open the .csv file in Excel, select save as and use the pull down menu next to select Save as type and pick Text
    Yes but the save formatting needs to be the same as the sample file screen shot with all the " " and , in the correct position and this is the issue I am having here
      My ComputerSystem Spec


 

Related Threads
Saving Pictures in General Support
I am having trouble saving pictures to my "Pictures" folder. I right click on the picture sent to me via e-mail, Facebook, etc I click "Save Link As". I rename the picture and try to save it to my "Pictures" Folder. It says that I do not have...
Saving for a new build in PC Custom Builds and Overclocking
okey so i have most parts layed out.. after coming to the conclusion that i was to change out a processor from 4th gen to 5th gen.. now im having trouble finding a motherboard that accepts *2011-V3 Socket* and actually works with or is backwards...
Saving StartScreen in General Support
I would like to save my startscreen (the one I see if I click theWindows icon button left corner). In Win 8.1 I use the following procedure: Step 1: Open the Run dialog box by hitting Windows key + R. Step 2: Type,...
Just upgraded to Win 10. Under Win 7 I had all my music stored on a NAS. I can get windows to use the music from there - although ti's been intermittenet sometimes telling me there is no music.... However, I want to set the NAS as the default...
Saving the esd file in Installation and Upgrade
Hi When Windows 10 downloads a new build from Windows Update, how can I save the esd file to create an installation DVD running on each computer? Thanks Bye
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 18:48.
Find Us