1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How can I make a .csv spreadsheet copy the text with the commas to a text file?

Discussion in 'Black Hat SEO' started by schleprock, Mar 16, 2017.

  1. schleprock

    schleprock Regular Member

    Joined:
    Apr 10, 2014
    Messages:
    438
    Likes Received:
    26
    domain,username,password,email

    I need to get my spreadsheet information into a .txt file so I can import them into AutoFill Magic (AFM).

    When I do a copy and paste from a .csv spreadsheet I don't get the commas, just a space.
    Is there a quick way to get commas into the appropriate place?

    (the spreadsheet they are in is from an automated tool, but it doesn't export to .txt)

    EDIT:
    I tried Text Mechanic and cut and pasted the columns in seperately and added the suffix of a comman but when i put them back into the spreadsheet they looked fine but when I cut all the columns with the commas in them into a .txt file it still leaves a big space (although it does have the comma)
     
    Last edited: Mar 16, 2017
  2. Ettienne

    Ettienne Jr. VIP Jr. VIP

    Joined:
    Mar 3, 2017
    Messages:
    147
    Likes Received:
    22
    Gender:
    Male
    Home Page:
    Google "Text Import Wizard" for excel. There should be a support page that will offer a more advance resolution to your query.
     
  3. divok

    divok Senior Member

    Joined:
    Jul 21, 2010
    Messages:
    1,056
    Likes Received:
    644
    Location:
    .IN
    either use text import wizard as mentioned above or in notepad / notepad++ replace space with commas .
     
  4. abraarukuk

    abraarukuk Junior Member

    Joined:
    Mar 13, 2017
    Messages:
    174
    Likes Received:
    28
    Gender:
    Male
    Occupation:
    Planning Engineer
    Location:
    Italy
    There are two ways to import data from a text file by using Microsoft Excel: You can open the text file in Excel, or you can import the text file as an external data range. To export data from Excel to a text file, use the Save As command.

    There are two commonly used text file formats:

    • Delimited text files (.txt), in which the TAB character (ASCII character code 009) typically separates each field of text.

    • Comma separated values text files (.csv), in which the comma character (,) typically separates each field of text.
    You can change the separator character that is used in both delimited and .csv text files. This may be necessary to make sure that the import or export operation works the way that you want it to.
     
  5. HoNeYBiRD

    HoNeYBiRD Jr. VIP Jr. VIP

    Joined:
    May 1, 2009
    Messages:
    6,954
    Likes Received:
    7,984
    Gender:
    Male
    Occupation:
    Geographer, Tourism Manager
    Location:
    Ghosted
    There are different ways to do this.

    If you go with the copy-pasting route, you just need to replace the empty space/separators with commas.
    Paste the content of the .csv into an empty Notepad++ file, hit Ctrl+H, this will bring up the Replace window, put an empty space in the "Find what" field, a comma in the "Replace with" field and hit "Replace all".
    It can be that the separator when you pasted the content into Notepad++, is not an empty space, just looks like it. In that case just copy-paste the separator into the "Find what" field, so Notepad++ can replace it with commas.
     
  6. kullaravi

    kullaravi Junior Member

    Joined:
    May 1, 2011
    Messages:
    102
    Likes Received:
    22
    Open the .csv file in a text editor like notepad++ and save as .txt.