+ Reply to Thread
Results 1 to 10 of 10

Problems with csv files

  1. #1
    Registered User
    Join Date
    03-04-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    3

    Problems with csv files

    Hi

    Im working for the first time with a csv file during a Shopify project. I have imported a standard shopify csv and filled in my info, but when saving it as a csv file it losses its structure. Below you can se how it's different from the example file when previewing it. The last picture is how it looks like in excel.
    Anyone knows what to do?



    Skærmbillede 2013-03-04 kl. 13.36.25.png
    Skærmbillede 2013-03-04 kl. 13.35.43.jpg
    Skærmbillede 2013-03-04 kl. 14.05.12.jpg

    Cheers

  2. #2
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: Problems with csv files

    What u all need to do is :

    1) Select the Column
    2) press ALT+D+E
    3) Select DELEMITED, then click on NEXT
    4) Then Click on SEMICOLON, & in last click on finish

  3. #3
    Registered User
    Join Date
    03-04-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Problems with csv files

    Thanks for your reply.
    Im on a mac, so when I press the shortcut, this happens:
    Skærmbillede 2013-03-04 kl. 14.22.07.jpg

  4. #4
    Forum Contributor
    Join Date
    02-28-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    272

    Re: Problems with csv files

    In that case go to DATA then click on Text to Columns

  5. #5
    Registered User
    Join Date
    03-04-2013
    Location
    Copenhagen
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Problems with csv files

    I tried it, but it still doesn't seem to have the structure.
    I have uploaded the file here: http://gupl.dk/692842/
    If you have time i would really appreciate if you could take a look at it

  6. #6
    Registered User
    Join Date
    03-04-2013
    Location
    brisbane
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Problems with csv files

    thanks for the all stuffs,it is good post

  7. #7
    Registered User
    Join Date
    03-04-2013
    Location
    brisbane
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Problems with csv files

    hi please share your thinking to this forum bye

  8. #8
    Registered User
    Join Date
    03-04-2013
    Location
    brisbane
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Problems with csv files

    hi the post really helps me thanks

  9. #9
    Registered User
    Join Date
    03-04-2013
    Location
    brisbane
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Problems with csv files

    hi i follow your post and also like it

  10. #10
    Registered User
    Join Date
    03-04-2013
    Location
    brisbane
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Problems with csv files

    so finally thanks for all your helps through forum

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1