• Skip to primary navigation
  • Skip to main content

QBGarage.com

The QuickBooks Specialists

  • Home
  • Blog
  • KnowledgeBase
  • Company
  • Show Search
Hide Search
You are here: Home / Archives for CSV

CSV

Online Sources For Historical Exchange Rates

Chief Mechanic · August 25, 2010 ·

One of the best online sources we’ve found for historical foreign exchange rates is OANDA’s Historical Exchange Rates. Their data stretches back to 1990, and access is free.

They include multiple rates for each currency and can return data in HTML, ASCII, or CSV formats. A CSV format can be easily imported into Microsoft Excel for further analysis.

Vote This Post DownVote This Post Up (No Ratings Yet)
Loading...

Can I Import Data to QuickBooks From Microsoft Excel?

Chief Mechanic · August 23, 2010 ·

Yes, subject to certain limitations.

You can only import list data into 1 of 4 lists:

  1. Customers
  2. Vendors
  3. Items
  4. Accounts

You can import either in Microsoft’s supported workbook format (.xls or .xlsx, depending on your version of Excel) or CSV format.

Intuit offers a free Import Excel and CSV Toolkit, which includes a PDF manual, CSV and .XLS example import files, and a reference guide explaining field names. It’s a compressed executable file, which extracts those files when run. Additional information is available in this Intuit knowledgebase article.

You can use another import file type, Intuit Interchange Format (IIF), to import unlinked transactions. See our article on the capabilities of IIF files for more information.

Vote This Post DownVote This Post Up (+3 rating, 3 votes)
Loading...

Accounting

  • Financial Accounting Standards Board

Developer

  • Intuit Developer Network Forums
  • qbXML Onscreen Reference

Intuit

  • Enterprise Solutions
  • Intuit
  • Intuit Marketplace
  • QuickBooks
  • QuickBooks Online Community

QBGarage.com

Copyright © 2008–2022 QBGarage.com · Privacy · Terms & Conditions · Site Help