Xero to Excel - using API


Design and build tool which extracts data from Xero ([url removed, login to view]) using their API and enables user to write SQL queries and export the data into Excel for presentation and further analysis. Ability to upload non-Xero data to online database and which can be queried alongside data from Xero. At this stage no data to be pushed into Xero.

Simple documentation to be provided on how to set-up end solution (if appropriate).

Preferred method of linking to Xero, using Public Application » [url removed, login to view]

Useful information:

Xero API » [url removed, login to view]

PHP Library » [url removed, login to view]

Possible ideas for linking database to Excel:

1. SQL drill » [url removed, login to view]

2. MS Query

Looking at this as a proof of concept and could be the start of a long term relationship - our aspirations for the future are (these points should be taken into consideration but not costed at this stage):

1. Create simple user interface that enables user to query without SQL knowledge;

2. Develop suite of standard reports to be viewed online and incorporates graphs/visuals;

3. Extend API to extract data from other online systems.

Skills: Excel, MySQL, PHP, Software Architecture

See more: xero excel, sql query xero, php export xero, export xero excel, export xero add excel, can extract excel xero, xero data extract, xero export excel, xero excel data api, winadmin, php to excel export, php api developer tool, online sql developer tool, how to write reports, how to write a simple blog, how to start online blog, how to start developer in excel, how to set up a blog, how to graphs, how to develop a blog, how to create database using php, graphs online, graphs design online, excel for data analysis, design and drill

Project ID: #4267552

14 freelancers are bidding on average $1182 for this job


Hi, We have designed and built websites for various types of businesses very effectively. We work with all of our clients individually to easily coordinate and to keep track of the requirements and scope. We fulfill y More

$1750 USD in 35 days
(223 Reviews)

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$750 USD in 7 days
(225 Reviews)

Please check your inbox. Thanks

$1400 USD in 20 days
(61 Reviews)

I will be happy to create this web application for you. Have a great experience with API using oAUTH. Also have great experience with PHP, MySQL,Javascript, jQuery and Excel. Hope to do business with you. Thx !

$1100 USD in 16 days
(91 Reviews)

Hello, I am very interested. I am familiar with oauth both version 1 and 2. Kindly please let me know more detail on what kind of information need to be retrieved using that api? All of available on api or just p More

$1500 USD in 30 days
(13 Reviews)

Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. ! With a good Profile in Freelancer and experience of over seven years in the Software Aren More

$750 USD in 30 days
(19 Reviews)

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te More

$1300 USD in 25 days
(5 Reviews)

Hello sir! Please check our portofolio. Thank you!

$750 USD in 4 days
(0 Reviews)

Will provide you browser-based interface which will extract data from xero and upload into excel. Pay me on 100% satisfaction

$1500 USD in 30 days
(0 Reviews)

Hello Sir, Greeting of the Day!! I am a civil engineering professional with exceptional command over MS applications. I am also assisted by an MBA (Finance), MBA (HR & Marketing), and an Electrical Engineering pr More

$1000 USD in 20 days
(0 Reviews)

KCSPL is a Software Development IT Consulting Services Provider,Serving the Industry Since 11 years

$2500 USD in 35 days
(0 Reviews)

We need to discuss further so that we could start the project as soon as possible. Waiting for your chat invitation and further communication on project requirements. Thanks and regards.

$750 USD in 3 days
(0 Reviews)

Dear Sir, We have read your project specifications & We are confident to ensure your satisfaction in the form of completing the project.We will glad to help you. We are quite confident to get it done ontime. Please op More

$750 USD in 4 days
(0 Reviews)

We exist in world's Top 10 Virtual Assistant & Data Entry Companies*** Please check PMB for complete details.

$750 USD in 3 days
(0 Reviews)