Can anyone help me to convert files csv to prn?

Asked By April Rosas 30 points N/A Posted on - 01/22/2013

Hi,

I have not much more experience how to convert files CSV to PRN. I have 24 amount of CSV file to convert. As I do not know the system so I can not convert this CSV files to PRN. Anybody here to help me. Let me know the system of convert files CSV to PRN.

Thanks

• Status: Open
• Question Views: 3447
• Answer Count: 3
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Riley weaver

Go To Solution

Answered By Bowl Louise 0 points N/A #151331

Can anyone help me to convert files csv to prn?

Hello

I found application which will do work for you. It can convert CSV (comma separated value) into any tex file including prn.

Just download it from this site: http://www.fileguru.com/CSV-To-Shapefile-Converter/info and start using it. It is free application but it's very capable of doing it's job. You'll have to download around 23 MB of data.

I hope I helped, cheers.

About Bowl Louise

Questions
0

Answers
101

Best Answers
20

• Vote Up 0 Vote Down

• Posted on - 01/22/2013
• Question Category: MS Excel

Answered By Abbot Nimrod 0 points N/A #151332

Can anyone help me to convert files csv to prn?

Hi there: A quick way to convert the file is to open the .CSV in excel. Once that’s done, you may try save the same file with file type .prn. If that’s not what you need, there are excel macros available that can do the conversion. Here is one macro: www.excelbanter.com/showthread.php?t=374300. Hope this solves your issue.

About Abbot Nimrod

Questions
1

Answers
30

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: MS Excel

Best Answer

Best Answer

Answered By Riley weaver 10 points N/A #151333

Can anyone help me to convert files csv to prn?

Hi Rosas,

To do so, I think it would be better if you open few files together and then hit F12 and a new box will appear; now near the bottom you will see “save as type”, from the dropdown menu select .pnr or select “Formatted Text (Space delimiter)”. Now just hit save button.

Also you can try the macro in this below link. It works fine in the mentioned versions at the bottom of the page.

https://support.microsoft.com/en-us/help/249885/formatted-text–prn-is-limited-to-240-characters-per-line-in-excel

Best regards,

Riley Weaver.

About Riley weaver

Questions
2

Answers
228

Best Answers
103

• Vote Up 0 Vote Down

• Posted on - 01/23/2013
• Question Category: MS Excel