Results 1 to 6 of 6

Thread: Excel spreadsheet - to convert to CSV for Easyfile import

  1. #1
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    328
    Thanks
    53
    Thanked 90 Times in 64 Posts

    Excel spreadsheet - to convert to CSV for Easyfile import

    Hello,
    I would like to know if there is anyone out there that can assist us to create, from an existing Excel Spreadsheet, the correct data fields in CSV format to be imported into Easyfile for emp501 recon purposes.
    We have a recon template (excel) that we use and need to link this to the correct fields and then create the CSV file.


    I have search the internet and apart from Laurence Lombard's website (member on this forum), the only other place where I found anything that might help is "Open Office.org Community Forum", but I don't know this program and tried to figure it out...but no success in the end.

    You can email me direclty - private message via my profile.

    Thanks.
    Christel
    always fear when Christel is near....

  2. #2
    Diamond Member Justloadit's Avatar
    Join Date
    Nov 2010
    Location
    Johannesburg
    Posts
    2,671
    Thanks
    88
    Thanked 544 Times in 460 Posts
    Blog Entries
    1
    In excell you can move the rows and columns as you see as they should be to import to match your final destination, once you have done this, you copy the sheet and paste the "amounts" only to a new spread sheet, then do a save as, on the file type select CSV. The file will then be saved with a comma after each variable in a line, and a new line of information for each column.
    Victor - Knowledge is a blessing or a curse, your current circumstances make you decide!
    Solar and LED lighting solutions - www.microsolve.co.za

  3. #3
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    328
    Thanks
    53
    Thanked 90 Times in 64 Posts
    Thanks for the comment ... but it's unfortunately not that simple. There ae different numeric fields and criteria that SARS has prescribed and for me its GREEK to say the least... if anyone can assist my company to create a sheet that can be linked to our standard recon template, we will be glad to pay for your services.

    Thanks.
    always fear when Christel is near....

  4. #4
    Gold Member IMHO's Avatar
    Join Date
    Jan 2012
    Location
    NW
    Posts
    538
    Thanks
    11
    Thanked 52 Times in 47 Posts
    we will be glad to pay for your services.
    What would something like that be worth?
    ~Expenses will eat you alive! - My first Boss~

  5. #5
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    328
    Thanks
    53
    Thanked 90 Times in 64 Posts
    Well, it will save me valuable time that can be spent on other issues. Roughly calculated, time saved about 180 hours. What it would be worth to me....let's see... less grey hair, less stress, less frustration, = definately more worth than any amount of money...
    But then again, I don't make the final decisions...

    thanks IMHO for the contact person...!
    Last edited by Christel; 22-Mar-13 at 09:41 AM.
    always fear when Christel is near....

  6. #6
    Junior Member
    Join Date
    Apr 2013
    Location
    KZN
    Posts
    23
    Thanks
    7
    Thanked 0 Times in 0 Posts
    I am sure any basic programmer might be able to do this for you but do not really see the need as MS Excel can convert files directly to CSV and vice versa. How many columns are we talking about and how many rows of data? Does the output file require headers or just the data?

Similar Threads

  1. Easyfile CSV format document and example spreadsheet
    By Laurence Lombard in forum Tax Forum
    Replies: 10
    Last Post: 30-Oct-17, 12:06 PM
  2. Excel spreadsheet for VAT reconciliation
    By JaunetteK in forum Accounting Forum
    Replies: 17
    Last Post: 07-Jun-17, 07:03 AM
  3. Import Excel into pastel Cash book
    By ultramel123 in forum Accounting Forum
    Replies: 18
    Last Post: 23-Oct-15, 09:46 AM
  4. Convert CC to PTY
    By OB4 in forum General Business Forum
    Replies: 4
    Last Post: 06-Aug-09, 07:35 AM
  5. Convert Word to Pdf
    By Faan in forum Technology Forum
    Replies: 13
    Last Post: 11-Dec-08, 02:08 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

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