Results 1 to 4 of 4
  1. #1


    Member Since
    Dec 12, 2005
    Posts
    68
    import online text in .csv format
    I am trying to import a list of words from an online web page using a .csv (comma separated value) import option on the web page.

    When I click on the .csv option on the web page, I have tried to import the text with various software, including TextEdit, TextWrangler, and Microsoft Word and Excel for Mac. Both Word and Excel offer .csv support but I have not been able to import the text list in the desired fashion.

    Here is how the text currently imports (vertical arrangement):

    word1
    word2
    word3

    Here is how I need the text to import (horizontal arrangement with commas):

    word1,word2,word3

    Any tips on how I can import text in the desired horizontal fashion are greatly appreciated.

  2. #2

    xstep's Avatar
    Member Since
    Jun 25, 2005
    Location
    On the road
    Posts
    3,231
    Specs:
    2011 MBP, i7, 16GB RAM, MBP 2.16Ghz Core Duo, 2GB ram, Dual 867Mhz MDD, 1.75GB ram, ATI 9800 Pro vid
    I can't say 'for sure', but it sounds like the csv file is not set up correctly. Or you are expecting something from what the creator intended. If you think the csv file is wrong, contact the creator.

    A simple way to check it is to open up Terminal.app, type the word, cat, at the command line and drag the file to the terminal window, then hit the return key. If you get what you have described, a word per line, then there are inappropriate end of line characters after each field. The only way I can think to fix that is to write a script.

    Perhaps Excel has a custom import option. Maybe TextWrangler has the ability to create a repetitive macro.

    If the number of words per row are exactly the same, then a script is easy enough to write. If the number of words vary, then one needs to know the data to have a chance to fix it.

  3. #3


    Member Since
    Dec 12, 2005
    Posts
    68
    The text on the web page is arranged in a single column of words (top to bottom), so perhaps the .csv file is just following this arranged format of the words from the web page. So I'm importing these words or short phrases (1-3 word strings) that appear as a list on the web page.

    Perhaps the best way to illustrate this is to visit the web page I'm dealing with. The web page address is below, but takes a quick explanation as to how to create the .csv download option.

    Once the user has reached the web page, there is a blank box into which the user types any word or phrase, like "receipes", "car mechanics" or "spring fashions" (type without quotes). Then a list of complimentary words appear related to that original word or phrase. On the right hand side of the word list is an "add" link that allows the user to add the words to a "selected keywords" list on the right hand side of the screen. For the purposes of a test, a user could just add the top 3-4 words or phrases.

    Now the .csv option is functional, and also appears on the right hand side of the screen, along with the selection of words or phrases to import.

    Here is the web page address:

    https://adwords.google.com/select/KeywordToolExternal

  4. #4

    xstep's Avatar
    Member Since
    Jun 25, 2005
    Location
    On the road
    Posts
    3,231
    Specs:
    2011 MBP, i7, 16GB RAM, MBP 2.16Ghz Core Duo, 2GB ram, Dual 867Mhz MDD, 1.75GB ram, ATI 9800 Pro vid
    Looking at the page result and the csv file, I'd say they match. The words are in one column in both. You'll need to write a script to separate them further.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to Import a .csv list into contacts? Groups?
    By Gump Redhouse in forum Switcher Hangout
    Replies: 2
    Last Post: 10-29-2012, 10:40 PM
  2. Export MAC contacts in CSV file format??
    By greendragonflyz in forum Switcher Hangout
    Replies: 1
    Last Post: 09-27-2012, 03:13 PM
  3. Import Mail Messages from CSV
    By JackCane in forum Switcher Hangout
    Replies: 1
    Last Post: 05-15-2011, 01:39 PM
  4. Please help with CSV file import?
    By davidbanks in forum OS X - Operating System
    Replies: 3
    Last Post: 05-01-2010, 07:46 AM
  5. Microsoft Entourage - CSV Contact Import
    By leehume in forum Switcher Hangout
    Replies: 1
    Last Post: 05-13-2009, 05:36 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •