Home

Live import of RS232-USB data into Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-1058716%22%20slang%3D%22en-US%22%3ELive%20import%20of%20RS232-USB%20data%20into%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1058716%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20I%20currently%20have%20an%20old%20PC%2C%20running%20an%20old%20version%20of%20Windows.%20I%20have%20a%20new%20machine%20on%20Windows%2010%2C%20with%20new%20Excel.%20I%20need%20to%20import%20data%20from%20an%20RS232%20(serial)%20communicating%20device%2C%20that%20I%20have%20hooked%20to%20a%20RS2332-USB%20converter.%20I%20had%20an%20old%20Basic%20program%20that%20took%20the%20data%20from%20the%20COM%20port%2C%20and%20imported%20into%20an%20excel%20spreadsheet%2C%20which%20does%20not%20work%20in%20Windows%2010.%20How%20do%20I%20get%20the%20data%20from%20the%20RS-232%20to%20USB%20converter%20into%20excel%2C%20so%20that%20I%20can%20format%20it%20properly%2C%20even%20have%20it%20properly%20formatted%20for%20entry%20to%20the%20sheet%3F%3C%2FP%3E%3CP%3ETo%20community%20members%3A%20I%20am%20willing%20to%20pay%20for%20a%20simple%20program%20that%20does%20what%20I%20need%20and%20runs%20on%20Windows%2010%20and%20Excel.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1058716%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1059730%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20import%20of%20RS232-USB%20data%20into%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1059730%22%20slang%3D%22en-US%22%3EI%20think%20you%20best%20search%20on-line%20using%20the%20brand%20and%20type%20of%20the%20connector%20on%20how%20you're%20supposed%20to%20get%20data%20from%20the%20peripheral%20you%20connected%20this%20way%2C%20hopefully%20there%20is%20some%20documentation%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060127%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20import%20of%20RS232-USB%20data%20into%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060127%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThanks%2C%20he%20peripheral%20is%20rather%20old%2C%20and%20I%20am%20using%20the%20prototcol%20they%20offer%2C%20RS232%2C%20which%20is%20working%20well%20with%20an%20old%20operating%20system.%20I%20am%20attempting%20to%20modernize%20the%20arrangement%2C%20by%20converting%20the%20rs232%20to%20USB.%20It%20is%20once%20the%20data%20is%20introduced%20to%20the%20PC%20that%20I%20do%20not%20know%20how%20to%20import%20into%20EXCEL.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1060308%22%20slang%3D%22en-US%22%3ERe%3A%20Live%20import%20of%20RS232-USB%20data%20into%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1060308%22%20slang%3D%22en-US%22%3EHmm%2C%20sorry%20for%20confusing%20things.%20I%20was%20thinking%20about%20documentation%20of%20the%20RS232%20to%20USB%20cable.%20It%20should%20normally%20come%20with%20a%20driver%20and%20have%20some%20form%20of%20documentation.%20Perhaps%20it%20adds%20a%20virtual%20COM%20port%20to%20your%20system.%20I%20know%20there%20is%20VBA%20code%20available%20that%20is%20able%20to%20receive%20data%20from%20COM%20ports%20using%20the%20RS232%20interface.%20See%3A%20%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Foffice%2Fen-US%2F0d05ec74-7f75-4fb3-ac28-30130c44cf3b%2Fexcel-2010-vba-send-and-receive-from-com1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2Foffice%2Fen-US%2F0d05ec74-7f75-4fb3-ac28-30130c44cf3b%2Fexcel-2010-vba-send-and-receive-from-com1%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
Hutch0000
New Contributor

Hello! I currently have an old PC, running an old version of Windows. I have a new machine on Windows 10, with new Excel. I need to import data from an RS232 (serial) communicating device, that I have hooked to a RS2332-USB converter. I had an old Basic program that took the data from the COM port, and imported into an excel spreadsheet, which does not work in Windows 10. How do I get the data from the RS-232 to USB converter into excel, so that I can format it properly, even have it properly formatted for entry to the sheet?

To community members: I am willing to pay for a simple program that does what I need and runs on Windows 10 and Excel. 

3 Replies
I think you best search on-line using the brand and type of the connector on how you're supposed to get data from the peripheral you connected this way, hopefully there is some documentation?

@Jan Karel Pieterse Thanks, he peripheral is rather old, and I am using the prototcol they offer, RS232, which is working well with an old operating system. I am attempting to modernize the arrangement, by converting the rs232 to USB. It is once the data is introduced to the PC that I do not know how to import into EXCEL.

Hmm, sorry for confusing things. I was thinking about documentation of the RS232 to USB cable. It should normally come with a driver and have some form of documentation. Perhaps it adds a virtual COM port to your system. I know there is VBA code available that is able to receive data from COM ports using the RS232 interface. See: https://social.msdn.microsoft.com/Forums/office/en-US/0d05ec74-7f75-4fb3-ac28-30130c44cf3b/excel-201...
Related Conversations
Pulling data from one tab to another
krysphares in Excel on
6 Replies
Decimal separator after CSV import
Luca Rivoira in Excel on
6 Replies
How to export Office 365 mailbox to PST?
alainajodi in Office 365 on
8 Replies
Maps Data for Scotland
Chris Nicol in Excel on
19 Replies