Previous 1 2 3 4 Next 50 Replies Latest reply: Apr 22, 2015 9:14 AM by pjmarch Go to original post
  • donaldo777 Level 1 Level 1 (20 points)

    In order to change Decimal Point on your computer, you have to go through a series of hidden buttons.

    Here are instructions on where to find what you need:

    Open System Preferences, click on the 'Language & Text' Icon.

    At top of dialog box it defaults to "Language' ... you need to click on 'Formats' tab.

    Here you will find 'Customize ... ' Buttons

    Click on Customize button to the right of 'Numbers'

    Finally.

    Here is where you change your decimal point settings.

  • ThisMoment Level 1 Level 1 (0 points)

    This isn't working for me... I've dragged the cvs file onto an open spreadsheet and it just puts the data within one column and seperate rows.

     

    The data within the csv is seperated by semicolons and i'm in the US.

     

    Please help.

  • Wayne Contello Level 6 Level 6 (15,240 points)

    This.

     

    Just so you know... CSV stands for COMMA Separate Values.  Since the file you are attempting to read in as a CSV is using a semi-colon as the delimter Numbers does not know what do do.  Open the file in a text editor and replace the semi-colons with either commas or tabs.

     

    If both of those are characters are in "cells" then this may be a challenge.

  • ThisMoment Level 1 Level 1 (0 points)

    Thank you, Thank you, Thank you!

  • akademisalpeter Level 1 Level 1 (0 points)

    Taken from wikipedia:

    A comma-separated values (CSV) (also sometimes called character-separated values, because the separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text form.

    In Europe most countries use comma as the decimal separator, so the caracter mostly used to separate values is semicolon (;).

    If you have problems, try switching in System Preferences > Language and text > Formats and then restart Numbers so it uses the new preferences.

  • bamajr Level 1 Level 1 (0 points)

    The latest version of Numbers, doesn't even allow you to drag/drop .CSV files, on an open spreadsheet (tested with a .CSV which was tab delimited).

     

    I'm a sell-out for all things Apple. However, when I have to do conversion, especially with large .CSV files, I'll use LibreOffice's Spreadsheet, instead of Numbers. It works better. I can simply choose to change the type of delimiter used and I can do that, on the fly, to see a preview, of how the document will be imported. This is way more user-friendly and saves way more time.

     

    http://www.libreoffice.org

  • Jerrold Green1 Level 7 Level 7 (29,925 points)

    akademisalpeter wrote:

     

    Taken from wikipedia:

    A comma-separated values (CSV) (also sometimes called character-separated values,...

    Aka,

     

    There was a time when, in my experience, there were two popular formats in the U.S., Tab Separated Values (TSV) and Comma Separated Values (CSV). Wikipedia is taking a broader view, and that's fine, but some of us can't shake what we grew up with.

     

    These two varients have been treated differently in Numbers, but how they are treated has never been very well described in the documentation. It does appear that the behavior is different in Version 3.0. Different, but not gone.

     

    Jerry

  • Alain Joaris Level 1 Level 1 (5 points)

    Honestly I don't understand why such a simple function that is working very well with OpenOffice or Microsoft Office cannot be implemented in Numbers. Most banks in Europe do either offer a Quicken (QIF) or a CSV export format (with semicolumn in lots of cases).

     

    Now using OpenOffice...

  • SGIII Level 5 Level 5 (5,590 points)

    Hi Alain,

     

    CSV import is already easily done with Numbers, using an AppleScript.  See this thread , where you can download the script and/or Automator Service that incorporates the script so it shows up in your menu.  If you need to use semcolon as a separator, just substitute {separator: ";"} for {} on the line indicated.

     

    If you need OFX or QFX let me know and I'll post script.

     

    SG

  • Alain Joaris Level 1 Level 1 (5 points)

    Hi,

     

    Thanks a lot for the hint.  Indeed using AppleScript makes everything possible.  Bought the books, but haven't started with it.  Certainly a good opportunites.

     

    Appreciated.

     

    Alain

  • ciao_alexisb Level 1 Level 1 (5 points)

    Unbelievable that something so basic is not supported by Numbers, I´m shocked.

  • CThomasD Level 1 Level 1 (0 points)

    Hi All,

     

    If you are downloading a statement from your online account, you can download it in an excel format.  When you "Open In Numbers," it converts the sheet to a numbers format.  Iwork reads the Office formats so they can work together on different platforms.  I have found this the easiest way to import data.

  • SGIII Level 5 Level 5 (5,590 points)

    The release notes to Numbers 3.2 (just out yesterday) describe improvements to CSV import:

     

    • Drag and drop a CSV file directly into a sheet
    • Automatically update an existing table by dragging in a CSV file

     

    Haven't had a chance to test the improvements. But between that (and, if necessary, easy-to-use AppleScripts) Numbers users need not fear they cannot easily get CSV data into their documents.

     

    SG

  • Olivke Level 1 Level 1 (0 points)

    Tested and doesn't work. While it was working on previous Number version

     

    A shame to Mac (again)

     

    If Steve was still there those kind of lazyness from devs wouldn't have happened

     

    I have to send my csv to a friend who has a Windows and then he has to send me back to me the xls file

     

    What a shame

     

    This is decreasing of quality guys, since 1988 I am with Mac and very disappointed every upgrade is done

  • Andrew Bingham Level 1 Level 1 (20 points)

    Dragging and dropping the file does work, however I had to add the '.csv' file extension onto the file name to make it work.

     

    Originally, the exported csv file didn't have the extension and numbers didn't recognise it, but after changing the name, it worked seemlessly.