Uploading a Numbers spreadsheet to Sunrise

Uploading a Numbers spreadsheet to Sunrise

Uploading a Numbers spreadsheet to Sunrise

Are you using a Mac and Numbers? We got you covered.

Here's the proper way to upload spreadsheets using Numbers on Mac. Thanks to one of our Facebook Community Members who shared her experience! 

  1. Make sure the spreadsheet is in CSV format. 

  2. The date column needs to be in this format: 12/15/16. 

  3. Go to Inspector, and under cell, you have a dropdown with an option to change it.

  4. Pick the proper formatting. 

  5. If you have commas in the spreadsheet, use the FIND and REPLACE feature. 

  6. Put "," in the FIND and REPLACE keep it empty. It will remove the commas. 

  7. Then erase the $ sign. 

  8. Go in Inspector and under Cell change from CURRENCY to NUMBER. 

This should allow for proper importing. :)

    • Related Articles

    • How to Import Contacts into Sunrise

      Overview With Sunrise, you can create a contact manually, and you can also import your contacts in bulk. This is a great method if you're switching over to Sunrise from a different accounting tool and want to transfer your contacts in bulk into ...
    • Sunrise Plus - FAQ

      Your Sunrise Plus FAQ's  Overview Sunrise Plus is a premier, do -it- yourself software package for bookkeeping. It takes several newly released features, tools, and bundles them together. With Sunrise Plus, you get all the essentials to make expense ...
    • Creating your 1st Sunrise invoice

      So you are getting started with Sunrise. You've completed all the setup and you're ready for your first invoice? Well, let's get started. Go to the Invoices home page  Some quick notes about the Invoices home page.  See the five sections below? They ...
    • How to: Set up Sunrise Pay on the Mobile App

      Users of Sunrise have access to Sunrise Pay, which is an easy and secure way to accept credit cards and ACH bank transfers for your business’ invoices. You can set up Sunrise Pay on desktop, but now you can also set it up right from the Sunrise App ...
    • How Sunrise estimates your taxes

      How Sunrise estimates your taxes Written by Success-Team Updated over a week ago Where do you find your quarterly tax payment amounts? Every year, when you file your tax returns, the IRS sends you quarterly tax estimates on half-page payment ...