How to Import an Excel File Into Quicken

by Martin Williams
Importing data from Excel into Quicken is an easy process.

Importing data from Excel into Quicken is an easy process.

Quicken is one of the more popular financial programs used today. The software offers users ways to organize their finances and keep track of expenses. Microsoft Excel is a versatile spreadsheet program that can be used to keep track of finances. Importing financial data from an Excel spreadsheet into Quicken will help you keep your information synced.

1

Open up the Quicken program. In the "Property & Debt" menu, click on "Quicken Home Inventory."

2

Click on "File Menu," then choose "Import."

3

Choose "Comma-separated" or "Tab-separated." This will depend upon the type of Excel file you used. Select the Excel file you would like to import.

4

Click "Open" to open the Excel file. In the "Import" window, make sure the column names on the imported spreadsheet are the same as the field names in Quicken Home Inventory.

About the Author

Martin Williams is a freelance writer and blogger who has written for his own blog and various other websites. Williams has a bachelor's degree in biology from Norfolk State University. His writing specializes in sports and politics.

Photo Credits

  • photo_camera Stockbyte/Stockbyte/Getty Images