Use Xero & EasyCSV Together
How to use EasyCSV to enable anyone to upload CSV/Google Sheet data into Xero.
Xero quick setup video
How to connect Xero to EasyCSV
- Log into EasyCSV
- Create a new sheet import page on EasyCSV.io using an example CSV file or Google Sheet of what you want to import into MySQL (shown how-to in video above).
- After the page is created, click the "Connect Xero Account" button or go into Sheet Details to connect your account.
- Then follow the directions below to map spreadsheet columns to the correct columns in MySQL.
How do I map spreadsheet column names to Xero columns?
Use the EasyCSV feature: "Field Mappings". You will find it at the top of your sheet import page if you are logged into EasyCSV and are the admin.
For each Xero field you want populated create a new field mapping.
Select the column value you want pushed into a specific Xero fields for invoices and more.