• Updated

How to import/export data without Windows Excel

The following are just two ways in which you can perform Imports without the use of Excel. The first is using Google Sheets and the second is Windows Notepad/Text Editor.

  • IMPORTANT: Before you start you will first need to download the template CSV File in which you are going to be using to perform the Import. See the following article for Importing Data into Procurify. Once you have the CSV File downloaded, move on to the next part.

 

Using Google Sheets

  1. Go to Google (Google.ca, Google.com, Google.co.uk, etc.) and click Sign In on the right side of the screen.

Sign_In.PNG

  1. Once you have completed the login you will be taken back to the Google Search screen, from there click the Google Apps menu on the right of the screen and then click Sheets.Google.PNG
  2. The Google Sheets screen will open, select a Blank sheet for a new spreadsheet to appear.Sheets.PNG
  3. Now, just like with Excel, you can open the CSV File downloaded earlier by going to File → Open and either locating your file or, performing a Drag and Drop.Drag_and_Drop.PNG
  4. Once the file has been opened you will see something like the following (this is an example of the Account Code Import.csv file).G-Sheet_View.PNG

 

 

Using Notepad 

  • NOTE: If you are going to be importing a lot of data this is NOT the best way to do so, each line must be typed out manually and you must remember to add a comma to separate the columns. Using Excel, Google Sheets or similar is the easiest and most convenient way.

 

  1. Locate the CSV File on your computer and right-click on it.
  2. In the menu that appears scroll through to find Open with → Notepad.Notepad.PNG

NOTE: If you do not see Notepad within the Open with section, select Choose another app and locate Notepad. 

 

  1. Notepad will open and list the headers of the CSV Template and each column will be separated with a comma as follows. * The image shows is of the Account Code Import.csv file*Notepad_View.PNG

 

  1. From here each line is a row and you would enter the data as follows: 1234, Meals, Expense. 
  2. The above notes the Account Code as 1234, the Account Description as Meals, the Type as Expense and then the remainder of the fields are blank.

 

 

Additional Information: 

  • Each Import has its own set of requirements so be sure to check and follow said requirements otherwise the Import may error out.
  • Import Data into Procurify