Import WhatsApp messages into excel in real time

Shodi

Board Regular
Joined
May 24, 2016
Messages
51
Hi everyone, I have been recently asked if it is possible to import messages from WhatsApp to excel in real-time.

This person runs a catering business and receives orders via WhatsApp but as you can guess there is no specific format in which his customers send the order messages and his order management system is at present a whirlwind, very prone to errors like customers being sent the wrong dish or the amount delivered not matching the customers' requirements.

He would like to be able to

1) import the messages into excel
2) Sort and filter the orders into categories based on item type, size, number and price.
3) Be able to issue order receipts
and a few other procedures.

The first requirement has me stumped... Is there any way to do this?

Thanks in advance.
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Dan_W

Active Member
Joined
Jul 11, 2018
Messages
380
Office Version
  1. 365
Platform
  1. Windows
Could you not use MS Forms to do this? It seems like it would solve quite a few of the problems you've listed above and I can't imagine it would take long to make the form. The key benefit would be is that it automatically creates and updates an Excel spreadsheet of the form data for you.
 

Watch MrExcel Video

Forum statistics

Threads
1,128,129
Messages
5,628,865
Members
416,347
Latest member
AT2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top