Reading:
How to Import CSV Into a Google Spreadsheet
Image

How to Import CSV Into a Google Spreadsheet

Ansley Fender
February 11, 2019

Spreadsheets are impressive tools for managing your finances.

However, no one wants to spend time manually entering their bank transactions into a spreadsheet.

If you don’t use Tiller to automate your financial spreadsheets, you can still export your bank data with a CSV file and import it into a Google spreadsheet.

What is a CSV File?

CSV, or comma-separated values, is a file type that contains a list of data separated by–you guessed it–commas.

These files allow for the data to be quickly and easily transported from one source to another. While you can open a CSV file with many different programs, the most commonly used program is a spreadsheet editor like Google Sheets.

How to Create a CSV File

To create a CSV file of your bank transactions, go to your bank’s website, locate the export feature, and choose CSV from the available file types.

When you export the file, it will appear in the downloads folder in your computer’s file explorer.

To make it easier to locate the file later, find it in your downloads folder and transfer it to your Documents or Desktop folder.

How To Paste CSV Into Google Spreadsheet

To get your CSV file into a Google spreadsheet:

  1. Open Google Sheets
  2. Choose “File” → “Import” → “Upload” → “Select a file from your computer.”
  3. Choose your CSV file from your Documents or Desktop folder.
  4. The following window will pop up. Choose “Import data.”

How to IMport CSV Into Google Sheet IMport File

How To Clean Up A Spreadsheet CSV File

The imported data will look ugly. There will be extra information you probably won’t need, and the information you do need won’t be formatted correctly.

How to IMport CSV Into Google Sheet Clean Up File

Get rid of what you don’t need

Start by removing the columns you don’t need. Right click on the column letter. In the pop-up menu, choose “Delete column” to get rid of the data or “Hide column” if you don’t want to see the data but think you may find it useful later.

How to IMport CSV Into Google Sheet Combine Files

Use the CONCATENATE formula to combine columns

Some banks import the debits and credits in different columns, which isn’t ideal for a budget spreadsheet. To combine the data into one column, add a column to the left of the debit column by right clicking on the column letter and choosing “Insert 1 left.”

Next, use CONCATENATE formula. CONCATENATE allows you to combine the data in multiple columns without manually copying and pasting or retyping each cell.

Because of the syntax, the formula is slightly different for the debits than it is for the credits.

For the debits:

=CONCATENATE(TEXT(C2,”#.00″),TEXT(D2,”#”))

For the credits:

=CONCATENATE(TEXT(D2,”#.00″),TEXT(C2,”#”))

Once your data is combined, you can hide the original debits and credits columns. Be careful not to delete them; if you do, the data for the CONCATENATE function will be erased.

By following these steps to import CSV into a Google Sheet, you can quickly create a budget spreadsheet or import bank data into your Tiller budget.


1 Comment
  1. Use Google Sheets to Build Your Emergency Fund in 5 Steps
    February 22, 2019

    […] If you already track your budget in a spreadsheet, this step will take no time at all. If you use an app or other software, there may be an option to download your spending history in a CSV file that can then be converted to a Google Sheet. […]


Leave a Reply

Related Stories

Google-Two-Factor-Authentication
December 15, 2018

Keep Your Email Safe With Google’s Two-Factor Authentication

There’s a fix that goes a long way to making email and other accounts far more secure: two-factor authentication. Here's how to use it.

February 28, 2019

Visualize Spending as Hours of Work With This Free Google Sheet

Here's a simple formula for Google Sheets that translates your spending into the hours you had to work to perform to afford everything.

Google Keep in Google Sheets
February 27, 2019

How to Use Google Sheets With Calendar, Keep, and Tasks

5 suggestions for using Google Sheets with Keep, Tasks, and Calendar, now that they're instantly accessible in the spreadsheet side panel.

Arrow-up