Up to now, you could import list data from Excel into QuickBooks Online, but recently QBO added the capability of importing data from Google Sheets. Since more and more people have switched to online platforms like Google solutions, it seems only natural that QuickBooks would let users upload data from these solutions.
At present, users can upload data from Google Sheets to QBO with the same ease as Excel. This includes list data for Customers, Vendors, Chart of Accounts, as well as Products and Service.
The follow summarizes the steps when importing this type of list data into QBO from Google Sheets.
1) Select the QuickBooks Online Gear Icon
2) Choose Import Data
3) Select the Type of data to import
4) Connect Google Sheets with QuickBooks Online
5) Confirm Authorization for Intuit to sync with Google Sheets
6) Select your Google Sheets file
7) Map file (data) fields to import into QuickBooks (data) fields
8) Click the green 'Import' button to initiate the actual import
By using these steps you can easily integrate your much of your Google Sheets list information directly into QuickBooks Online without having to spend time performing manual data entry. If you still use Excel, don't worry, the process of importing from Excel hasn't changed at all. This is simply a new, exciting and additional method of importing data into QBO for those of us who have elected to use Google Sheets as our cloud-based spreadsheet of choice.