1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Importing CSV File Into Excel

Discussion in 'Keyword Tracker' started by loki, Jul 14, 2005.

  1. #1
    where can i find support on how to import the csv file into excel?

    i have done it but excel puts all info from each row into the first column.

    i then tried 'get external data' in MSaccess and it looks good but at the last minute get a "text file specification field seperator matches decimal seperator or text delimiter" message (i chose comma as the seperator).

    i choose OK and get "an error occured trying to import whatever.txt. the file was not imported."

    thanks
    loki, Jul 14, 2005 IP
  2. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    36,106
    Likes Received:
    2,236
    Best Answers:
    388
    Trophy Points:
    710
    Digital Goods:
    27
    #2
    You shouldn't need to do anything special. Maybe give the file a .csv file extension (if it doesn't have one already).
    digitalpoint, Jul 14, 2005 IP
  3. cobraguy

    cobraguy Peon

    Messages:
    18
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ya, this one bugged me...more because it was assumed eveyone knows how to do it.

    Open excel..(just excel not by clicking the file) and go to "data"..."import external data"..."import data" ...search for the file and open.

    There are a couple other wierd things it requests for but that will get you 99% of the way!
    cobraguy, Jul 15, 2005 IP