Be careful not to delete them if you do, the data for the CONCATENATE function will be erased.īy following these steps to import CSV into a Google Sheet, you can quickly create a budget spreadsheet or manually import your bank data into your Tiller Money-powered spreadsheet.The new spreadsheet with the data from the CSV file will be automatically loaded after being created. Once your data is combined, you can hide the original debits and credits columns. CONCATENATE allows you to combine the data in multiple columns without manually copying and pasting or retyping each cell.īecause of the syntax, the formula is slightly different for the debits than it is for the credits.įor the debits: =CONCATENATE(TEXT(C2,'#.00'),TEXT(D2,'#'))įor the credits: =CONCATENATE(TEXT(D2,'#.00'),TEXT(C2,'#')) 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.” Some banks import the debits and credits in different columns, which isn’t ideal for a budget spreadsheet. Use the CONCATENATE formula to combine columns

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. Start by removing the columns you don’t need. There will be extra information you probably won’t need, and the information you do need won’t be formatted correctly. Choose your CSV file from your Documents or Desktop folder.Choose “File” → “Import” → “Upload” → “Select a file from your computer.”.To get your CSV file into a Google spreadsheet:

To make it easier to locate the file later, find it in your downloads folder and transfer it to your Documents or Desktop folder. When you export the file, it will appear in the Downloads folder in your computer’s file explorer. 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. While you can open a CSV file with many different programs, the most commonly used program is a spreadsheet editor like Google Sheets. These files allow for the data to be quickly and easily transported from one source to another.

Open csv in google sheets